The video explains it all…

Take a look at this thread. Hopefully it’s self explanatory. [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…

Hey, Jeff would you be able to help me out, man. I just cannot seem to figure this out. :confused:

Where are you getting stuck? You may have to change some things around. I’m not sure my method will work well with a checklist because checking a box won’t call an action. What I’m imagining that the user’s could click on an item and set a unique id that maybe exists in their user profile row. The logic would check if the unique ID set on the item matches the unique ID in their user profile. Once their order is complete, then you would update the unique ID in the user profile sheet so it no longer matches the unique ID on the individual items.

no is not! is not giving solution, is asking for help to solve that problem

@Uzo Ok, but in the other thread you mentioned you were looking for methods to reset a value in multiple rows without any scripting. The linked solution I provided above is the only I know of to do what you want. The trick is not to change a value in multiple child rows. It’s to change a value in a single parent row.

this method i figured out long time ago… I’m looking for trick to actually write value to selected rows, so other users can see that change, if only Glide would have action like that… wow! right now, i’m joining row numbers for selected rows, and than using script, split it and writing values to that rows… but this have a delay and users can still access these rows and create problems… lol

Got it. There is currently no way to modify multiple rows at once through a multiple relation. The only option I can think of is to write a joined list of all the child items to the parent row or some other sheet, then change the unique ID to break the relation and make it ready for the next order.

yep, thats what i’m workin on now, but this is a messy workaround

i thing i found solution for this… you need to use users sheet, and every time, user check out the cart, join new items to user profile column and then use IF to check if items in cart are included in user profile joined column… i think this will work!

Hey, man thank-you for the help. So far I have tried all of the two following suggestions and it just isn’t hitting the mark. I am still working out my schema. I tell you what if I could trigger an action from another that would solve it. As I have one that does the trick as long as you’re on the page as Jeff mentioned. Your method was just the same as far as a similar solution goes.

Reset the values...?

Ask for Help

Jeff_Hager February 21, 2021, 4:56pm 2

Take a look at this thread. Hopefully it’s self explanatory.

Topic		Replies	Views
Clear value Ask for Help	6	848	January 21, 2022
How to bulk reset checkboxes across multiple rows in Glide? Ask for Help	7	174	October 13, 2025
Reset Multiple Rows At Once Project Showcase	47	7882	November 22, 2023
Target Multiple Rows Ask for Help	3	413	June 26, 2023
Clear Multiple Rows / Columns Ask for Help	3	86	August 30, 2024

Reset the values...?

Related topics