# Reset button **URL:** \ **Category:** Ask for Help\ **Created:** [March 27, 2023, 10:28pm UTC](https://community.glideapps.com/t/reset-button/59763 "2023-03-27T22:28:54Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Niko219](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/niko219/32/56302_2.png) [@Niko219](https://community.glideapps.com/u/Niko219)\ **Post date:** [March 27, 2023, 10:28pm UTC](https://community.glideapps.com/t/reset-button/59763/1 "2023-03-27T22:28:54Z")
Hello everyone, despite all the posts on the botom reset I can’t find the right solution and above all make it work, could you help me? I’m on a google sheets database and I would like to be able to reset 3 columns on different pages with a button. I did this which works fine but only on one table and only on row 1 ![Bouton](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3af255534ac72ae16f2d7e440ae8da98c713f8a0.png) ![menu](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/beaefdf22930eea19decb6a921519174ab06d99f.png) ![Reinit](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b689b13d7c49d65bbf568d303ad66c2f3dcb20fe.png) ![Set column values](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/3/63a3877d8e664f80b2a4b5c9bee92b82bd37a5b6.png) the result is that on line 1 it works but not on 2 ![Résultat](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/491aa3aac21e17d79aab5b293aa2cf7f1c066b53.png) thanks in advance ps: I am French and I use a translator… Be indulgent. THANKS ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [March 27, 2023, 10:56pm UTC](https://community.glideapps.com/t/reset-button/59763/2 "2023-03-27T22:56:54Z")
> [@Niko219](#): > > the result is that on line 1 it works but not on 2 This is because the default behavior for a top level screen is to connect you to the first row in that table. Try navigating to a details screen first by changing your action to show details screen → this item. Then on that details screen add your button to set column values. To update a separate sheet you’ll need a SINGLE relation from copie de gestion to your other sheet. Then add a second set column value to your sequence and choose the SINGLE relation we just created for the ‘ROW’. Now you should be able to set values in another sheet. Repeat the prior steps to update the third sheet. > **[Query Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/query-column)** > > Create complex relations in your data with conditional filtering, sorting, and limits. ---
**Author:** ![Niko219](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/niko219/32/56302_2.png) [@Niko219](https://community.glideapps.com/u/Niko219)\ **Post date:** [March 29, 2023, 10:30pm UTC](https://community.glideapps.com/t/reset-button/59763/3 "2023-03-29T22:30:50Z")
> [@Eric\_Penn](#): > > This is because the default behavior for a top level screen is to connect you to the first row in that table. Try navigating to a details screen first by changing your action to show details screen → this item. Then on that details screen add your button to set column values. > > To update a separate sheet you’ll need a SINGLE relation from copie de gestion to your other sheet. Then add a second set column value to your sequence and choose the SINGLE relation we just created for the ‘ROW’. > > Now you should be able to set values in another sheet. > > Repeat the prior steps to update the third sheet. Hello Eric\_Penn, and thank you for your answer. I saw a discussion that he used this function but I couldn’t really figure out how to set it up… it seems clearer to me now I’ll let you know. THANKS ---
**Author:** ![Niko219](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/niko219/32/56302_2.png) [@Niko219](https://community.glideapps.com/u/Niko219)\ **Post date:** [April 2, 2023, 6:01pm UTC](https://community.glideapps.com/t/reset-button/59763/4 "2023-04-02T18:01:10Z")
Good morning, I finally succeeded, but it remains complex… I had not yet understood how one could make a table out of google sheets. it was your example Eric\_Penn who put me on the voice, then I proceeded as follows: ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec1ce1e17a5789dbec75a4edb4c1efc6033acce1.png) ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/29bfd6448afd8f2386b3af9b3ba3d3448fef56b5.png) ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/77f1b7496d83901454ee90c6b6298df416db9e0c.png) ![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/4029bc1158daa51ea3008fdc004dcad2e6f9d973.png) ![5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/598483b5d55edcb63eb327dcf0cbe756f023a307.png) And it works very well. THANKS ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 2, 2023, 6:24pm UTC](https://community.glideapps.com/t/reset-button/59763/5 "2023-04-02T18:24:34Z")
🍻