New Sheet trigger issue

[Rob]

Here is an issue I have experienced after manually installing formEmailer into a new sheets/form.

After copy/pasting script into new .gs file, and running authorization and install, everything set up fine. I then added formSubmit trigger to method timeDriven. I then proceeded to advance settings and defined a formula column. Everything was looking good.

When I submitted a form, what happened was after sending the email to the form submitted row, the script continued to attempt sending an email for every blank row in the sheet. It was going crazy!  I quickly deleted all the blank rows (the default in new scripts is 1000), and it stopped. 

Not sure why this works differently in new sheets, but I would advise any users attempting a manual install into new sheets, to be sure and delete any extra rows before running script. Not sure if this was caused by formSubmit trigger, or something else.

On a second form submit trial, it worked just fine.

[Henrique Abreu]

It has nothing to do with the new Sheets, you're experiencing an old known behavior, please read the threads below:

Error sending email: Exception: Invalid email: #N/A
Auto email reply cannot run

Suddenly Sending Multiple Blank Emails

Also, I recommend using a time-driven trigger (every 5 minutes or so) instead of a on-form-submit. As it's described on the FormEmailer site and sheet in your spreadsheet. And that's even why I called the function "timeDriven".

That said, on-form-submit should work fine for low-concurrency forms submits. 

Regards,

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.