Google-sheets – How to set this up to run two onedit functions in the same sheet

google sheetsgoogle-apps-script

all

If you put the two together they don't work
What is the right code to work together
Note that the first to arrange automatic
The second is to set the date if you put only one works, but if you add the other all stops working

function onEdit(event){
  var sheet = event.source.getActiveSheet();
  var editedCell = sheet.getActiveCell();

  var columnToSortBy = 13;
  var tableRange = "A2:Y";

  if(editedCell.getColumn() == columnToSortBy){   
    var range = sheet.getRange(tableRange);
    range.sort( { column : columnToSortBy } );
  }
}


{
function onEdit(e) {
var sh = e.source.getActiveSheet();
var sheets = [];
var ind = [2].indexOf(e.range.columnStart);
  var stampCols = [13]


if(sheets.indexOf(sh.getName()) ==-1 || ind == -1) return;
sh.getRange(e.range.rowStart, stampCols[ind]).setValue(typeof e.value == 'object' ? null : new Date )


}
}

sheet test
https://drive.google.com/open?id=1mFqHdeF6l25XeyIOXwcdKqnYC27BrvZd1MaskHNAdJc

Best Answer

function onEdit(e){

 onEdit1(e);

  var sheet = event.source.getActiveSheet();
  var editedCell = sheet.getActiveCell();

  var columnToSortBy = 13;
  var tableRange = "A2:Y";

  if(editedCell.getColumn() == columnToSortBy){   
    var range = sheet.getRange(tableRange);
    range.sort( { column : columnToSortBy } );


  onEdit2(e);

var sh = e.source.getActiveSheet();
var sheets = [];
var ind = [13].indexOf(e.range.columnStart);
  var stampCols = [2]

if(sheets.indexOf(sh.getName()) ==-1 || ind == -1) return;
sh.getRange(e.range.rowStart, stampCols[ind]).setValue(typeof e.value == 'object' ? null : new Date )


}
}

https://docs.google.com/spreadsheets/d/1mFqHdeF6l25XeyIOXwcdKqnYC27BrvZd1MaskHNAdJc/edit#gid=1945346364

Related Topic