- 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?
- BenAnswered on October 19, 2014 at 06:48 AM
I would suggest taking a look at the installable Google Apps triggers in Google Spreadsheet.
You can see more about this here:
and I believe that you should use them with onPOST. You can see more about that here:
Do let us know how it goes and if you have any further questions.