CODEWITHSUNDEEP
google-apps-scripttriggersgoogle-sheets
user1505479
user1505479

Reputation: 1

Specifying what row to start onEdit Google Script

I want this onEdit script on google Spreadsheet to start with Row 2, which skips my header row, but I cannot get it to work with my existing code? Can someone out there help a noob out?

function onEdit(e)
{
  var ss = e.source.getActiveSheet();
  var rr  = e.source.getActiveRange();


//comment 2 lines below if you want it working on all sheets, not just on 2nd one
  if(ss.getIndex()!= 1)
    if(ss.getIndex()!= 2) 
      if(ss.getIndex()!= 3) 
  return;
 ///

  var firstRow = rr.getRow();
  var lastRow = rr.getLastRow();

//the last modified date will appear in the 43th column which is the Last Update Column
  for(var r=firstRow; r<=lastRow; r++)
    ss.getRange(r, 43).setValue(new Date());
}

Upvotes: 0

Views: 4369

Answers (1)

Mogsdad
Mogsdad

Reputation: 45710

Just check if the current row is within the header, and exit the trigger:

function onEdit(e)
{
  var rr = e.range;
  var ss = e.range.getSheet();

  var headerRows = 1;  // # header rows to ignore

  if (rr.getRow() <= headerRows) return;
  ...

Upvotes: 1

Related Questions