On form submit trigger not working

问题:

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:

I've also set up this trigger to notify me when there are execution failures.

However, the trigger is never executed and I am never notified.

I have ran the script mannualy and it works well. I have also given the necessary permissions to execute it.

There are no errors being thrown, it just doesn't run.

Why not?

回答1:

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.