Currently, I have Data Types for Product Availability & User Availability.
I would like the timeslots to hide if the count of bookings for a given time range is greater than or equal to the count of User Availability for that same time period. I’ve set up a Product Availability because I want to give users control over what time this certain product is available. Still, of course, the product’s availability will also be dependent on the User Availability.
For example, I own a massage shop that offers Swedish Massage from 9am-11pm. I have 3 masseuses that have User Availabilities of 9am-11pm, 10am-5pm, and 3pm-12am respectively.
How would I merge all these availabilities into a repeating group showing the correct available time slots? Then, the timeslot should disappear if the count of bookings becomes greater than or equal to the count of intersections between Product Availability & User Availability. I’m also having trouble getting the proper start times based on the intersections of these two data types. Not sure if you can even evaluate the Product Availability against each User Availability.
I’m thinking it’s possible with nested repeating groups, in which, in my massage shop example, there will be 3 different sets of time slots for each of my 3 masseuses.
However, if it is possible to combine all 3 into 1, that would be much preferred.
Am I making sense? I feel like I’m complicating this more than I should. But I also believe this is possible on Bubble.
Any help would be greatly appreciated. Thanks!