I have a Google form that feeds a spreadsheet with responses.
The sheet has a script with an installable trigger that is supposed to run on every form submission:
!g
Asked
Active
Viewed 1.2k times
11
-
Tried to add a trigger 'On form Submit' and worked as intended for me. – KRR Feb 02 '15 at 22:15
-
Yes, and in another form I have the trigger is running well. I changed the trigger to "once a minute" and it also works fine. – Feb 03 '15 at 09:27
1 Answers
16
I've had the same problem with scripts attached to spreadsheets not triggering on form submission. Try deleting the trigger, creating a new version of the script (File menu > Manage versions...) & then recreating the trigger.
Dean Ransevycz
- 933
- 8
- 22
-
7Just did a delete and recreate – *identical* trigger – and had my script successfully run. Disconcerting, but glad it's working. – Charlie Schliesser Jun 22 '16 at 23:44
-
5
-
1Hi, I had something similar but not exactly. Script sometimes works sometimes not... – Marcin Trofiniak Sep 08 '20 at 12:00