Any way to iterate over all rows?

[Ron]

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?

[Darren_Murphy]

@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

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 & Random Number plugins.

[Robert_Petitto]

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

[Bill_Donnelly]

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.

[Robert_Petitto]

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

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.