New Google spreadsheet onEdit set focus to a cell not working

1
votes

If I type a ID in column1, I am trying to get the some text related to that ID and show in column2 and set the focus to column3. This worked perfectly so far and the code is given below. Now I migrated to the new google spread sheet and the focus part is not working. As per the below link this feature is now removed. Is there any other way to do this please?

function onEdit(event)
{
  //Removed some other code for clarity.

  RangeTest();
}



function RangeTest()
{
   var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
   var nextTarget = ss.getRange(2, 2);
   ss.setActiveRange(nextTarget);   
   Logger.log("Focus Set");
}

<sheet>.setActiveRange() seems to have stopped working with onOpen trigger

Google Script - OnEdit problems

Google Sheets getActiveRange on change

2
google-apps-scriptgoogle-sheets

2 Answers

1
votes

You can't trigger setActiveRange from an onEdit trigger since April 17 2014

0
votes

Instead of using a simple onEdit trigger use an installable onEdit trigger.

Reference