Google Spreadsheet: Script not triggered on update of sheet

  • 10ninety
    Asked on May 25, 2015 at 11:56 PM
  • Chriistian Jotform Support
    Replied on May 26, 2015 at 2:57 AM

    Hi 10ninety, 

    Thanks for contacting us.

     

    May I ask if you have edited your form's integrated Google Spreadsheet? Editing the spreadsheet will break the integration in your form. 

     

    I would recommend you to re-integrate the form to Google Spreadsheet and see if it works. Old submissions will be carried over to the new sheet that will be created.

     

    If your problem persists, can you provide us more details on your concern like the form name/link?

     

    Regards.

  • 10ninety
    Replied on May 26, 2015 at 3:08 AM

    Hi yes,

     

    But that's not how it used to work as I have a script that should be fired once the sheet is updated!!! the sheet is still getting updated but the trigger is not getting fired

  • 10ninety
    Replied on May 26, 2015 at 3:16 AM

    I have only added a script to the form and everything works except the googles fire event which was mentioned in the original thread that I posted this into...which i'm guessing was never answered/resolved??

  • 10ninety
    Replied on May 26, 2015 at 3:26 AM

    yeah but your answers never show on this thread?? very frustrating and backwards

  • Chriistian Jotform Support
    Replied on May 26, 2015 at 3:59 AM

    Hi 10ninety,

     

    Sorry for the confusion regarding the thread. Ideally, we ask every user to post a thread for his/her own concern and only one thread per issue (per user).

     

    Anyways, this was an existing issue that seems to be not yet resolved. I raised a ticket to our developer team for them to re-check this out. We will inform you the soonest they find a solution/fix to this issue.

     

    Regards.

  • alp_deniz
    Replied on October 4, 2015 at 12:20 AM

    Hello,

    Unfortunately, this behavior is defined by Google's policies and external changes cannot trigger Google app scripts.

    However, there is way to get over it by using a time-based trigger and saving the last edit date on a different document. It is not actually too difficult as fully described here:

    http://stackoverflow.com/a/28240569/2378247

    Thank you very much for your patience and understanding. Please let us know if you need any assistance.

    All the best