Google Spreadsheet script not being executed when a new record is added to it

daniellewis
Asked on January 02, 2015 at 02:12 PM

Hi there,

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 Forms with Google Sheets

Page URL:
http://www.jotform.ca/form/43516772148257
raul
Answered 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.
Thanks.