New Row in Spreadsheet for Every User

Here my code @Wiz.Wazeer

function ResetOnChange(e)
{
 var spreadsheet = SpreadsheetApp.getActive();
 var Row= spreadsheet.getCurrentCell().getRow();
 var Colum= spreadsheet.getCurrentCell().getColumn();
 var CellButtom= spreadsheet.getRange('E'+Row).getValue();
  
  //   SpreadsheetApp.getActiveSpreadsheet().toast(e.changeType) 
 if (e.changeType === 'EDIT' && Colum ==5 && CellButtom == true) 
 {
   spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Calculos'), true);  
   //  Browser.msgBox("La celda que cambio fue... " + 'E'+Row + " ... valor: "+ CellButtom);  

   var RangeToDel= "C"+ Row + ":" + "D" + Row
   spreadsheet.getRange('E'+Row).setValue(false);
   //  Browser.msgBox("Rango a Borrar: " + RangeToDel); 
   spreadsheet.getRange(RangeToDel).activate();
   spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true}); 
 }
}

As Jeef wrote above, you will need to authorize the trigger to your own google account to fire this script. At the 1st time, Google will ask your authorization for running this.

Saludos

2 Likes