onEdit simple trigger never seems to be triggered

by

The onEdit() trigger is a so called “simple trigger” that has a limited field of action.
Since it runs automatically and silently under the authority of the active user it can’t do anything that requires authorization, for example it can’t send emails !

The solution is simple : change your function name to something else (myOnEdit for example) and set an installable onEdit trigger to run that function.(menu ressource/current script trigger/create new trigger in the script editor.)

This time it will be executed as you (you’ll be sending the emails) when anyone edits the spreadsheet.

Documentation on that subject is available here.

More Related Contents:

  1. Google Sheets OnEdit() – You do not have permission to call a service
  2. “SpreadsheetApp.getUi() cannot be called from this context”
  3. How to allow onEdit function to affect protected cell in a Google Sheet?
  4. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  5. google script openById : You do not have permission to perform that action
  6. e.range.getA1Notation() unable to track changes caused by formula update
  7. Moving google apps script to v8 file upload stopped working from sidebar
  8. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  9. How do I make a Sidebar display values from cells?
  10. button click is only working on Windows & not working on Android mobile sheet
  11. No permission to call msgBox in Google Apps Scripting
  12. How to define global variable in Google Apps Script
  13. Periodically refresh IMPORTXML() spreadsheet function
  14. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  15. Format a Google Sheets cell in plaintext via Apps Script
  16. UiApp has been deprecated. Please use HtmlService instead
  17. How to get form values in the submit event handler?
  18. Google app scripts: email a spreadsheet as excel
  19. Is there a way to keep two sheets synchronized?
  20. Selecting the last value of a column
  21. Google apps script to email google spreadsheet excel version [duplicate]
  22. use onedit() trigger on a specific sheet within google scripts for google sheets
  23. Measurement of execution time of built-in functions for Spreadsheet
  24. onEdit() doesn’t catch all changes
  25. Google Spreadheets Scripts: check if cell is empty
  26. Custom Functions with add-ons?
  27. How to prefill Google form checkboxes?
  28. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  29. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?
  30. Passing cell references to spreadsheet functions

Leave a Comment