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.

Welcome to Stack Overflow. Please take the tour and checkout How to Ask and minimal reproducible example. Rather than a coding problem this looks to be related to the development environment. As you are using the Google Apps Script editor, add details like the basic troubleshooting steps that you already followed (trying in incognito mode, try with a different web browser), starting from scratch rather than copying a file, the kind of Google account that you are using (Consumer account or Google Apps for Work account). — Rubén

JSDBroughton JSDBroughton · Accepted Answer · 2016-04-28T11:23:47

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.

Google form trigger options missing

1 Answers