Recuring Work Flow At Specific Time

grayson · 2024-12-17T21:06:54.731Z

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.

How can I achieve this?

georgecollier · 2024-12-17T21:09:02.529Z

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.

grayson · 2024-12-17T23:18:31.556Z

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.

georgecollier · 2024-12-17T23:25:42.040Z

grayson:

This seems like a pretty big workaround

No, it’s the right way to do it.

grayson:

Only when Current date/time:formatted as hh:mm = 01:00

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.