# 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:** 1

<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 20, 2020, 10:10pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/1 "2020-12-20T22:10:42Z")

</div>

is there a way to clear whole column? in action tab?

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [December 20, 2020, 10:21pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/2 "2020-12-20T22:21:46Z")

</div>

Hey @Uzo

Check this thread:  
[🚀 Set Column Action: Alter a DIFFERENT SHEET'S VALUES!](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342)

---

<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 20, 2020, 10:24pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/3 "2020-12-20T22:24:17Z")

</div>

i’m looking to clear whole column, not row

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [December 20, 2020, 10:26pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/4 "2020-12-20T22:26:06Z")

</div>

I understand but at the moment there’s no native way how to clear a whole column. You have to have a workaround.

In one of those threads 🧵 @Robert_Petitto explains how to do it and helped me how to achieve it in this app.

[https://yielding-crayon-5516.glideapp.io/](https://yielding-crayon-5516.glideapp.io/)

I hope that helps.

---

<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 20, 2020, 10:50pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/5 "2020-12-20T22:50:12Z")

</div>

You can run a script that triggers a column reset. There’s a post I made called scripts scripts scripts. In there it tells you how to do this.

---

<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 20, 2020, 11:03pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/6 "2020-12-20T23:03:15Z")

</div>

i know, but for some reason is not affecting cells with links to images, when im clearing images links in my sheets, you still can see them in app even after refreshing or reloading.  
but when i clear it with action button, it disappear right-away, but i can only clear one with this technic

---

<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:** [December 20, 2020, 11:12pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/7 "2020-12-20T23:12:29Z")

</div>

What’s your scenario for wanting to clear a whole column of images?

---

<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 20, 2020, 11:14pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/8 "2020-12-20T23:14:46Z")

</div>

to set new ones and have empty icons showing that you can put new

---

<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, 12:07am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/9 "2020-12-21T00:07:35Z")

</div>

there is one more problem, in action i cant clear item if is not on the first row in the relation, only clear when is in the first row.  
i did reference and lookup for each row. and i created actions for each reference to each row, and only the first row work

---

<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:** [December 21, 2020, 1:20am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/10 "2020-12-21T01:20:53Z")

</div>

Next question…when in your app would a user add images then clear them at all at once? What’s the scenario?

---

<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:** [December 21, 2020, 1:21am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/11 "2020-12-21T01:21:38Z")

</div>

What I mean to say is, for what purpose is a user adding images and then wanting to clear them at once?

---

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

</div>

i’m creating a game, almost finish 😉  
go to tick tac tab

> **[E-store](https://e-strore.glideapp.io/)**
>
> Online bidding App

---

<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:** [December 21, 2020, 4:33am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/13 "2020-12-21T04:33:21Z")

</div>

Ah…you and I are on the same page:

> **[TicTacToe](https://tictactoe.glideapp.io/)**

---

<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, 5:02am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/14 "2020-12-21T05:02:10Z")

</div>

hahahah, yes but mine you don’t have to sign in lol

---

<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, 5:28am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/15 "2020-12-21T05:28:02Z")

</div>

now i’m gonna work on how to score the game whit-out sign in… lol  
but i will do that tomorrow, i’m tired

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 21, 2020, 6:03am UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/16 "2020-12-21T06:03:12Z")

</div>

Genius

---

<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:** [December 21, 2020, 12:43pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/17 "2020-12-21T12:43:41Z")

</div>

Nice! Are you able to play on more than one device?

---

<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, 1:04pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/18 "2020-12-21T13:04:27Z")

</div>

yes, on my phone Samsung galaxy and laptop Mac Pro, works good

---

<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:** [December 21, 2020, 2:34pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/19 "2020-12-21T14:34:23Z")

</div>

I’ve been using this when I don’t have any Row ID column in my table. So I used Set Column action to clear value from every column I had in my table. It worked 😁

* * *

💡 **Workaround** : One table I had a Row ID column that I created for my user-specific columns. I deleted it when I had no user-specific column to create anymore and created a Unique Key column… and guess what? Yes, also worked! 🤪

---

<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:** [December 21, 2020, 3:19pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/20 "2020-12-21T15:19:31Z")

</div>

Great one Lucas, forgot we can use the unique ID from an add row to serve as the “rowID” as well.

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