- 10ninetyAsked on May 25, 2015 at 11:56 PM
- JotForm SupportChriistianAnswered on May 26, 2015 at 02:57 AM
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?
- 10ninetyAnswered on May 26, 2015 at 03:08 AM
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
- 10ninetyAnswered 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??
- 10ninetyAnswered on May 26, 2015 at 03:26 AM
yeah but your answers never show on this thread?? very frustrating and backwards
- JotForm SupportChriistianAnswered on May 26, 2015 at 03:59 AM
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.
- alp_denizAnswered on October 04, 2015 at 12:20 AM
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:
Thank you very much for your patience and understanding. Please let us know if you need any assistance.
All the best