“SpreadsheetApp.getUi() cannot be called from this context”

by

Ui Dialogs can not be called by time triggered functions, they have to be triggered by a user action, that’s to say a click on a menu item or some sort of button that calls the function showing the UI.

More Related Contents:

  1. Google Sheets OnEdit() – You do not have permission to call a service
  2. onEdit simple trigger never seems to be triggered
  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. How to protect the Apps Script code in a Google spreadsheet?
  8. Automatic timestamp when a cell is filled out
  9. Apps Script: how to get hyperlink from a cell where there is no formula
  10. Script to Change Row Color when a cell changes text
  11. You do not have permission to call openById
  12. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  13. Single Google Form for multiple Sheets [duplicate]
  14. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  15. How to replace text in Google Spreadsheet using App Scripts?
  16. copy data from one sheet to another in google app script and append a row, one small issue
  17. Using built-in spreadsheet functions in a script
  18. Google App Scripts cannot be given Authorization or Permission
  19. How to get the correct range to set the value to a cell?
  20. Refresh data retrieved by a custom function in Google Sheet
  21. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  22. Dynamically creating spreadsheet menu items
  23. Increment Cell value by one by clicking
  24. email notification if cell is changed
  25. Dynamic selection options in Google Apps Script for forms
  26. Determine current user in Apps Script
  27. How to ignore empty cell values for getRange().getValues()
  28. Use script in all spreadsheets
  29. Custom Functions and Recalculation
  30. google script detect empty cell after edit or delete

Leave a Comment