How to get onFormSubmit to trigger automatically?

by

Read Understanding Triggers. This function is an Installable Trigger, so you need to set it up to run when a form is submitted. It’s easy – I would have thought a Forms tutorial would have walked through it.

In the Script Editor:

  1. Choose Edit > Current project’s triggers. You see a panel with the message No triggers set up. Click here to add one now.
  2. Click the link.
  3. Under Run, select the function you want executed by the trigger. (That’s onFormSubmit(), in this case.)
  4. Under Events, select From Spreadsheet.
  5. From the next drop-down list, select On form submit.
  6. Click Save.

From this point on, the function will be triggered whenever a form is submitted to the spreadsheet.

If you plan to share your script, each recipient will need to repeat these steps.

As an aside, you should change the email setting in your script, so it will work for ANYONE.

var email_address = Session.getActiveUser().getEmail();

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. How do you create a “reverse pivot” in Google Sheets?
  3. Create Google Calendar Events from Spreadsheet but prevent duplicates
  4. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  5. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  6. Retrieving Google Sheets cell border style programmatically
  7. Determining the last row in a single column
  8. Cannot find method getRange(number,number)?
  9. How do I add formulas to Google Sheets using Google Apps Script?
  10. Deleting rows in google sheets using Google Apps Script
  11. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  12. Single Google Form for multiple Sheets [duplicate]
  13. Adding Buttons To Google Sheets and Set value to Cells on clicking
  14. Custom function throws a “You do not have the permission required to setValue” error
  15. Margins parameters for Google spreadsheet export as PDF
  16. Google Apps Script: Dynamically creating spreadsheet menu items
  17. Script to convert .XLSX to Google Sheet and move converted file
  18. Hidden field in a Google Form
  19. Apply multiple font colors to the text in a single Google Sheets cell
  20. How to evaluate a spreadsheet formula within a custom function?
  21. Google Sheet use Importxml error could not fetch url [duplicate]
  22. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  23. Use script in all spreadsheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment