Button Cooldown

I’ve coded a button so that when pressed, it increments a number within the spreadsheet by 1. This is fine, however, is there a way to add a 24 hour cooldown to it? Therefore, users can only press the button once every 24 hours. If they attempt to do it more than once within the 24 hours, then it will show the failed notification and will not increment the number by 1.

Many thanks in advance.

Could you add an action to record the time that it was pressed to a column, add another column to have the current time, and then an if statement to see if it is within 24 hours? If yes, do not display the button, if no, display the button?

I have similar logic in my daily tasks template that you could use as a base: Daily Goals Tracker Template • Glide

I believe I have it by day and not within 24 hours but you could adjust it as needed.

Happy Building!
Justin

2 Likes

Exactly.

  1. Button push has a set column of current date and time.
  2. Math column to add 1 to the date.
  3. If then else column to check if Math column is after > now
  4. If is after now, show notification that they must wait, else allow button
5 Likes

Thanks very much both of you! I really appreciate the help.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.