Google Spreadsheet: Script not triggered on update of sheet

  • Profile Image
    10ninety
    Asked on May 25, 2015 at 11:56 PM
  • Profile Image
    Chriistian
    Answered on May 26, 2015 at 02: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.

  • Profile Image
    10ninety
    Answered on May 26, 2015 at 03: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

  • Profile Image
    10ninety
    Answered on May 26, 2015 at 03: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??

  • Profile Image
    10ninety
    Answered on May 26, 2015 at 03:26 AM

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

  • Profile Image
    Chriistian
    Answered on May 26, 2015 at 03: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.

  • Profile Image
    alp_deniz
    Answered on October 04, 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