CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Christoph M. Dietze
Christoph M. Dietze

Reputation: 1

Is there a trigger that fires by changing a row?

Is there any option to run a function in my google-spreadsheet triggered by changing the row only (means setting the cursor in a new cell)? The Script-Guide of Google describes only the following ChangeTypes:

EDIT
INSERT_ROW
INSERT_COLUMN
REMOVE_ROW
REMOVE_COLUMN
INSERT_GRID
REMOVE_GRID
FORMAT
OTHER

I am looking for a Trigger like CHANGE_ROW.

Upvotes: 0

Views: 40

Answers (1)

user3717023
user3717023

Reputation:

No, a user moving the cursor around does not create an event for any trigger in Google Sheets.

The best you can do is run a timed trigger than gets Active Cell and compares the row value with the one stored previously. But this is unlikely to have satisfactory performance, because a timed script can't run more often than once a minute (and if you try to keep it running in a loop, it will hit execution time quotas).

Upvotes: 1

Related Questions