I’m building an app where users check multiple checkboxes across different rows in a table to indicate selections. After completing an action (clicked the send button), I want to reset all those checkboxes back to unchecked (false) across all rows at once (the quantity if column).
I’m looking for a way to bulk update these boolean values in Glide natively or via an integration.
Is there a recommended approach or best practice to do this? Can it be done in Glide alone, or do I need an external tool or Glide API? I do all my automations in Zapier, so if this functionality is not native in Glide, how can it be done through Zapier?
If they are User Specific Columns (and it looks like they are), then there is no easy way to do that.
The best alternative is to use a bit of smoke and mirrors as described below:
The issue I’m having is that I don’t just have a checkbox — I also have a quantity field.
When an order is submitted, I need all the quantity values to reset back to 0 (or be cleared out).
With the proposed setup, the quantity values stay the same after submission, so when the parent column gets checked again, all those rows with existing quantities are triggered once more. That causes the same order to reappear instead of starting a new one from zero.
Any workflow other than an App Interaction workflow runs server side and does not run as a specific user, so there is no way to know which user values to clear in a user specific column.
I did a similar cart setup as a concept a few years ago, but it was a classic app, so I don’t currently have a working copy. The concept for determining quantity is similar to determining if something is selected or not with a few differences. Recalling from memory…I used unique identifiers that indicated when something was added to a cart. Adding something to a cart meant setting an ID on the item that matched a parent ID. Clearing the cart meant changing the parent ID so it no longer matched the ID set on the items. Quick and easy with no looping involved. I also allowed the user to set a quantity on items once added to the cart. Both the ID and Quantity were user specific columns stored in the item table. If a user added an item back to the cart (via a button), that is when I reset the quantity back to 1.
More or less, if the ID set on an item matches the parent ID, then that’s when I care about the value stored in the quantity column. If the IDs don’t match, then I ignore what’s in that quantity column. The process of adding or removing a specific item from the cart, or incrementing the quantity at the only times I touched quantity. Otherwise I didn’t care if there was a number in there when the IDs didn’t match.
Basically, don’t use a checkbox to select items. Instead use a workflow that sets or unsets an ID, and whenever setting the ID to match the parent, that’s when you reset the quantity. In reality, you shouldn’t be using boolean columns for a setup like this.
And by Parent ID, I mean a unique ID that I usually set in the user profile row or some other table that that I can easily get to with a Single Value column or a Relation/Query and Lookup combo. You are going to need to bring that that parent ID into your Materials table to do the compares, especially for the workflow that resets the quantity.
