Multiple Emails with Multiple Triggers

[Robert Johnson]

I have an application of Form Emailer where I need one email sent immediately. This notifies the department that someone has completed the online placement exam. They would go into the spreadsheet and process the exam to obtain the score. This is when they would manually process the exam to send the email to the student letting them know the results and recommended placement in the Spanish program. The important part is that I don't want the student to receive an email before the test is processed. I have one that needs to be sent upon form submission but the other email only sent through the process manually option.

Henrique had commented back to me that  it is possible to make such setup, but it involves writing some formulas on your spreadsheet and a somewhat complex setup on FormEmailer Settings page.

Has anyone had experience with this or possibly have details or an example I could follow?

[Dan Longley]

I think I've actually done something very similar to this...

I receive a booking form from a client. FormEmailer then immediately sends out a reply to the client to confirm we've received their form and that we need 3 days to process. Within 3 days I manually send an 'acceptance' email. To send this email, I simply type A in the last column of the client's row, and delete the contents of the first cell in the same row (to get FormEmailer to reprocess the row). The client then receives an 'acceptance' email from me with different info in. I also have other pre-composed emails that can be sent in the same way.

If this sounds like what you want to do let me know and I'll show you how I did it.

dan

--
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.

[Robert Johnson]

Dan,

Thanks for the reply. That sounds like it is exactly what I am looking for. I would appreciate anything you can provide me.

On Monday, February 10, 2014 11:44:22 AM UTC-6, Dan Longley wrote:

I think I've actually done something very similar to this...

I receive a booking form from a client. FormEmailer then immediately sends out a reply to the client to confirm we've received their form and that we need 3 days to process. Within 3 days I manually send an 'acceptance' email. To send this email, I simply type A in the last column of the client's row, and delete the contents of the first cell in the same row (to get FormEmailer to reprocess the row). The client then receives an 'acceptance' email from me with different info in. I also have other pre-composed emails that can be sent in the same way.

If this sounds like what you want to do let me know and I'll show you how I did it.

dan

[Dan Longley]

 Hi Robert

Here's a video of how I send emails at different times - let me have any suggestions for better ways of achieving what I'm doing! I know there must be better ways. I'm particularly struggling with arrayformula in this particular set up.

http://youtu.be/zI218qFzOK8

Good luck with your own project.

Dan

[Robert Johnson]

Dan,

That definitely provides me with a much better solution. Similar to you I am having issues with the arrayformula aspect but this has provided me with something that is workable for now so I can get back on other projects of growing importance. I will be looking to revisit this to truly automate every aspect so I will keep you posted if I come across other ways that may benefit you. Thanks again!

On Monday, February 17, 2014 3:57:27 PM UTC-6, Dan Longley wrote:

 Hi Robert

Here's a video of how I send emails at different times - let me have any suggestions for better ways of achieving what I'm doing! I know there must be better ways. I'm particularly struggling with arrayformula in this particular set up.

http://youtu.be/zI218qFzOK8

Good luck with your own project.

Dan