# Clear all values in a user specific column

**URL:** <https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733>\
**Category:** Ask for Help\
**Created:** [May 13, 2023, 6:20pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733 "2023-05-13T18:20:24Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shaman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shaman/32/58987_2.png) [@Shaman](https://community.glideapps.com/u/Shaman)\
**Post date:** [May 13, 2023, 6:20pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/1 "2023-05-13T18:20:24Z")

</div>

Hi,

I am trying to figure out how to clear values from all rows in a User-Specific column. Is this possible? I can do it using integromat ([Make.com](http://Make.com)) but only if the column is in my excel file (using as database). But as the User-Specific Columns are held in Glide itself I cannot manage it. Doesn’t seem like the API will help either.

Any help much appreciated.

thanks,

Shaman

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [May 13, 2023, 6:21pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/2 "2023-05-13T18:21:56Z")

</div>

How does a user populate the USC? If set via Action, you can add a “set column” action and use “Clear” to clear the USC.

---

<div class="post-metadata">

**Author:** ![Shaman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shaman/32/58987_2.png) [@Shaman](https://community.glideapps.com/u/Shaman)\
**Post date:** [May 13, 2023, 6:28pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/3 "2023-05-13T18:28:08Z")

</div>

> [@Joe\_Gabriele](#):
>
> Clear

A user would click a button to clear, so yes via an action. But the set column action only allows for one row to be cleared, I need to clear all rows in a column at once.

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [May 13, 2023, 6:32pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/4 "2023-05-13T18:32:27Z")

</div>

I guess my assumption was that you wouldn’t need to clear the entire column at once if the USC is individually populated and thus individually cleared once the user clicks the button.

Someone else will need to comment as I am not aware of how to clear an entire column in a table.

---

<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:** [May 13, 2023, 6:39pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/5 "2023-05-13T18:39:41Z")

</div>

> [@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:** ![Shaman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shaman/32/58987_2.png) [@Shaman](https://community.glideapps.com/u/Shaman)\
**Post date:** [May 13, 2023, 6:43pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/6 "2023-05-13T18:43:42Z")

</div>

Ok thanks but I have looked at that. I don’t see how it works to clear a user-specific TEXT column. Doesn’t seem like I can relate back to this TEXT column to clear it. Am I missing something?

---

<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:** [May 14, 2023, 2:04am UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/7 "2023-05-14T02:04:10Z")

</div>

> [@Shaman](#):
>
> I don’t see how it works to clear a user-specific TEXT column.

It doesn’t. Instead it uses a clever trick to make it appear like a whole column has been cleared. The same approach works for any type of column.

---

<div class="post-metadata">

**Author:** ![Shaman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shaman/32/58987_2.png) [@Shaman](https://community.glideapps.com/u/Shaman)\
**Post date:** [May 15, 2023, 11:18am UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/8 "2023-05-15T11:18:07Z")

</div>

Ok I see thanks for this.

---

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [January 20, 2025, 5:37pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/9 "2025-01-20T17:37:13Z")

</div>

I recall seeing a “Clear Value” option when setting column column values a couple of weeks ago. I no longer see this option in the drop down. Has this capability been deprecated?

thanks

---

<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:** [January 20, 2025, 11:49pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/10 "2025-01-20T23:49:42Z")

</div>

![CleanShot 2025-01-21 at 06.49.10](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/2263dacae61892dde3d851e7fd5813db34bbfa61.png)

Assuming you’re indeed using a set column values action, it should be here.

---

<div class="post-metadata">

**Author:** ![Bernd\_Grimm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bernd_grimm/32/81073_2.png) [@Bernd\_Grimm](https://community.glideapps.com/u/Bernd_Grimm)\
**Post date:** [March 24, 2025, 4:28pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/11 "2025-03-24T16:28:17Z")

</div>

Hi @ThinhDinh

I use the trebuchet method and need a USC.  
If I remove the array that I put in the trebuchet table, I don’t need those values in the USC anymore either.  
Do you have any idea how I could approach this?  
Many thanks in advance!

 ![Bildschirmfoto 2025-03-24 um 17.24.42](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1ac4606ddb40cfcfba61d440635ec7b1a6188019.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:** [March 24, 2025, 10:43pm UTC](https://community.glideapps.com/t/clear-all-values-in-a-user-specific-column/61733/12 "2025-03-24T22:43:58Z")

</div>

It’s not possible to automatically clear an entire column of User Specific values.  
Your only option is the workaround described below:

> [@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…
