Scenario: A user completes today’s lesson, and they cannot start the next lesson until 1:00 AM the following day.
The challenge is that I don’t know when the user will finish their lesson, so the standard recurring event options (minutes, hours, days, weeks) don’t fit my needs.
Everything else in my setup is working—I just need help with the workflow to set the Start Date of the recurring workflow specifically to 1:00 AM the next day, regardless of when the current lesson is completed.
Have a database trigger ‘Only when Lesson now’s completed is yes and lesson before change’s completed is no’.
That’ll run whenever the lesson is completed. Then, inside the trigger, schedule API workflow to run at 1:00am on Current date/time:rounded down to day +hours 25, and that’ll run at 1:00am the next day.
Inside that workflow, add the lesson to the user’s account or whatever you want to do.
This seems like a pretty big workaround. Could I just run it daily and within the workflow add a condition: Only when Current date/time:formatted as hh:mm = 01:00? Or something like that? I am just unsure of how to do that within bubble.
If this was possible, it would entail checking this condition every second, which is wildly inefficient. That’s why we schedule something to happen at a particular time, rather than checking if it is a particular time.
