# Setting Column Across Multiple Rows

**URL:** <https://community.glideapps.com/t/setting-column-across-multiple-rows/25085>\
**Category:** Ask for Help\
**Created:** [April 3, 2021, 12:26pm UTC](https://community.glideapps.com/t/setting-column-across-multiple-rows/25085 "2021-04-03T12:26:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [April 3, 2021, 12:26pm UTC](https://community.glideapps.com/t/setting-column-across-multiple-rows/25085/1 "2021-04-03T12:26:47Z")

</div>

Has anybody yet found a way (within Glide) to set a column value across multiple rows? For example to implement a “set all messages read” function or “archive all items” function. In both case we need to iterate through rows and set the same column in each to a specific value, perhaps a boolean or an integer.

---

<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:** [April 3, 2021, 12:33pm UTC](https://community.glideapps.com/t/setting-column-across-multiple-rows/25085/2 "2021-04-03T12:33:00Z")

</div>

You saw that thing that Jeff did, yeah?

> [@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:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [April 3, 2021, 12:44pm UTC](https://community.glideapps.com/t/setting-column-across-multiple-rows/25085/3 "2021-04-03T12:44:45Z")

</div>

Thanks @Darren_Murphy will take a look at that

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [April 3, 2021, 3:45pm UTC](https://community.glideapps.com/t/setting-column-across-multiple-rows/25085/4 "2021-04-03T15:45:56Z")

</div>

Ah yes. All good. So in my scenario I can just store when the user last tapped on “Mark all read” and compare it to the message timestamp. I also add in some logic with a user-specific “read” boolean for when they read a single message. So simple. Cheers @Darren_Murphy and @Jeff_Hager.