Trigger a function on selecting a cell

Question

How to write a trigger which gets triggered everytime the user selects any cell. The trigger will call a function which would log the row number of the highlighted cell on Google Apps Scripts

I have already written a function which is doing that:

function getCell() {
  var app = SpreadsheetApp;
  var ss = app.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();

  //get the current highlighted cell
  var cell = sheet.getCurrentCell();

  //get the row number
  var row = cell.getRow(); 

  //log the value
  Logger.log(row);

}

But I don't know how to write the trigger. Currently, I have to run the script every time I click on some other cell.

https://stackoverflow.com/a/61944971/7215091 – Cooper May 21 '20 at 22:43 — Cooper, May 21 '20 at 22:43

gary · Answer 1 · 2020-10-01T23:58:36.260

2

strange, it worked the first time....

function onSelectionChange(e){
   Browser.msgBox('cell selection change');
}

maybe things have changed since the question was posted, but landed here.

edited Oct 01 '20 at 23:58

answered Oct 01 '20 at 23:43

gary

21
3

score 1 · Accepted Answer · answered Nov 06 '18 at 21:26

1

The available triggers are described on https://developers.google.com/apps-script/guides/triggers/. An alternative that could serve as a workaround is to use the "poll technique" described on How do I make a Sidebar display values from cells?

answered Nov 06 '18 at 21:26

Rubén

34,714
9
70
166

Trigger a function on selecting a cell

2 Answers2