Hi,
I am trying to create a desk booking function. Currently, I am able to have user booked desk though selecting the desk and it will display if the desk is available or unavailable.
I want to advance that process by letting the user see all of the desks available and have them selected the date and time first and then the screen then shows a ‘hint’ what’s available or short the available one first?
I have many columns set up is there a easy to way to do this?
I think I got something working 
I used two tables - one for desks, one for bookings linked to the desks.
I created a query in the user table to return bookings that collide with the selected time. Then, I’m looking up desk IDs related to the bookings.
Finally, I’m subtracting array of booked desk IDs from all desk IDs. The result is an array of available desks at the selected time.
I think what we could do from there is add another other query with adjustable tolerance range and output closest results with similar method.
2 Likes