# How to clear whole column?

**URL:** <https://community.glideapps.com/t/how-to-clear-whole-column/20115>\
**Category:** Ask for Help\
**Tags:** actions\
**Created:** [December 20, 2020, 10:10pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115 "2020-12-20T22:10:42Z")\
**Posts on this page:** 20\
**Page:** 3

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [December 21, 2020, 6:07pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/41 "2020-12-21T18:07:23Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2020, 6:09pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/42 "2020-12-21T18:09:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [December 21, 2020, 6:10pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/43 "2020-12-21T18:10:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2020, 6:12pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/44 "2020-12-21T18:12:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [December 21, 2020, 6:12pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/45 "2020-12-21T18:12:58Z")

</div>

yes

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2020, 6:13pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/46 "2020-12-21T18:13:22Z")

</div>

wow, you have a link to that app?

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [December 21, 2020, 6:15pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/47 "2020-12-21T18:15:29Z")

</div>

I messaged you the specs sir

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 20, 2021, 3:49pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/48 "2021-01-20T15:49:25Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [January 20, 2021, 10:27pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/49 "2021-01-20T22:27:07Z")

</div>

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.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a8120778c6776c205cabc1047b59a055d8eed8a3.png)

---

<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 21, 2021, 1:52am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/50 "2021-01-21T01:52:50Z")

</div>

> [@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](https://community.glideapps.com/t/delete-row-for-create-new-action-workflows/21390/5) in that other thread could be quite easily adapted for clearing one (or more) columns.

---

<div class="post-metadata">

**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\
**Post date:** [February 20, 2022, 12:14pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/51 "2022-02-20T12:14:09Z")

</div>

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.

---

<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:** [February 20, 2022, 12:40pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/52 "2022-02-20T12:40:13Z")

</div>

> [@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](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> 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…

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 20, 2022, 7:08pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/53 "2022-02-20T19:08:42Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\
**Post date:** [February 20, 2022, 8:30pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/54 "2022-02-20T20:30:40Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 21, 2022, 1:20am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/55 "2022-02-21T01:20:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 21, 2022, 2:45am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/56 "2022-02-21T02:45:35Z")

</div>

Good call…probably not.

---

<div class="post-metadata">

**Author:** ![Vitor\_Guimaraes](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vitor_guimaraes/32/39703_2.png) [@Vitor\_Guimaraes](https://community.glideapps.com/u/Vitor_Guimaraes)\
**Post date:** [March 21, 2023, 2:48am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/57 "2023-03-21T02:48:06Z")

</div>

What’s the current status on this issue?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 22, 2023, 12:04am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/58 "2023-03-22T00:04:03Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 22, 2023, 4:22am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/59 "2023-03-22T04:22:59Z")

</div>

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.

> [@arrows\_counterclockwise Bulk clear, edit, restore and delete columns plus Undo action](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns/59546):
>
> A little fun with Glide columns, using Java wink 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)

---

<div class="post-metadata">

**Author:** ![Cole\_Weir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cole_weir/32/65944_2.png) [@Cole\_Weir](https://community.glideapps.com/u/Cole_Weir)\
**Post date:** [November 2, 2023, 3:00am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/60 "2023-11-02T03:00:56Z")

</div>

@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.

[Previous page](https://community.glideapps.com/t/how-to-clear-whole-column/20115.md?page=2)

[Next page](https://community.glideapps.com/t/how-to-clear-whole-column/20115.md?page=4)