# Change column values at once

**URL:** <https://community.glideapps.com/t/change-column-values-at-once/75827>\
**Category:** Ask for Help\
**Created:** [August 24, 2024, 2:49am UTC](https://community.glideapps.com/t/change-column-values-at-once/75827 "2024-08-24T02:49:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Univ.of.Fukuyama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/univ.of.fukuyama/32/78934_2.png) [@Univ.of.Fukuyama](https://community.glideapps.com/u/Univ.of.Fukuyama)\
**Post date:** [August 24, 2024, 2:49am UTC](https://community.glideapps.com/t/change-column-values-at-once/75827/1 "2024-08-24T02:49:54Z")

</div>

Dear all, I have a question.  
I am currently building a site with Glide Page, and as part of the functionality, I need to “change all the values in a column to the same value when a button is pressed”.  
I can change one row with “Set Column Values” but what I want is something that can be done on all rows. Any good ideas on how to accomplish this?

---

<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:** [August 24, 2024, 11:27am UTC](https://community.glideapps.com/t/change-column-values-at-once/75827/2 "2024-08-24T11:27:23Z")

</div>

If you have a plan that supports it, you can use the API. Otherwise, you can use the trick showcased 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…

---

<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:** [August 24, 2024, 11:50am UTC](https://community.glideapps.com/t/change-column-values-at-once/75827/3 "2024-08-24T11:50:25Z")

</div>

Happy Cake Day, Darren!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 19, 2024, 6:50am UTC](https://community.glideapps.com/t/change-column-values-at-once/75827/4 "2024-09-19T06:50:38Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.