In trigger send mode does not work

Question

I have a Google form that submits a spreadsheet with answers.

The worksheet has a script with an installation trigger that should be run on every form submission:

I also set this trigger to notify me when there are runtime errors.

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

I ran a mannualy script and it works well. I also granted the necessary permissions to execute it.

Errors do not occur, it just does not start.

Why not?

Answer 1

I had the same problem with scripts attached to spreadsheets that do not start when the form is submitted. Try removing the trigger by creating a new version of the script ( File menu> Manage versions... ), and then recreate the trigger.