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