I’m trying to build an app to allow people to book a room or space (e.g. a desk) for a meeting. The similar examples I’ve seen don’t seem to work for my needs - e.g. a class booking app works because a teacher sets office hours and then a student can book one of the sessions. I need a room to be available either 24 hours a day or between certain business hours (9-5 etc.). I’m not clear if I can do the kind of search logic needed here (spaces without bookings vs. unbooked sessions).
I’ve got collections for spaces/rooms and bookings with a relationship property between them:
When a user searchers for a space on a certain date/time, I want to have only spaces without bookings at that date/time to show up:
I’m not seeing the options I need in the filters on the list of spaces:
I tried doing something to set the search value on the user record once they hit search:
I was hoping that could then be used in the filter but that didn’t seem to work:
Any help is appreciated. Even advice on how to better ask this question or point out what’s not clear, would be amazing.