Google form trigger options missing

Question

I am implementing a Paid Time Off request workflow. Google provides all the code for this in Request and approve time off Apps Script Enhancement.

I ran into a few issues and have fixed all of them except one; I cannot get the trigger I want. The instructions say to set up a trigger as follows: Click "Resources>Current Projects Triggers" Setup a new trigger. - The first field you should select "OnFormSubmit", select “From spreadsheet” for the second field, and the third field select "On Form Submit". - Optionally click notifications and set-up an email address that will receive failure notifications. - Save

I select "OnFormSubmit" in the Run field as instructed but in the Event field, the only option I can select is Time-driven.

Answer 1

I followed the tutorial example and was able to recreate the conditions described by it and not your problem.

The instructions in that tutorial say you should start from a copy of the spreadsheet example. Is this what you did or have you tried a blank Script project not bound to a spreadsheet?

If you have copied the code from the example into a Google Apps Script standalone script, the "From Spreadsheet" events will not be available to you. They are only available if you write you code in the script editor bound into a Spreadsheet.