# Convert Date Range to 30 Minute Time Slots **URL:** \ **Category:** Need help\ **Created:** [July 16, 2020, 2:03pm UTC](https://forum.bubble.io/t/convert-date-range-to-30-minute-time-slots/102036 "2020-07-16T14:03:28Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![rod.danan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rod.danan/32/148092_2.png) [@rod.danan](https://forum.bubble.io/u/rod.danan)\ **Post date:** [July 16, 2020, 2:03pm UTC](https://forum.bubble.io/t/convert-date-range-to-30-minute-time-slots/102036/1 "2020-07-16T14:03:28Z")
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! ---
**Author:** ![J805](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/j805/32/41267_2.png) [@J805](https://forum.bubble.io/u/J805)\ **Post date:** [July 16, 2020, 2:57pm UTC](https://forum.bubble.io/t/convert-date-range-to-30-minute-time-slots/102036/2 "2020-07-16T14:57:47Z")
Hey 👋 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. Editor: [https://bubble.io/page?type=page&name=schedule&id=805testapp42&tab=tabs-1](https://bubble.io/page?type=page&name=schedule&id=805testapp42&tab=tabs-1) Preview: [https://805testapp42.bubbleapps.io/version-test/schedule?debug\_mode=true](https://805testapp42.bubbleapps.io/version-test/schedule?debug_mode=true) @j805 [www.NoCodeMinute.com](http://www.NoCodeMinute.com) Hope that helps! 😊 ---
**Author:** ![rod.danan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rod.danan/32/148092_2.png) [@rod.danan](https://forum.bubble.io/u/rod.danan)\ **Post date:** [July 16, 2020, 6:05pm UTC](https://forum.bubble.io/t/convert-date-range-to-30-minute-time-slots/102036/3 "2020-07-16T18:05:58Z")
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. ---
**Author:** ![J805](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/j805/32/41267_2.png) [@J805](https://forum.bubble.io/u/J805)\ **Post date:** [July 16, 2020, 7:26pm UTC](https://forum.bubble.io/t/convert-date-range-to-30-minute-time-slots/102036/4 "2020-07-16T19:26:00Z")
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. 😊 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! 😊 ---
**Author:** ![rod.danan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rod.danan/32/148092_2.png) [@rod.danan](https://forum.bubble.io/u/rod.danan)\ **Post date:** [July 17, 2020, 7:24pm UTC](https://forum.bubble.io/t/convert-date-range-to-30-minute-time-slots/102036/5 "2020-07-17T19:24:43Z")
YES! That helped a ton. It’s my first API workflow but I can’t believe how simple that was. Thank you so much! ---
**Author:** ![J805](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/j805/32/41267_2.png) [@J805](https://forum.bubble.io/u/J805)\ **Post date:** [July 17, 2020, 7:50pm UTC](https://forum.bubble.io/t/convert-date-range-to-30-minute-time-slots/102036/6 "2020-07-17T19:50:57Z")
You’re welcome! They are extremely helpful in a lot of situations. So glad it could help! Keep up the good work! 😊 ---
**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\ **Post date:** [September 24, 2020, 2:03pm UTC](https://forum.bubble.io/t/convert-date-range-to-30-minute-time-slots/102036/7 "2020-09-24T14:03:33Z")
Closed on September 24, 2020, 2:03pm UTC This topic was automatically closed after 70 days. New replies are no longer allowed.