# 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:** 14\
**Page:** 3

<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 10, 2020, 10:20pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/47 "2020-04-10T22:20:51Z")

</div>

@Jeff_Hager I finally discovered my big bug!!

Let me finish some homeworks I have and come with my fuc… reset button and explanation of my failures

Thanks for your time!

Feliz fin de semana

---

<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 13, 2020, 7:02pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/48 "2020-04-13T19:02:53Z")

</div>

Hi again friends,

Here I modified my demo APP and included a Reset switch to clear the input values at the same time via script

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f660e5a90937f4c9f9020bfb06e3018845c4a4bc.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6d309fd38f559d3b4357a151320131e564d337ca.png)

You will see some lag to clear values but it is caused by Google Sheet’s script and/or your internet speed.

I hope it can be useful to anyone.

Saludos  
Gavp

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [April 13, 2020, 7:26pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/49 "2020-04-13T19:26:21Z")

</div>

😀 Fantastic!!! Send me a copy of the onChange code if you would. You can drop it in my email if not here. Let me know.

Tx

---

<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 13, 2020, 7:53pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/50 "2020-04-13T19:53:01Z")

</div>

The script is in sheet @Wiz.Wazeer … I think anyone can see/copy when the App is copied as template … or not? 🤥

Let me know if this doesn’t happen to paste it here

Saludos

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [April 13, 2020, 7:54pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/51 "2020-04-13T19:54:36Z")

</div>

🤓oops. Let me download and get back to you bro.

Tx

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [April 13, 2020, 8:29pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/52 "2020-04-13T20:29:19Z")

</div>

Okay got it. But for some weird reason not firing. Been at 5 minutes almost. Shouldn’t take that long. Also without access to your email no chance of viewing script. You’ve my email. Send me a screenshot if you could pls. Tx

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 14, 2020, 4:14am UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/54 "2020-04-14T04:14:23Z")

</div>

I think you would have to reset the trigger under your own email account. You need to authorize the trigger to your own google account for it to work.

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [April 14, 2020, 10:02am UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/55 "2020-04-14T10:02:20Z")

</div>

Jeff I still can’t get his switch to work; not his script, which I have yet to see. His button just freezes on me. I think Gvalero is working on it. Have you tested his reset function? Is it working on your side of the Atlantic ?

---

<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

---

<div class="post-metadata">

**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\
**Post date:** [April 14, 2020, 12:25pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/57 "2020-04-14T12:25:06Z")

</div>

Tx bro. Just saved me hours trying to sort it. But, for some weird reason I can’t get the reset button on your calc to fire. I have to remove the numbers manually. Pls have a look at your end again.

I’ll test it too with your code. See if we can get yours to work (the documented version), I will not need to resort to tricks.

Tx

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [April 14, 2020, 10:35pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/58 "2020-04-14T22:35:01Z")

</div>

Our User Profiles feature is released now. Video coming in a week or two.

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [April 14, 2020, 11:50pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/59 "2020-04-14T23:50:04Z")

</div>

Yeah man

---

<div class="post-metadata">

**Author:** ![Herbert\_Coleman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/herbert_coleman/32/4451_2.png) [@Herbert\_Coleman](https://community.glideapps.com/u/Herbert_Coleman)\
**Post date:** [September 26, 2020, 5:01am UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/60 "2020-09-26T05:01:27Z")

</div>

I’m not seeing the template, just the app. So I’m not clear as to how you make the reset work without a script.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 27, 2024, 6:46pm UTC](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/61 "2024-01-27T18:46:47Z")

</div>



[Previous page](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475.md?page=2)