There have been several requests for people to find a way to clear a value in multiple rows and several solutions proposed:
Sept 2020 | @Robert_Petitto | The timestamp method with Flashcards β Flashcard: Create and Study Custom Flashcards
Feb 2021 | @Jeff_Hager | The matching values method Reset Multiple Rows At Once
Here is a new method using the AI component in a checklist component collection.
On the left the Glide component and on the right the AI component, both in collections
In this method, each AI component in the collection listens to a computed single value column for a matching word. If the word is reset then each AI component are asked to set the check to false and if the word is all to true.
The AI component is connected to 5 Columns:
- Name
- Price
- Photo
- Selected (User specific)
- Status (the single value column)
Here is the prompt for the AI component:
-
Create a checkbox component no label binded to Selected with Name, Price and Photo next to the checkbox. Set the component background color opacity to 0 and add a thick border with accent color to the Photo when Selected is true. Photo should always be visible.
-
When the value of Status changes and is equal to reset, the component should automatically respond to this change and update itself to set Selected value to false.
-
When the value of Status changes and is equal to all, the component should automatically respond to this change and update itself to set Selected value to true.