Setting Column Across Multiple Rows

[V88]

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.

[Darren_Murphy]

You saw that thing that Jeff did, yeah?

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…

[V88]

Thanks @Darren_Murphy will take a look at that

[V88]

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.