CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgs-installable-triggers
Alcyone
Alcyone

Reputation: 15

Installable Trigger not triggered

I have installable trigger in my spreadsheet, however when i edit the sheet the trigger is not triggered

the installable trigger screenshoot

before is my trigger is fine, i already delete and add new trigger but still no triggered.

project details screenshoot

---Edited ---

this my configuration for each trigger

newRow function trigger configuration

triggerpls function trigger configuration

this the code i want to running

function triggerpls() {
  Utilities.sleep(2000);
  console.log("triggered");
}

function newRow(e) {
  
  var ROW_MODIFIED = ["INSERT_ROW"];
  if(ROW_MODIFIED.indexOf(e.changeType) == -1) return;
  
  var sheet = SpreadsheetApp.getActiveSheet();
  var currentCell = sheet.getCurrentCell();
 
  var maxRows = sheet.getMaxRows();
  
  
  var range = sheet.getRange(2, 1, maxRows);
  
  
  var values = range.getValues();
  
  var higher = Number(values.sort(function(a,b){return b-a})[0]);
  currentCell.setValue(higher + 1);
  

}

Upvotes: 0

Views: 230

Answers (1)

Cooper
Cooper

Reputation: 64062

Try this:

The onChange() event only works on user edits. It does not work when a script or a cell function makes an edit.

function newRow(e) {
  e.source.toast('Entry');
  Logger.log(JSON.stringify(e));
  var sh=e.source.getActiveSheet();
  if(sh.getName()=='Sheet2' && e.changeType=='INSERT_ROW') {
    var v=sh.getRange(2,1,sh.getLastRow(),1).getValues().map(function(r,i){return r[0];}).filter(function(e){return e;});
    var h=Number(v.sort(function(a,b){return b-a})[0]);
    sh.getCurrentCell().setValue(h+1);
  }
}

Upvotes: 1

Related Questions