Reset column per user per day

Ask for Help
1

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

App

2

@Mariano_Betta

But does it erase user-specific column data?

3

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.

1 Like
4

@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!

5

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.

1 Like