-
HLtexasAsked on October 18, 2014 at 10:40 PM
What I want to do:
1. Webform collects information and sends it to a Google spreadsheet.
2. When the form updates, it triggers a custom script that sends the data to an email address.
I can do this using Google Forms, but when I use a Jot Form, the trigger is not pulled. How can I set up a trigger in the spreadsheet that will be activated by the JotForm?
-
BenReplied on October 19, 2014 at 6:48 AM
Hi,
I would suggest taking a look at the installable Google Apps triggers in Google Spreadsheet.
You can see more about this here:
https://developers.google.com/apps-script/guides/triggers/installable
and I believe that you should use them with onPOST. You can see more about that here:
https://developers.google.com/apps-script/guides/triggers/#getting_started
Do let us know how it goes and if you have any further questions.
Best Regards,
Ben