GAS “On edit” trigger not running when edited from API

by

onChange installable trigger works with edits made from sheets api. It is possible to get the edited range using .getActiveRange() calls.

More Related Contents:

  1. Copying a spreadsheet copies all linked files as well
  2. email notification if cell is changed
  3. Determining the last row in a single column
  4. Moving google apps script to v8 file upload stopped working from sidebar
  5. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  6. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  7. Google Sheets OnEdit() – You do not have permission to call a service
  8. Detect user inserting row or column in a google spreadsheet and reacting in a script
  9. How to define global variable in Google Apps Script
  10. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  11. Format a Google Sheets cell in plaintext via Apps Script
  12. Selecting the last value of a column
  13. Moving Files In Google Drive Using Google Script
  14. How to get onFormSubmit to trigger automatically?
  15. onEdit simple trigger never seems to be triggered
  16. “SpreadsheetApp.getUi() cannot be called from this context”
  17. Using built-in spreadsheet functions in a script
  18. Protect ranges with google apps script
  19. How to access new ‘in-cell-image’ from google apps script?
  20. How to convert a Google Sheets-File to an Excel-File (XLSX)
  21. Difference between getValue() and getDisplayValue() on google app script
  22. How to allow onEdit function to affect protected cell in a Google Sheet?
  23. Creating and Sending sheets in the same function
  24. How do I know if spreadsheet cells are merged using google apps script
  25. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  26. Google apps script error: “You do not have permission to call protect” [duplicate]
  27. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  28. .setFormula() and received error missing ) argument list
  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