How to make the values of action row go back to 0 everyday

Ask for Help
1

Hi everyone,

So I’ve been making this app, and come to many features that is difficult for a beginner like me, hopefully it’s more possible to figure out for you guys, and if you could let me know how, I’ll be very thankful.

So my current problem is I have an action row with icon, and a input value, for example “smile ___times a day”, and the ___ is a input,

so everyday the user input the times they smile by clicking an add sign,

and the next day it’ll go back to zero again, and the user would input how many times they smile again.

I already made the input part, I just need to make it go back to zero again automatically the next day

like how do I make that happen?

thanks in advance :folded_hands:

1 Like
2

Use scheduled workflows! https://www.glideapps.com/docs/automation/workflows/schedule

2 Likes
3

Is it a user-specific column or a basic column? You can only use scheduled workflows on basic columns.

Do your users share the same rows for these actions?

1 Like
4

Like every user have their own achievement, they don’t share achievements

5

First as a date column to the table. Then change your add button to a workflow with a condition that checks is the date is within today. If it is, increment the number. Else, set the number to 1 and overwrite the date with the current date.

When displaying the number use an IF column that checks if the date is within today. If it is, then return the number, else return zero.

1 Like
6

I assume you might want the count to go more than 1. In that case:

  1. Ensure “count” is a Basic Column

Scheduled workflows in Glide only work with basic columns, not user-specific columns. Double-check that your “count” column in the Achievements table is a basic column.

  1. Create a Scheduled Workflow
  • Go to the Glide Data Editor.
  • Click on the “Workflows” tab.
  • Choose add and then “Schedule”.
  • Set the schedule to run daily at your preferred time (e.g., midnight).
  1. Add the Reset Action
  • In the workflow, first add a loop for the Achievements table.
  • Then, add an action to “Set Column Values" within that loop. Set the “count” column to 0 for all rows (or use a filter if you only want to reset certain rows).
  1. Save and Activate
  • Save your workflow and make sure it’s enabled.
7

Thanks!

8

Thanks! this one did solve the problem!

And then there’s a few new problem popped up, I’ll solve them one by one

Thank you every one, giving me great ideas! I’m moving along in my app making

1 Like