Automatic Email When Form is Submitted

[Dave]

Hello - I'm new to doing a google form, and do not have any programming experience.  I'm pretty sure I followed the instructions properly.  I've installed the FormEmailer script successfully, and have installed the "Email auto reply after form submission".  It's not working.  B5 still says "no" after waiting for a while, and an error message of "Email not Sent - Invalid Email Address" is in column B of the form's spreadsheet. Also, when testing the form out, and trying send a confirmation manually (which I would rather NOT do - want it to do it automatically), it says"Quota minimum limit reached. Process stopped at line 3".  One thing I did, which may have caused a problem, is that I changed the From to my name instead of "FormEmailer".  HELP!

[Eola Federation]

Dave - I am trying to do the same thing ... where did you find the "Email auto reply after form submission"?

[Dave]

Assuming you have already run the script for FormEmailer, go to the "FormEmailer" page of the spreadsheet. This is explained in the A5 cell of that page under "New Install Instructions".  In any event, click on the Tools tab, select "script editor".  "Email auto reply after form submission" is one of the four choices.  I'm not sure that's the right thing to do.  I'm a novice at googleforms.

[Stuart UK]

From the Script Editor (on the spreadsheet - tools --> script editor)

Click on the Resources Tab and select Current Projects Triggers

Then add another trigger. Time Driven | From Spreadsheet | On Form Submit


Hope this works for other too.

Cheers

Stuart

[Jason Spartz]

I tried this (Time Driven | From Spreadsheet | On Form Submit) but it's not working.  Any thoughts?  If I can get it working this script will be doing everything I need!!!

Thanks,

Jason

[Henrique Abreu]

Which function are you setting the trigger to run?

This is first dropdown on the trigger setup popup.

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/groups/opt_out.
 
 

[Jason Spartz]

I can get "time-driven" to work for a single entry but it then also fills in all the empty cells in the column listing "email not sent".  Which means that when new form data comes into the spreadsheet, the script is not sending an email because the cell already has email not sent.  Here is a clip from my spreadsheet.  Any thoughts? 

On Tuesday, July 2, 2013 11:52:21 AM UTC-5, Henrique Abreu wrote:

Which function are you setting the trigger to run?

This is first dropdown on the trigger setup popup.

Henrique Abreu

[Jason Spartz]

I should add that I am using an array formula to calculate subtotals from the form data.  Those values update when new entries come in (notice the series of "18" in the far right column on the image).  I assume that is what might be triggering the "email not sent" status in the first column.  Is my issue to be fixed in the script or in the array formula?  If it helps, here is my array formula...  =ARRAYFORMULA(M2:M+O2:O+Q2:Q-L2:L-N2:N-P2:P+18)

Jason