- daniellewisAsked on January 02, 2015 at 02:12 PM
I need a Google Apps Script to execute upon form submission. When I submit a jotform, the info gets added to a new row of the Google spreadsheet it’s linked to, but the “On Change” trigger I added doesn’t seem to activate. (It triggers properly when I make a manual edit to the spreadsheet). Does anyone have a solution or workaround for this? I think that it’s not triggering because of a bug in Google Sheets; see https://code.google.com/p/google-apps-script-issues/issues/detail?id=4391 . If my assessment is correct and you don’t have a solution/workaround, please star the issue linked to above in order to convince Google to fix it. Thanks.
This is a re-post of a comment on How to Integrate Form with Google Spreadsheet
- raulAnswered on January 02, 2015 at 02:45 PM
For what I understand from the provided link the issue is happening on Google's side. We do use their API to add new rows to the sheet when a new submission is captured in your form.
Unfortunately, it's out of our scope the priority that Google is giving to this bug. Hopefully, they can provide a fix for it soon.
Let us know if you need further assistance.