# How to Reset Multiple Rows Without Using Updates or Triggers? **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [August 6, 2025, 3:21pm UTC](https://community.glideapps.com/t/how-to-reset-multiple-rows-without-using-updates-or-triggers/83688 "2025-08-06T15:21:50Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![P11](https://avatars.discourse-cdn.com/v4/letter/p/a9adbd/32.png) [@P11](https://community.glideapps.com/u/P11)\ **Post date:** [August 6, 2025, 3:21pm UTC](https://community.glideapps.com/t/how-to-reset-multiple-rows-without-using-updates-or-triggers/83688/1 "2025-08-06T15:21:50Z")
Hi everyone, I have a table where each row represents a customizable entry that users can personalize by selecting data from other tables. What I’m trying to do is allow users to _reset_ all these rows (clear their data) when they click a **“Cancel”** button — so that the next time they access the form, all fields are empty again and ready to be filled in. The key requirement is: 🔁 I want this reset to happen **without consuming updates** or using **on-submit triggers**. I’ve seen a few topics around this, but haven’t found a clean way to achieve it yet. Has anyone found a workaround or method for resetting multiple rows “virtually” or using computed columns? Any ideas or best practices are welcome! Thanks in advance 🙌 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 6, 2025, 4:20pm UTC](https://community.glideapps.com/t/how-to-reset-multiple-rows-without-using-updates-or-triggers/83688/2 "2025-08-06T16:20:34Z")
> [@Reset Multiple Rows - copyable template](https://community.glideapps.com/t/reset-multiple-rows-copyable-template/78907): > > Just adding this as a resource that can be linked to. The below template demonstrates the basic technique that was described by @Jeff_Hager in [this](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211) thread. The concept Apps in that thread are all legacy Apps which cannot be copied. > [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > 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… ---
**Author:** ![P11](https://avatars.discourse-cdn.com/v4/letter/p/a9adbd/32.png) [@P11](https://community.glideapps.com/u/P11)\ **Post date:** [August 6, 2025, 5:50pm UTC](https://community.glideapps.com/t/how-to-reset-multiple-rows-without-using-updates-or-triggers/83688/3 "2025-08-06T17:50:07Z")
Hi everyone, First of all — thanks to the community for the many ideas shared on this topic. I did try the [template solution] previously suggested for resetting user-specific values, but it didn’t quite match what I needed for my use case. So I’d like to share the solution I ended up using, in case it helps others in a similar situation. I have a table where each user edits multiple rows, with user-specific columns like `Ingredient` and `Percentage`. What I wanted: - When the user taps **“Cancel”** , or - When they simply **reopen the form later** , All the user-specific fields across those rows should appear **empty** again. - Instead of erasing user data, I just **hide it** unless it belongs to the current session. #### In the **Users table** - `Session ID` → text A new value is generated when the user enters the form (I use `Now()` formatted as text). #### In the **Rows table** (e.g., Ingredients): - `Row Session ID` → user-specific text Stores the session ID when the row is updated. - `Ingredient Visible` → If-Then-Else - `Percentage Visible` → same logic - Each row **checks if its `Row Session ID` matches** the current session: - When the user **saves or edits a row** , a custom action writes the current `Session ID` into that row’s `Row Session ID`. - The form always **starts clean** , regardless of what was typed before - No data is truly erased — it’s just ignored if outdated - **No updates** are consumed - 100% user-specific and session-isolated Thanks again to everyone sharing knowledge here! 🙌 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 7, 2025, 1:26am UTC](https://community.glideapps.com/t/how-to-reset-multiple-rows-without-using-updates-or-triggers/83688/4 "2025-08-07T01:26:12Z")
> [@P11](#): > > A new value is generated when the user enters the form (I use `Now()` formatted as text). There is also [this](https://www.glideapps.com/docs/reference/values/unique-identifier), which is what is used in the template. Your solution appears to be almost identical to the suggested approach, other than the above. ---
**Author:** ![P11](https://avatars.discourse-cdn.com/v4/letter/p/a9adbd/32.png) [@P11](https://community.glideapps.com/u/P11)\ **Post date:** [August 7, 2025, 6:50am UTC](https://community.glideapps.com/t/how-to-reset-multiple-rows-without-using-updates-or-triggers/83688/5 "2025-08-07T06:50:02Z")
Thanks for all the references, super helpful! Yes, at its core, the logic is the same as the Parent ID approach, comparing a stored value per row against a reference value. But honestly, I didn’t fully understand how to apply it until I tried using a Session ID based on Now() to trigger the reset automatically when entering the screen. That gave me exactly what I needed: no manual reset, user-specific control, and no updates consumed. Really appreciate all the ideas shared here! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [August 14, 2025, 6:50am UTC](https://community.glideapps.com/t/how-to-reset-multiple-rows-without-using-updates-or-triggers/83688/6 "2025-08-14T06:50:15Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.