# How to "clear an entire column" (compound action trickery)
**URL:** https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555
**Category:** Ask for Help
**Tags:** actions
**Created:** [November 17, 2020, 1:59pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555 "2020-11-17T13:59:33Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 17, 2020, 1:59pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/1 "2020-11-17T13:59:33Z")
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 17, 2020, 2:04pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/2 "2020-11-17T14:04:17Z")
Excellent as always!
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [November 17, 2020, 2:18pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/3 "2020-11-17T14:18:54Z")
Thanks man! I’ll try it and see if it works for my case.
@gvalero. Échale un vistazo a esto.
---
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [November 17, 2020, 2:35pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/4 "2020-11-17T14:35:07Z")
Awesome as always!
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [November 17, 2020, 3:00pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/5 "2020-11-17T15:00:20Z")
This is awesome but it doesn’t work for my case. 😔
I wish they let us clear the whole column.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 17, 2020, 3:01pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/6 "2020-11-17T15:01:19Z")
What are you looking to clear?
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [November 17, 2020, 3:03pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/7 "2020-11-17T15:03:47Z")
I’m looking to clear the “quantityslected colum” that you show but in my case the user increment to add to the cart, the by using a joined list I populate the order tab.
I replicated your trick but still unable to clear the whole column.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 17, 2020, 3:08pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/8 "2020-11-17T15:08:30Z")
So they have +1 / -1 buttons that add to cart? That’s the same premise as me…just a different component to add the value. Want to share your app and I’ll take a look?
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [November 17, 2020, 3:13pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/9 "2020-11-17T15:13:36Z")
Sure!
> **[e-Commerce](https://same-wing-2812.glideapp.io/)**
Thanks man!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 17, 2020, 4:37pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/10 "2020-11-17T16:37:20Z")
Done 😉
> **[e-Commerce · Glide · Create Apps from Google Sheets](https://www.loom.com/share/23cbb3f9893d47a786563822d2a80846)**
>
> Check out a video I made via Loom
> **[e-Commerce](https://opposite-frame-6635.glideapp.io/)**
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [November 17, 2020, 4:55pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/11 "2020-11-17T16:55:16Z")
You are awesome man!
Thanks!
---
### Author:  [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [November 17, 2020, 5:03pm UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/12 "2020-11-17T17:03:34Z")
Nicely thought through and executed (as always) 👍
---
### Author:  [@Pavel\_Sudoplatov](https://community.glideapps.com/u/Pavel_Sudoplatov)
#### Post date: [March 21, 2021, 12:26am UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/13 "2021-03-21T00:26:39Z")
Hello, Robert! Thanks for the idea with the timestamps, I’ve watched your video and your review for Santiago’s app.
I’m trying to recreate timestamp check via Single Value column, but still can’t add timestamp into the first row (if I’m dealing with the item placed in the second row or any row after) - via “Set Column - This Row” I got timestamps only in those specified rows, **not in the first one**.
I duplicated all actions from the app you’re improved for Santiago, but unsuccessful. I’m going crazy about this,
please, be kind to give advice.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 21, 2021, 12:38am UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/14 "2021-03-21T00:38:48Z")
Don’t use a single column then! If it’s in the second (or whichever) row, use a joinText column instead. Just remove the comma separator that Glide puts in automatically.
---
### Author:  [@Pavel\_Sudoplatov](https://community.glideapps.com/u/Pavel_Sudoplatov)
#### Post date: [March 21, 2021, 1:26am UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/15 "2021-03-21T01:26:20Z")
@Robert_Petitto, thanks for your answer.
You meant a “Joined List” Column?
If I use this type, how could I use an IF-ELSE column with timestamps comparison?
Also, in a “Joined List” I have all the timestamps which I’ve got after orders submission -but one-by-one, without any breaks.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 21, 2021, 1:30am UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/16 "2021-03-21T01:30:27Z")
Hm. My method might not work for your intention…not sure exactly what you’re looking to do in your data table, but if you’re looking for the last order, a rollup column of the date would give you that option.
---
### Author:  [@Pavel\_Sudoplatov](https://community.glideapps.com/u/Pavel_Sudoplatov)
#### Post date: [March 21, 2021, 1:40am UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/17 "2021-03-21T01:40:53Z")
“Great Scott!” 😅 - Rollup with the “Latest”! Yeah, it works! Thank you, you’re awesome! My best regards to you.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [December 8, 2023, 3:22am UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/18 "2023-12-08T03:22:04Z")
My work of case something like checklist. The column will fill up by choice component and need to be cleared after the checklist submitted. i am using the Miracle Method by @Robert_Petitto.
It is possible ?
Btw, i am using Glide table. No 3rd party like Google Sheets. So no Appscript can be used.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 8, 2023, 3:56am UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/19 "2023-12-08T03:56:30Z")
Convert your table to JSON
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [December 8, 2023, 7:14am UTC](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/20 "2023-12-08T07:14:58Z")
😩 😩
[Next page](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555.md?page=2)