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.
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.