Convert Date Range to 30 Minute Time Slots

Hey everyone! In my app a business adds 3 datetime ranges as their availability. Each date range would be for one day and just a time range. For example, 7/6 8:00AM - 7/6 10:00AM.

What I need to do is basically create time slots out of this. I would want to have it where after a business submits their availability, some workflow would run that would then create a list of datetimes to save to another field as timeslots.

This way when an intern books an interview with them, I can remove that timeslot as an option for other interns. Would then display these options in a dropdown or repeatinggroup.

PLEASE HELP as this is driving me NUTS!

1 Like

Hey :wave:

I know it can be super frustrating to be working on something when you can’t figure it out. I have an example if you would like to see it. This would create it in the database for you. Click on the date and the slots will show up underneath. If you have a paid bubble plan you can do this a lot more simply by using backend workflows. The backend workflows would make the process a lot simpler. This is just a workaround since I have a free plan that I am using to show you.



Hope that helps! :blush:

1 Like

I’m on the Personal plan so I have backend workflows. What would you do differently to get that set up? Note that I haven’t gone deep into those so I’m a beginner in that part of Bubble.

1 Like

Ok, I set up the backend workflow for you to take a look on how to do it. It just won’t run because I don’t have my test app on a paid plan. Let me know if that helps. :blush:

It just allows for a few less workflows and more streamlined. It also won’t stop working if the user closes their browser during the creation process.

Hope that helps! :blush:

YES! That helped a ton. It’s my first API workflow but I can’t believe how simple that was. Thank you so much!

1 Like

You’re welcome! They are extremely helpful in a lot of situations. So glad it could help! Keep up the good work! :blush:

This topic was automatically closed after 70 days. New replies are no longer allowed.