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

  • Profile Image
    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 Form with Google Spreadsheet

  • Profile Image
    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.