Problem Summary:
I am trying to set up a condition in my Bubble app where a user has to wait 1 hour before they can retry a quiz if they fail. I want to compare the current time (Current date/time
) with the time 1 hour after the user’s last quiz failure (stored in last_failed_time
). However, I am having trouble using the :plus
operator in the conditional logic to add 1 hour to the last_failed_time
.
What I’ve Tried:
- I’ve selected
Current date/time
andSearch for Total course Progress's last_failed_time
, but when I try to add:plus hours 1
, I don’t see this option in the dropdown. - I’ve tried typing
:plus
manually, but the Bubble editor doesn’t seem to recognize it within the condition builder. - I’ve explored using operators like
formatted as text
orformatted as number
, but they don’t allow me to compare dates with added time.
What I Want to Achieve: I need to check if 1 hour has passed since the user’s last quiz failure, with a condition like:
sql
Copy code
Current date/time > last_failed_time:plus hours 1
Questions:
- Is there a specific way to add time (like 1 hour) to a date in a condition without using workflows?
- Is there another approach I should try for comparing the current time and a time that’s 1 hour later than the
last_failed_time
?
Any advice on how to add 1 hour to a date/time field in a condition would be greatly appreciated!
Additional Details:
- I’ve added a field in my database (
last_failed_time
) to track when the user last failed the quiz. - I want the user to wait 1 hour before they can retry the quiz, and the condition should only allow retry if 1 hour has passed.