Perfect Bob!!! 
I’m glad you achieved that! I did exactly how you did, you got it right
1 Like
It was a brilliant solution. Works well for open ended bookings. For those with set durations and limitations, it isn’t the best UI yet. Event picker needs more data validation to make that happen.
2 Likes
100% agreed. When we got it and also the calendar similar to event picker layout, as @Antonio showed us, will be amazing
1 Like
Anyone that can notice a fix in real time should be afforded the title of Expert.
Everyone who understands and contributes to this specific topic should also be afforded the higher rank.
Do not even consider me worthy of such acclaim.
2 Likes
@Les_Henderson I’m here for the equalist pursuit of making this s*&t work. Don’t believe in ranks of any sort. Just tables of 40 columns for validation and glad I’m not the only stubborn creature doing it. But you are kind and an expert in your own right, I’m sure of it.
Important: the above is not characterization of Glide as a platform but rather, the quirkiness of datetime stuff.
3 Likes
@Rasha I’ve been struggling with those points for months, and said here many times!!
3 Likes
great work @Lucas_Pires! your approach is very efficient and tidy.
3 Likes
Thank you!
It’s the mutually beneficial interactions of like-minded altruistic people that ultimately make the world go round.
All the rest is a detractive distraction.
3 Likes
Legend!! 
1 Like
Wrapped my head around how you did that for your use case and want to apply it to my Flight Scheduling app where a PILOT has to choose an AIRCRAFT and an INSTRUCTOR where none of those 3 variables can ever be double booked but because of the multiple PILOTS/INSTRUCTORS/AIRCRAFTS there can currently be up to 6 flights at the exact same time until we add additional AIRCRAFT.
There are 30+ Pilots/Instructors and 6+ Aircraft.
How might your method change to accommodate a USER/GUEST/ROOM whereas mine would be a PILOT/INSTRUCTOR/AIRCRAFT?
Was there a solution that I missed about being able to scroll through (or at least choose) a different week than the current one using the Event Picker?
1 Like
You mean on a desktop browser? I haven’t seen anything regarding that. Works fine on my android by tapping the date in the picker.
1 Like
Exactly. Works on a phone…not in the browser.
3 Likes
I was scrolling like a maniac yesterday on Chrome thinking why does it not go over next week lol.
3 Likes
On your next layer when choosing a ROOM and/or PERSON…
Doesn’t your 0/1 have to be dynamic and change based on if the ENDTIME is before NOW? The way your current build looks, your ROOM/PERSON variables would be a static ROOM#/PERSON# and would never become available after they have been booked a single time.
Sorry…having a hard time following. The way I have this built is by using a template 0-ROOM# and relating this to any time there’s a 0-ROOM in the booking submission log. The 0 appears when there is a conflict and a 1 appears when there is no conflict for each time already booked. So, a time is available only when there are no conflicts (0s). If the 0-ROOM# returns a match, that means there must be at least one conflict and thus prevents the user from booking.
If you wanted to add additional layers (0-ROOM#-INSTRUCTOR) for instance, then you’d simply add INSTRUCTOR to the template columns in both sheets which would open up availability. Or, if you wanted to allow max 3 bookings per room, you’d do a rollup on the relation to get the count and if the count is >=3, then you’d prevent the user from booking.
2 Likes
So using your method, I can allow 2 students to book 2 different rooms with 2 different instructors at the exact same/overlapping time AND prevent others from booking those same rooms/instructors during those times.
I’m assuming the way your method works is only based on finding conflict in TIME and not on TIME + ROOM.
Exactly. And no, my method is finding conflicts with TIME+Room.
Last question before I build it out, and delete over 500 columns, is template column looking like Time + Room & Time + Instructor or Time + Room + Instructor?
Breaking them up would allow you to reference which variable needs to be changed in order for a successful booking correct?