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.

You saw that thing that Jeff did, yeah? [image] Reset Multiple Rows At Once Project Showcase 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…

Thanks @Darren_Murphy will take a look at that

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.

Setting Column Across Multiple Rows

Ask for Help

Darren_Murphy April 3, 2021, 12:33pm 2

You saw that thing that Jeff did, yeah?

Topic		Replies	Views
Change column values at once Ask for Help	2	140	August 24, 2024
Clear value Ask for Help	6	848	January 21, 2022
Use "set column" to clear all values in a column? Ask for Help	1	1732	March 3, 2021
Set a numeric value across multiple rows Ask for Help	6	115	April 12, 2025
Using Integrations for actions Ask for Help	14	270	March 18, 2024

Setting Column Across Multiple Rows

Related topics