Deleting Triggers

52 views
Skip to first unread message

ande2413

unread,
Aug 7, 2012, 2:49:16 PM8/7/12
to forme...@googlegroups.com
Hello,
First off I love FormEmailer.  At my school we are attempting to use FormEmailer as an electronic Event Request Form.  In the form the user must choose from a list of designated approvers.  I have a nested substitution formula that converts a name into an email address, which is used to send the form to the appropriate person/group.  The problem is, FormEmailer wants to send an email for every row in the spreadsheet where the formula is active - even in rows containing no data.  My guess is this has to do with the triggers.  Is there anyway to only send an email on a formsubmit?  Muito Obrigado!    

Henrique G. Abreu

unread,
Aug 7, 2012, 3:09:57 PM8/7/12
to FormEmailer on behalf of ande2413
Hi ande2413,

Please read the following answers I gave on similiar doubts:
https://sites.google.com/site/formemailer/group?place=msg%2Fformemailer%2FD8hQTh8YWpg%2Faq2kaUCZ4s8J
https://sites.google.com/site/formemailer/group?place=msg%2Fformemailer%2FXgqw6-Cau2g%2FikLXXSt7z1cJ

If you still have any doubts after reading them, please ask, don't be shy.

Kind regards,
Henrique G. Abreu


On Tue, Aug 7, 2012 at 3:49 PM, FormEmailer on behalf of ande2413 <forme...@googlegroups.com> wrote:
Hello,
First off I love FormEmailer.  At my school we are attempting to use FormEmailer as an electronic Event Request Form.  In the form the user must choose from a list of designated approvers.  I have a nested substitution formula that converts a name into an email address, which is used to send the form to the appropriate person/group.  The problem is, FormEmailer wants to send an email for every row in the spreadsheet where the formula is active - even in rows containing no data.  My guess is this has to do with the triggers.  Is there anyway to only send an email on a formsubmit?  Muito Obrigado!    

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To view this discussion on the web visit https://groups.google.com/d/msg/formemailer/-/0aYOoyah570J.
To post to this group, send email to forme...@googlegroups.com.
To unsubscribe from this group, send email to formemailer...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/formemailer?hl=en.

Reply all
Reply to author
Forward
0 new messages