Cannot get trigger to work!

[Splash News]

HI, I have used this script for a while on several sheets and works well. However recently one of the spreadsheets stopped sending email alerts. I adjusted settings in the script (triggers) and looked at other settings, and kept testing the form, but never got it to work - send emails. I then recreated the entire form and installed the script fresh. I still cannot get it to work. I see the data being populated in the sheet, but the first column is showing empty. Any help would be much appreciated. Thanks - Raj

[Splash News]

On Wednesday, 6 April 2016 10:25:07 UTC+1, Splash News wrote:

HI, I have used this script for a while on several sheets and works well. However recently one of the spreadsheets stopped sending email alerts. I adjusted settings in the script (triggers) and looked at other settings, and kept testing the form, but never got it to work - send emails. I then recreated the entire form and installed the script fresh. I still cannot get it to work. I see the data being populated in the sheet, but the first column is showing empty. Any help would be much appreciated. Thanks - Raj

noticed that  'running automatically' is set to NO

[Henrique Abreu]

How many spreadsheets you have FormEmailer set up?

I think Google Apps Script has a limit on how many time-driven triggers a user can have, you may be hitting this limitation.

Also, if you run "Process Manually", does it work?

Henrique Abreu

On Wed, Apr 6, 2016 at 6:25 AM, Splash News via FormEmailer <formemailer+APn2wQfYupbZrQxwWKLk...@googlegroups.com> wrote:

HI, I have used this script for a while on several sheets and works well. However recently one of the spreadsheets stopped sending email alerts. I adjusted settings in the script (triggers) and looked at other settings, and kept testing the form, but never got it to work - send emails. I then recreated the entire form and installed the script fresh. I still cannot get it to work. I see the data being populated in the sheet, but the first column is showing empty. Any help would be much appreciated. Thanks - Raj

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at https://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

[Raj - Splash]

HI, Yes I can process manually.

We have about 17 forms setup.

Do you suggest spreading the owner of the forms across several users?

Thanks

R

You received this message because you are subscribed to a topic in the Google Groups "FormEmailer" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/formemailer/zY3Do0VLQ1E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to formemailer...@googlegroups.com.

To post to this group, send email to forme...@googlegroups.com.
Visit this group at https://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

Raj Valley

111 Salusbury Road, London, NW6 6RG

P: 0870 934 2666

  

www.SPLASHNEWS.com

[Henrique Abreu]

Yes, that might work.

Henrique Abreu

[Raj Valley]

HI, I tried that, moved the owner of the form to a different user, but still could not get the trigger to work.

please advise

Thanks

R

Raj Valley

111 Salusbury Road, London, NW6 6RG

P: 0870 934 2666

  

www.SPLASHNEWS.com

Yes, that might work.

Henrique Abreu

R

Raj Valley

<3874BAB9-263E-4AC1-BBD4-2F45B976B8D1.png>  <6671C1A7-23DE-4135-8870-4131CA0EE21C.png><F2FEEC8A-851B-499B-A501-00DE57B2A885.png>

www.SPLASHNEWS.com

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at https://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

[Roel Bertels]

Hi,

When the form (and spreadsheat?) went to the new owner, did you remove your trigger, and did the new owner set up the trigger?

Might also needed to be done.

Op donderdag 7 april 2016 13:19:16 UTC+2 schreef Splash News:

[Raj - Splash]

HI Roel, yes I did this. I just received the following:

Your script, FormEmailer, has recently failed to finish successfully. A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here.

The script is used by the document Legal Celebrity Watch Out List.

Details:

Start	Function	Error Message	Trigger	End
4/7/16 12:17 PM	onOpen	Cannot call SpreadsheetApp.removeMenuByCaption() from this context. (line 184, file "FormEmailer")	formSubmit	4/7/16 12:17 PM

Sincerely,

Google Apps Script

Raj Valley

  

www.SPLASHNEWS.com

This email is confidential and intended for the exclusive use of the addressees only. You should not disclose its contents to any other person. If you are not the intended recipient please notify the sender immediately. Splash News accepts no liability for viruses introduced by this e-mail or attachments. You should employ virus checking software.

SAVE A TREE - PLEASE DO NOT PRINT THIS EMAIL UNLESS YOU REALLY NEED TO.

[Raj - Splash]

HI, Just tested some other forms we have using the script, they have also stopped working!

On 8 Apr 2016, at 07:36, Roel Bertels via FormEmailer <formemailer+APn2wQc-az5i6Hfd4y-q...@googlegroups.com> wrote:

Raj Valley

[Henrique Abreu]

FormEmailer does not have such line of code. You're probably have another script

Henrique Abreu

[Raj Valley]

OH! thats weird, I always copt the code exactly from my saved source. I will download the latest version from your side and try a fresh install. Thanks!

Raj Valley

111 Salusbury Road, London, NW6 6RG

P: 0870 934 2666

www.SPLASHNEWS.com

[Raj - Splash]

I used a fresh install of formemailer but it did not work. None of my forms are working, no data is being populated in the spreadsheet. 

I will contact Google

Henrique Abreu

Raj Valley

<3874BAB9-263E-4AC1-BBD4-2F45B976B8D1.png>  <6671C1A7-23DE-4135-8870-4131CA0EE21C.png><F2FEEC8A-851B-499B-A501-00DE57B2A885.png>

www.SPLASHNEWS.com

This email is confidential and intended for the exclusive use of the addressees only. You should not disclose its contents to any other person. If you are not the intended recipient please notify the sender immediately. Splash News accepts no liability for viruses introduced by this e-mail or attachments. You should employ virus checking software.

SAVE A TREE - PLEASE DO NOT PRINT THIS EMAIL UNLESS YOU REALLY NEED TO.

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at https://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "FormEmailer" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/formemailer/zY3Do0VLQ1E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at https://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

[Splash News]

I recreated some of the forms and looks like its fixed. Thanks for your help

On Wednesday, 6 April 2016 10:25:07 UTC+1, Splash News wrote:

[Shane Bradley]

I believe I have been having this same issue, have done allot of searching in the Inet and have found no solutions yet.  I have the script installed on six different Google Sheets, and none of them have ran since initial install; funny thing is, and others have said this to, is that all worked as expected upon initial install, but stopped sometime after, and manual works fine - the 'timeDriven' feature is not working.  While doing some digging, found the below Google Apps Script qouta dashboard, which indicates Triggers will only work for so many hours of a day based on what edition of Google account created them (consumer, Business...) and after that I guess they are disabled, and thus no emails sent.  Wonder if this only applies to time driven triggers and not event driven (i.e. OnEdit)?

https://script.google.com/a/dryhootch.org/macros/dashboard