New answers tagged google-apps-script-triggers
0
votes
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 ...
- 3,306
0
votes
Why would I be getting the error: Too many simultaneous invocations: Spreadsheets on a simple once a day trigger?
According to https://developers.google.com/apps-script/guides/services/quotas, quotas are per account and per day, so triggers created for other project scripts may be consuming your account quota.
...
- 44.6k
0
votes
Why does my script return a TypeError when comparing getA1Notation to a string?
onEdit(e): Sheet Name & Range
Simple onEdit(e) trigger that verifies the edited range and the sheet name
function onEdit(e) {
if ((e.range.getA1Notation() == "B3") &&
...
- 3,306
0
votes
onEdit only updates top row after pasting (editing) multiple rows
You should loop through each cell of e.range to achieve your goal. i.e.:
function onEdit(e) { myFunction(e) };
function myFunction(e) {
let dateTime = Utilities.formatDate(new Date(), "EST-8&...
- 111
Top 50 recent answers are included