How to prevent Overlapping Bookings

recker249 · 2024-12-21T18:00:27.280Z

I am creating an bookings based website and I need help solving how to prevent bookings that are within the timeframe of another booking (from the same user). I don’t have a problem with different users choosing the same time to book a session. I have problem with the same user booking another session within the timeframe of the first booking. Like for example if a user books something for 1pm - 2pm, that same user shouldn’t be able to book anything in between 1pm - 2pm. They shouldn’t be able to book anything at 1:45pm. Sort of like what this website does below. When user book an session, the same user cannot book another session within the timeframe that another session is booked.

I am trying to duplicate the exact same functionality from the website below.

Flow Club

boston85719 · 2024-12-22T06:23:31.110Z

My plugin will help

Bubble

Templates for Bubble

Buy and sell Bubble templates to speed up app development. Bubble is a visual programing language that lets you build apps without code.

Just when creating available timeslots, add not only the professionals existing bookings, also add the bookers existing bookings. The result will be timeslots when both are available only

recker249 · 2024-12-22T22:11:16.322Z

Thank you, but I prefer to not rely on plugins. I am confident that there is a work around that can be done without plugins.

recker249 · 2024-12-22T22:24:20.441Z

Anyone else willing to help?

rpetribu · 2024-12-23T01:17:28.377Z

This can be done by many ways… It will depend on how you built your booking system…
Can you share more details about workflows and databases?

recker249 · 2024-12-23T01:37:36.606Z

Screenshot 2024-12-22 at 8.35.10 PM1909×687 107 KB

Screenshot 2024-12-22 at 8.35.14 PM705×604 55.6 KB

Screenshot 2024-12-22 at 8.37.00 PM1365×850 80.6 KB

Screenshot 2024-12-22 at 8.37.09 PM1369×771 95.2 KB

recker249 · 2024-12-23T01:39:01.979Z

As you can see in the photos above, I am getting close to the solution, but I maybe getting something confused. I have been getting help from ChatGPT as well, although they may not be entirely accurate.

recker249 · 2024-12-23T01:54:22.239Z

For anyone willing to take a look at my workflows, I can provide you access to view my editor. Please dm your email address.

recker249 · 2024-12-23T02:03:09.856Z

Screenshot 2024-12-22 at 9.02.42 PM692×597 55.2 KB

recker249 · 2024-12-23T02:54:09.211Z

Turns out the answer wasn’t right. Is anyone willing to look at my editor. please give me a dm.

recker249 · 2024-12-23T02:55:28.176Z

I know I’m getting close to the result I want, and the result I came up with seemed okay but it’s not functioning exactly like I want it as described by my first post.

boston85719 · 2024-12-23T04:00:34.689Z

Do you need it to work across time zones, like when the booker with existing bookings is in a different time zone than the professional?

Do you need to generate more than one potential timeslot when both are available?

Do you want to incorporate the normal availability schedule of the professional, so not just their existing bookings but also their availability like 9am - 3:30PM?

hanan1 · 2024-12-23T04:10:03.058Z

the conditions for start & end time here are mixed up; you want this time slot so start date should be >= and end date should be <=

looks like you changed them when you changed the workflow condition to count<1, but they were correct. keep the count condition and change the filter conditions.

recker249 · 2024-12-23T16:14:07.752Z

I tried that as well and it only seems to be giving me half that functionality. My guess is there needs to be more constraints. But not sure what they are…

boston85719 · 2024-12-23T17:17:58.508Z

recker249:

I tried that as well and it only seems to be giving me half that functionality. My guess is there needs to be more constraints. But not sure what they are…

boston85719:

Do you need it to work across time zones, like when the booker with existing bookings is in a different time zone than the professional?

Do you need to generate more than one potential timeslot when both are available?

Do you want to incorporate the normal availability schedule of the professional, so not just their existing bookings but also their availability like 9am - 3:30PM?

Let me know

recker249 · 2024-12-24T16:33:05.447Z

For anyone who wants to take a look. Here’s the link to my editor. (Don’t worry about the 80+ issues)

boston85719 · 2024-12-25T11:12:42.227Z

Looks like you can create meetings and there is no availability schedule applied at all so can overlap and get double booked.

Screen Shot 2024-12-25 at 6.11.18 PM1481×601 33 KB

Do you need this to work across different time zones?

Do you need to generate more than one potential timeslot when both users are available?

Do you need to incorporate an already known normal availability schedule of the professional?

recker249 · 2024-12-25T17:50:13.672Z

That is not what I am going for. This is not the traditional booking platform. This app won’t be using an availability schedule. Users will be booking meetings without an availability schedule. I am mimicking the scheduling functionality that these two websites are doing. Please refer back to my 1st post.

Flow Club
Focusmate

sem · 2024-12-25T18:06:10.704Z

So you basically want to be able to say, I want to allow a new booking that starts at unix time a and ends at Unix time b that does not overlap any existing booking. So there cannot be any other booking in the system that has an end time in Unix or a begin time in Unix that is in between the booking window?

boston85719 · 2024-12-26T05:31:00.241Z

First you need to create this. Looking at your editor, this is not done yet, but based on the post, I’ll assume you already know how to do it and are in the process of putting it together…it is basically an availability schedule of the professional, which is a schedule of their available times to perform the session.

Screen Shot 2024-12-26 at 12.25.24 PM1119×687 71.4 KB

Once you create your functionality to allow a professional to create their events and the availability schedule for those events, then you need to create the booking functionality you asked about.

As per the site you reference you are trying to create, it doesn’t even have the functionality you are asking for. On my first attempt after signing up I was able to book a 60 minute session starting at 12PM on Dec 26th and then I booked a 12:30 PM session that is 60 minutes also starting Dec 26th.

Screen Shot 2024-12-26 at 12.28.47 PM500×479 21.6 KB

Screen Shot 2024-12-26 at 12.28.12 PM499×480 22.1 KB

Screen Shot 2024-12-26 at 12.30.15 PM1088×679 72.3 KB

So, if you are looking to just replicate the site booking functionality, don’t worry about double booking as the site you want to replicate doesn’t either and just let the user book a session whenever they want.

But to avoid a user from booking themselves into another event that overlaps an existing event they booked, create date ranges for the booked sessions of a user and then when the user wants to book another session that overlaps, get the date range of that session to see if any points overlap. There are operators for this, so check out bubble manual for operators and how to work with date ranges.