# How to clear whole column? **URL:** \ **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:** 2
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [December 21, 2020, 3:22pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/21 "2020-12-21T15:22:54Z")
@Lucas_Pires great that it worked. Until we try these things out of necessity we don’t really know, so we’ll done you ---
**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, 3:24pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/22 "2020-12-21T15:24:58Z")
@Rosewebstudio @ThinhDinh Thanks Jason and Thịnh! Exactly that! We’d never discover it till we really need it ---
**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, 3:28pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/23 "2020-12-21T15:28:54Z")
I submitted last week 2 templates which they already have this feature 🕶 waiting for Glide to approve’em ---
**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, 3:48pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/24 "2020-12-21T15:48:53Z")
there is view problems with set columns action: 1. you need to clear each row in each column separately. this takes huge amount of time to code, and a very long time for glide to execute it. 2. if you made a mistake setting columns you have to erase the starting element and do everything from the scratch because glide for some reasons remembers erased settings and run them together with edited ones. 3. erasing values manually or by script directly in google sheets it won’t affect glide app right-away and if you trying to clear links to pictures it will not affect App at all until you reload that App. 4. you have to create relation columns for each row in that column… thats sucks! so it would be great to have an option to clear a whole column or even better one, to clear specific range. ---
**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, 3:53pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/25 "2020-12-21T15:53:37Z")
Got you @Uzo . And agreed. The best solution so far is to get it with scripts ---
**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, 3:57pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/26 "2020-12-21T15:57:09Z")
i know, but i was creating tic tac game, and erasing links to glide images with a script was not effecting App screen, only when i did that with action it works, but takes very long time to see result in google sheet from that action. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [December 21, 2020, 5:27pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/27 "2020-12-21T17:27:56Z")
Hola @Lucas_Pires May you explain me better your solution because of I can’t understand it yet? I have months “literally” look for a real way or trick with no success. What I know so far is: 1- If you are using user specific columns, no script will be useful because that data doesn’t live in GS 2- If you use a Set Column action (to Clear Value or Write), this action will be done to one row only. Although you can use a relation into Set Column action (Row field) the relation must be simple therefore, the problem still happens. Instead, if Glide lets to use **multiple relations** the solution is almost done and we will be happier in 2021 but it’s not the case so far 🙃 3- I discovered a risky trick to erase all value associated to USC time ago: if you modify some values belonging to RowID (2-3 characters), the row’s data is deleted and it’s perfect but the same data is deleted to **all users** connected to APP at the same time and it’s a little chaos! Let me compare your idea with mine in order to get a happy 2021 🥳 Thanks bro. Saludos! ---
**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:32pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/28 "2020-12-21T17:32:13Z")
i know all that, my quest is to clear whole column in one shot, not row by row… it takes forever and is giving confusing results on user screen until is finished ---
**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, 5:48pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/29 "2020-12-21T17:48:57Z")
Here’s a game that does what you want, I don’t have time to finish it up but the script is written to clear the column after game is over. You can have and use as you see fit. > **[CHEST HUNTERS](https://joyful-stitch-4157.glideapp.io/)** > > 1V1 TAKE TURNS HUNTING EACH OTHER'S CHESTS look at the script written, it should be exactly what you need. The game works I just have to build for unique sign on for 2 players on 2 different devices. If anyone wants to finish and use have at it. It only needs a couple of hours of love to finish up. ---
**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, 5:52pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/30 "2020-12-21T17:52:22Z")
1. Yes 2. Agree, we’d be happier with this solution. But not the case yet. 3. What I did to delete Row ID column, I didn’t feel any change in my app. Actually I deleted it and create a Unique Key column because I still needed a UK column. ---
**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, 5:53pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/31 "2020-12-21T17:53:04Z")
Uzo is your app going to be a pro app? ---
**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, 5:54pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/32 "2020-12-21T17:54:38Z")
Yeah, feel you Uzo! As @gvalero said, we’d be happier in 2021 lol > [@gvalero](#): > > if Glide lets to use **multiple relations** the solution is almost done and we will be happier in 2021 but it’s not the case so far 🙃 ---
**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:55pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/33 "2020-12-21T17:55:47Z")
but you have to sign in to play, my game you dont need to! try it… go to “tic tac” tab without sign in > **[E-store](https://e-strore.glideapp.io/)** > > Online bidding App ---
**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, 5:56pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/34 "2020-12-21T17:56:31Z")
The sign in is for user specific. the script that clears the column doesnt care if you sign in, it has a trigger that identifies a win. ---
**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, 5:57pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/35 "2020-12-21T17:57:05Z")
Will it be a pro app? This will make it very simple if it is. ---
**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:57pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/36 "2020-12-21T17:57:07Z")
for sign in users i dont have any problem do any hocus pocus ! lol ---
**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:03pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/37 "2020-12-21T18:03:50Z")
Are you trying to do something like this? [![]( " - YouTube") ](https://www.youtube.com/watch?v=i8X6u4_bYws) ---
**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:05pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/38 "2020-12-21T18:05:17Z")
yes, but for not sign in users ---
**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:05pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/39 "2020-12-21T18:05:43Z")
If you have a pro app this takes 5 seconds to setup ---
**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:06pm UTC](https://community.glideapps.com/t/how-to-clear-whole-column/20115/40 "2020-12-21T18:06:42Z")
yes i have pro, remember, i know how to do that for sign in users! [Previous page](https://community.glideapps.com/t/how-to-clear-whole-column/20115.md?page=1) [Next page](https://community.glideapps.com/t/how-to-clear-whole-column/20115.md?page=3)