# Any way to iterate over all rows?

**URL:** <https://community.glideapps.com/t/any-way-to-iterate-over-all-rows/47729>\
**Category:** Ask for Help\
**Created:** [August 25, 2022, 2:02pm UTC](https://community.glideapps.com/t/any-way-to-iterate-over-all-rows/47729 "2022-08-25T14:02:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ron](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ron/32/46802_2.png) [@Ron](https://community.glideapps.com/u/Ron)\
**Post date:** [August 25, 2022, 2:02pm UTC](https://community.glideapps.com/t/any-way-to-iterate-over-all-rows/47729/1 "2022-08-25T14:02:54Z")

</div>

If I’m missing something obvious, I apologize, I’m new to Glide, and my app is working as I want, with one exception. I need an action that can do two things: reset a boolean column in all rows to false, and at the same time assign a random integer to another column. I can’t seem to find any way for an action to actually iterate over a table? Seems like basic functionality, 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:** [August 25, 2022, 2:10pm UTC](https://community.glideapps.com/t/any-way-to-iterate-over-all-rows/47729/2 "2022-08-25T14:10:14Z")

</div>

> [@Ron](#):
>
> I can’t seem to find any way for an action to actually iterate over a table?

No, that doesn’t exist.

> [@Ron](#):
>
> reset a boolean column in all rows to false,

Other than using something external, probably the closest you can get to this is as 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…

> [@Ron](#):
>
> and at the same time assign a random integer to another column.

There are a couple of plugins that might help with this. Have a look at the [Roll Dice](https://www.glideapps.com/plugins/dice) & [Random Number](https://www.glideapps.com/plugins/random) plugins.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [August 26, 2022, 1:08am UTC](https://community.glideapps.com/t/any-way-to-iterate-over-all-rows/47729/3 "2022-08-26T01:08:54Z")

</div>

Sigh…ya, wish we had set column / delete rows over multiple relation already…

---

<div class="post-metadata">

**Author:** ![Bill\_Donnelly](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bill_donnelly/32/55543_2.png) [@Bill\_Donnelly](https://community.glideapps.com/u/Bill_Donnelly)\
**Post date:** [March 27, 2023, 1:26pm UTC](https://community.glideapps.com/t/any-way-to-iterate-over-all-rows/47729/4 "2023-03-27T13:26:54Z")

</div>

Hi, new user and I just want to +1 the need to iterate over rows. Also wondering if anyone came across a practical work-around.

My current plan is write it in Python in a Zap and iterate over each row using the Tables API. But that seems very hacky.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 27, 2023, 1:30pm UTC](https://community.glideapps.com/t/any-way-to-iterate-over-all-rows/47729/5 "2023-03-27T13:30:35Z")

</div>

That’s one of the only ways to do it at the moment though. Set Column / Increment over a multiple relation has been a feature request for almost 3 years now and Glide hasn’t yet developed it.

> [@Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations](https://community.glideapps.com/t/ability-to-set-columns-increment-and-delete-rows-via-multiple-relations/19584):
>
> Currently, the Action to “Set columns” only consider the current sheet or any single relations (to update a column in a single row). I’m trying to create a “bulk approval” process where the “set column” action could look at a multiple relation and update each corresponding row in that relation.

@Mark any chance this is ever going to be a thing? @david mentioned this is the year for Glide to become more powerful. This request would certainly embody that goal.
