Hi, In previous posts it’s clear that Glide is working on a feature to allow users to clear data and perform a reset. But no news on when this valuable feature will be available. In the meantime, can anyone share a workaround based on inserting a button directly in the Google Sheet? I have never w…

Thanks to everyone above for their input. However, I think I have found a good solution - at least better for me, since it requires no script editing! Insert a graphic for a button into the Google Sheet, e.g. [RESET] In the menu, select Tools, Macros, Record Macro… Perform the required set …

This is all doable with a script, and it could be triggered from Glide if you want to go that way. If you prefer to trigger from the Google Sheet, then I think I’d tend to favour a menu extension as opposed to a button. I have some scripts that clear entire sheets (minus the header row) that I cou…

Hi Darren, Thanks for the great response. Sounds promising. Can I just ask, would the menu extension work only on my version of Google or would anyone with the sheet have that access?

Anyone with Edit access can run scripts (or create new ones, or edit existing ones). Folks with View access cannot do any of the above.

Then that sounds perfect. I want to be able to share a copy of my Glide App and then handover ownership of the Google Sheet, preferably with a feature to reset/clear some rows. So if it worked through the menus, what would the user see? Could there be a new menu option added? If you can share an e…

@Simon_Hill I love your solution for this. I am VERY new to Glide and need a way for a button in Glide to uncheck all previous checkbox selections. Is there a way to activate a script from a button in Glide?

You could do that with an ‘onChange’ Trigger. Here’s an example where I use a named range in sheets… only when that named range is not blank will the script fire. I clear the content at end of script to ready it for new. function csv_sheet_change() { var ss = SpreadsheetApp.getActiveSpreadsheet()…

This is also something you could consider. [image] Reset Multiple Rows At Once Project Showcase There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that…

I now prefer this better way to clear columns: [image] Choice component MULTI-SELECT: now a dream, soon a reality? Feature Requests Sharing a basic example of how to clear columns with one button press. This uses relations, which is manageable so long as you h…

I also had almost the exact same thought. However my Apps Script abilities are very limited. Maybe you can help me since your script looks like what I want to do. Here’s the layout of my app. I work with and mentor college students, and it’s an app to help me understand where they’re at and help th…

@Simon_Hill this is a really creative and easy way to do it if I didn’t have so many selections. There will be 2 separate selection screens with up to 12 options on each. Still probably doable…but I feel like there has to be something a little more elegant haha.

Button in Google Sheet to 'Clear/reset'

Ask for Help

Simon_Hill March 1, 2022, 2:00pm 10

I now prefer this better way to clear columns:

Topic		Replies	Views
New Row in Spreadsheet for Every User Ask for Help	53	3518	January 27, 2024
Clear Cells Ask for Help	8	1204	September 26, 2020
Reset values daily Ask for Help	21	6221	August 11, 2020
How to clear whole column? Ask for Help actions	61	4813	November 3, 2023
How can I delete rows and perform a reset? Ask for Help	11	2556	January 17, 2024

Button in Google Sheet to 'Clear/reset'

Related topics