# New Row in Spreadsheet for Every User

**URL:** <https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475>\
**Category:** Ask for Help\
**Created:** [April 5, 2020, 11:29pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475 "2020-04-05T23:29:59Z")\
**Posts on this page:** 1\
**Showing post:** 56

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [April 14, 2020, 12:11pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/56 "2020-04-14T12:11:15Z")

</div>

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

---

_[View the full topic](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475)._