# Reset the values...? **URL:** \ **Category:** Ask for Help\ **Created:** [February 21, 2021, 4:19pm UTC](https://community.glideapps.com/t/reset-the-values/23181 "2021-02-21T16:19:05Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\ **Post date:** [February 21, 2021, 4:19pm UTC](https://community.glideapps.com/t/reset-the-values/23181/1 "2021-02-21T16:19:05Z")
The video explains it all… https://player.vimeo.com/video/514952655 ---
**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:** [February 21, 2021, 4:56pm UTC](https://community.glideapps.com/t/reset-the-values/23181/2 "2021-02-21T16:56:28Z")
Take a look at this thread. Hopefully it’s self explanatory. > [@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:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\ **Post date:** [February 21, 2021, 7:16pm UTC](https://community.glideapps.com/t/reset-the-values/23181/3 "2021-02-21T19:16:49Z")
Hey, Jeff would you be able to help me out, man. I just cannot seem to figure this out. 😕 ---
**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:** [February 21, 2021, 7:38pm UTC](https://community.glideapps.com/t/reset-the-values/23181/4 "2021-02-21T19:38:49Z")
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. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 22, 2021, 2:18am UTC](https://community.glideapps.com/t/reset-the-values/23181/5 "2021-02-22T02:18:17Z")
no is not! is not giving solution, is asking for help to solve that problem ---
**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:** [February 22, 2021, 2:28am UTC](https://community.glideapps.com/t/reset-the-values/23181/6 "2021-02-22T02:28:07Z")
@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. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 22, 2021, 2:32am UTC](https://community.glideapps.com/t/reset-the-values/23181/7 "2021-02-22T02:32:46Z")
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 ---
**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:** [February 22, 2021, 2:42am UTC](https://community.glideapps.com/t/reset-the-values/23181/8 "2021-02-22T02:42:18Z")
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. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 22, 2021, 2:45am UTC](https://community.glideapps.com/t/reset-the-values/23181/9 "2021-02-22T02:45:15Z")
yep, thats what i’m workin on now, but this is a messy workaround ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 22, 2021, 2:56am UTC](https://community.glideapps.com/t/reset-the-values/23181/10 "2021-02-22T02:56:36Z")
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! ---
**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\ **Post date:** [February 22, 2021, 3:03am UTC](https://community.glideapps.com/t/reset-the-values/23181/11 "2021-02-22T03:03:44Z")
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. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 22, 2021, 3:46am UTC](https://community.glideapps.com/t/reset-the-values/23181/12 "2021-02-22T03:46:15Z")
This technic is just to prevent users from editing the cart, until script will update Glide servers ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 22, 2021, 5:23am UTC](https://community.glideapps.com/t/reset-the-values/23181/13 "2021-02-22T05:23:54Z")
i did it! works without scripts… lol i’m so happy! you can try my App, you have to sign in to check out shopping cart… restaurants there are fake, so there is no consequences to proceed orders… for now it is just a demo app > **[E-Store](https://e-store.glideapp.io/)** > > Food delivery & pickup + Online bidding App i’m so happy… going to get drunk!!! i never thought it is possible 😄