How to clear whole column?

[Drearystate]

Why are you not doing that for non sign in users? Make that screen visible to all. I’m confused, what I just used doesn’t matter if it’s signed in or not. Doesn’t even use Glide.

[Uzo]

ohhh… i guess my english is still not good.
in the sample i post im trying to make it for non sign in.
try it whit-out sign in you will see

[Drearystate]

If you don’t mind can you allow me to edit your app

[Uzo]

video you post… can be play like this without sing in?

[Drearystate]

yes

[Uzo]

wow, you have a link to that app?

[Drearystate]

I messaged you the specs sir

[Eric_Penn]

Good afternoon @Drearystate. I was looking for a clear column script and came across your Chest Hunters post. However it appears there is no script in the GSheet attached. Is there a new version available for copy?

Thanks in advance.

[Drearystate]

I actually stopped working on that app but I can get you the script I used.

 function ClearContentScript(e) {
 var s = SpreadsheetApp.getActiveSheet();
if( s.getName() == "MAIN MENU" ) {        // sheet name
var r = s.getActiveCell(); 
if( r.getColumn() == 6 ) {                // column number
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('MAIN MENU'), true);
spreadsheet.getRange('B2:F17').clear();
         }
       }
     }

It’s a onChange event so when you make the trigger make sure you set it as a onChange event.

[Darren_Murphy]

@Eric_Penn

Good afternoon @Drearystate. I was looking for a clear column script and came across your Chest Hunters post. However it appears there is no script in the GSheet attached. Is there a new version available for copy?

The script I posted for deleting rows in that other thread could be quite easily adapted for clearing one (or more) columns.

[ToOFa_Apps]

Please let me know if there is a new feature in glide for this.
I’m not too keen on scripts.
Would be nice to click one button and clear a whole column.

[Darren_Murphy]

@ToOFa_Apps

Please let me know if there is a new feature in glide for this.

There isn’t.
Well, technically there is now - with Enterprise/Pro Apps you could use the Glide API to do a Set Column Values on several rows, and have that triggered by a single action.

If the API is too daunting for you (or your app is not pro), then the closest you can get is to “simulate” it.

Reset Multiple Rows At Once

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. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

[Robert_Petitto]

Jeff’s solution is best for now…REALLY need a set column > multiple relation > clear all. Been asking for this for almost two years now.

[ToOFa_Apps]

I managed to use the Multiple Row Reset Concept App for some ideas.
Definitely does the trick for now. Bit of a workaround but at least i don’t have to use scripting etc.

[ThinhDinh]

I haven’t checked, but I assume we can’t clear user-specific columns using Glide API?

[Robert_Petitto]

Good call…probably not.

[Vitor_Guimaraes]

What’s the current status on this issue?

[ThinhDinh]

I wouldn’t say this is an issue, it’s a thing that has never been supported.

[Uzo]

Wow… this post is over three years old, LOL… since then, we have had new tools… and it is not that hard anymore
The whole columns can be clear, edited, or replaced.

Bulk clear, edit, restore and delete columns plus Undo action

A little fun with Glide columns, using Java It works well and fast. You can edit or clear the whole column in one click… then undo, edit, or restore all to default. I used a regular inline list. You can still edit, add or delete individual rows as usual. It is a free app with no scripts and no Google Sheets… Pure Glide Page (App) [Screen Shot 2023-03-22 at 3.02.52 AM]

[Cole_Weir]

@ToOFa_Apps mind sharing with me how you did this? I just need a button to clear all of the data in column H on the google sheet that it is referencing.