Hi, Is anybody able to trigger a procedure on glide to clear some cells within one raw on different columns in the sheet?

anything like this? https://multicalc.glideapp.io

Yes Exactly! it work for me one time and stop. i tried to copy it but didn’t able to reverse engineer your procedure. can you assist me pls? thanx in advance!

@SPETZ Take a look at this post and follow some steps we shared there: [image] New Row in Spreadsheet for Every User 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] [image] …

Hi, Gavp, I like the app. It worked when I logged into your app. However, when I made a copy of it, the reset button no longer works. I there something else I’m supposed to do? I noticed there’s an “Agreed” checkbox on the login page. Should I check that?

Hola @Herbert_Coleman I think the problem is the script. When you copied my template you could see my script and its trigger?

No, I didn’t see the script or the triggers. where can i find them?

I think when a sheet is duplicated, only the content is transferred over, not the scripts and triggers. I have to reconfigure them a bunch of times for my clients.

Hi again, Here is the script you must have in your GS. Then you have to set it up a trigger based On Change event: [image] New Row in Spreadsheet for Every User Here my code @Wiz.Wazeer function ResetOnChange(e) { var spreadsheet = SpreadsheetApp.getActive(); var Row…

Clear Cells

Ask for Help

gvalero April 15, 2020, 12:37pm 4

@SPETZ

Take a look at this post and follow some steps we shared there:

I hope it helps.

Saludos
Gavp

Topic		Replies	Views
Button in Google Sheet to 'Clear/reset' Ask for Help	14	9482	March 2, 2022
New Row in Spreadsheet for Every User Ask for Help	52	3641	September 26, 2020
Reset values daily Ask for Help	21	6234	August 11, 2020
OnChange trigger Ask for Help	29	7376	January 3, 2022
Set Column values Ask for Help	23	2639	August 27, 2021

Clear Cells

Related topics