Skip to main content
2 votes

Prevent edits to an Apps Script project bound to a Google Sheet

There is currently (January 2024) no turnkey way to prevent users who have editor access to a Google Sheet from modifying a script project bound to that Google Sheet. The supported way to use Apps ...
doubleunary's user avatar
  • 14.9k
2 votes
Accepted

Determine if onEdit() was triggered by inserting or removing a row

row and column information isn't available via onChange() You can determine the active row and column in an installable "on change" trigger like this: const ss = SpreadsheetApp.getActive()...
doubleunary's user avatar
  • 14.9k
1 vote
Accepted

How to do autoresizecolumns() in a Google Sheets file when data imported from another Google Sheets file is changed

Use Installable Trigger Instead of using the simple trigger onOpen(e) bound to Staff Contacts, use an installable trigger in Staff Roster to make the change in Staff Contacts whenever Staff Roster is ...
Blindspots's user avatar
  • 6,035
1 vote
Accepted

How can I Speed up an onEdit script so that it captures all subsequent edits?

onEdit(e) performance is dominated by the number of API calls it makes. The code in the question is using many SpreadsheetApp calls which make it run slowly: 6 API calls every time, regardless of ...
doubleunary's user avatar
  • 14.9k
1 vote

Blinking cells in Google Sheets

Edited Script function onOpen(e) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var mysheet = ss.getActiveSheet(); for(var i=0; i<38; i++) { (i) && Utilities.sleep(400); ...
Blindspots's user avatar
  • 6,035

Only top scored, non community-wiki answers of a minimum length are eligible