I’m starting to work on a room booking app and was wondering if anyone has figured out a good way to create a way to prevent conflicting days/times (so that if I book a meeting on Monday from 9-10AM, this time slot can’t be booked by someone else).
I know I could create a choice component that lists the possible days/times and then can probably figure out a way to remove choices as they are taken, but this doesn’t take into account all possible time choices (sometimes people will book on the 15 or 30, so my choice component would need to be huge to capture all possibilities).
I’m thinking the way to do it is to have form with a date select and then two time selects (start time and end time). In my spreadsheet, there may be a way to figure out what times are being taken by the starttime+endtime on a particular date and prevent it as a possibility. The issue I’m seeing is that there is no “Time” component available (just Date/Time). Again, I could use choice components to get the time separate from the date, but I wonder if a Time only component may be in the works…?
Has anyone else tried to tackle this sort of time slot booking scenario?