What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Spreadsheet: Script not triggered on update of sheet

    Asked by 10ninety on May 25, 2015 at 11:56 PM
    doesn't work sheet work
  • Profile Image
    JotForm Support

    Answered by Chriistian 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

    Answered by 10ninety 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

    Answered by 10ninety 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

    Answered by 10ninety on May 26, 2015 at 03:26 AM

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

  • Profile Image
    JotForm Support

    Answered by Chriistian 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
    JotForm Support

    Answered by alp_deniz 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