# Reset column per user per day **URL:** \ **Category:** Ask for Help\ **Created:** [September 17, 2020, 1:11am UTC](https://community.glideapps.com/t/reset-column-per-user-per-day/15927 "2020-09-17T01:11:23Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [September 17, 2020, 1:11am UTC](https://community.glideapps.com/t/reset-column-per-user-per-day/15927/1 "2020-09-17T01:11:23Z")
I believe I have found a way to restore the value of a column every new day with login. If they can try it and it works let me know. At least until Glide has a function to erase everything. In the sheet I have a script that updates the date daily Video [https://drive.google.com/file/d/1GRi1XPcYbyKSSXCtQNZ9pROaIQyaHMDc/view](https://drive.google.com/file/d/1GRi1XPcYbyKSSXCtQNZ9pROaIQyaHMDc/view) App > **[RESTABLECER VALOR X USUARIO](https://boring-wrench-5268.glideapp.io/)** ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [September 17, 2020, 2:46am UTC](https://community.glideapps.com/t/reset-column-per-user-per-day/15927/2 "2020-09-17T02:46:27Z")
@Mariano_Betta But does it erase user-specific column data? ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [September 17, 2020, 11:03am UTC](https://community.glideapps.com/t/reset-column-per-user-per-day/15927/3 "2020-09-17T11:03:05Z")
The products ordered are taken into account only if they were made that day. The next day, the value is still there but it is not taken into account because it is not the same day, and if any product is reordered, it starts from 0 just like any other product. That’s why I put reset value per day. I had a problem with the script yesterday, now it should work. ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [September 17, 2020, 12:49pm UTC](https://community.glideapps.com/t/reset-column-per-user-per-day/15927/4 "2020-09-17T12:49:11Z")
@Mariano_Betta Have you tried your script with a User Specific column? Does it work? How do you pass the User Specific Column to the Google sheets? Thanks! ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [September 17, 2020, 1:09pm UTC](https://community.glideapps.com/t/reset-column-per-user-per-day/15927/5 "2020-09-17T13:09:11Z")
Not @SantiagoPerez The script just dates me daily. Then I do a series of calculations. I don’t pass user specific column to google sheet. These days I am going to explain it, I am seeing that it works well and being able to explain it well. As long as it helps some people, if not I hope for some glide update. ---
**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:** [November 19, 2024, 6:13am UTC](https://community.glideapps.com/t/reset-column-per-user-per-day/15927/6 "2024-11-19T06:13:13Z")