No emails are sent automatically. They can be processed manually, though.

144 views
Skip to first unread message

Casey Stinnett

unread,
Nov 24, 2014, 11:29:26 AM11/24/14
to forme...@googlegroups.com
I cannot get FormEmailer to process automatically. I have confirmed that the function, timeDriven, is running because I added a function on the first line of that function that proved it is being run. So timeDriven is being run, but no emails are sent. 

I am using the new Google Sheets, I have a trigger on timeDriven, and I can process emails manually without a problem.

How do I find out what is stopping the emails from being sent when no error messages are being shown?

Henrique Abreu

unread,
Nov 24, 2014, 12:44:05 PM11/24/14
to FormEmailer on behalf of Casey Stinnett
Try opening the script editor and run the timeDrive function directly. If nothing happens and you get no error message it'll be very weird.

What do you have on your FormEmailer status column?

Henrique Abreu

--
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 http://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

Casey Stinnett

unread,
Nov 24, 2014, 2:52:28 PM11/24/14
to forme...@googlegroups.com
I tried running timeDriven directly and it didn't do anything. The status in the first column did not change. Nothing seemed to happen. Attached is the screen shot of the error I got about line 1171 and a deprecated API.


On Monday, November 24, 2014 10:44:05 AM UTC-7, Henrique Abreu wrote:
Try opening the script editor and run the timeDrive function directly. If nothing happens and you get no error message it'll be very weird.

What do you have on your FormEmailer status column?

Henrique Abreu
API deprecated.docx

Henrique Abreu

unread,
Nov 24, 2014, 3:01:00 PM11/24/14
to FormEmailer on behalf of Casey Stinnett
Please send a print of the status column.

Henrique Abreu

Casey Stinnett

unread,
Nov 24, 2014, 3:20:51 PM11/24/14
to forme...@googlegroups.com
I have attached a screen shot of my first column. This is after having manually run all rows.


On Monday, November 24, 2014 1:01:00 PM UTC-7, Henrique Abreu wrote:
Please send a print of the status column.

Henrique Abreu
Form Emailer First column.docx

Henrique Abreu

unread,
Dec 5, 2014, 8:08:26 AM12/5/14
to FormEmailer on behalf of Casey Stinnett
Ok, so the time driven function, in order not to resend emails every time, only process rows where the status row is empty. If there's anything there, it'll consider it was already processed.

Henrique Abreu

Casey Stinnett

unread,
Dec 31, 2014, 3:50:04 PM12/31/14
to forme...@googlegroups.com
It worked! Thank you for clarifying that. I knew you would come through! You are awesome and so is the FormEmailer.


On Friday, December 5, 2014 6:08:26 AM UTC-7, Henrique Abreu wrote:
Ok, so the time driven function, in order not to resend emails every time, only process rows where the status row is empty. If there's anything there, it'll consider it was already processed.

Henrique Abreu
Reply all
Reply to author
Forward
0 new messages