Forum Discussion
Pulling "Open" slots from a table into a separate tab
Thank you, this is so helpful! I do wonder if it's possible to translate the output into list form like this? Not sure if you know a way to do that.
I'm sure it's possible, but nothing pops to mind immediately.
If you're populating the "Table" data already, based on changes to "InputData," I should think you'd be able to puzzle that through as well. I just don't have the time at the moment, but it'll be percolating in the back of my mind for the rest of the day.
It would help to know if there's a minimum and maximum to the magnitude of reservations you accept. The two examples are quite different, I note. Your basic table of times has a granularity (if one can think of it that way) of 15 minutes, quarter hours. Table reservations would routinely run at least 60-90-120. If one could make some specific assumption about that sort of thing, it would get easier.....
That said, assuming you're looking for blocks of time that are open, I would think that this display you already have would be very functional.
Gotcha, thank you! Any help would be appreciated if you have the time.
There is actually a min and max length with a couple differences in between.
Normal Reservations (Labeled "FT"):
60/90/120/150 minutes with 15-minutes set-up and 15-minutes bussing
Event Reservations (Labeled "AO"):
120/150/180 minutes with 30-minutes set-up and 15-minutes bussing
The only reason why it is broken out into 15-minute time periods is to account for the 15-minute bussing blocked off!
- Gotcha, thank you, any help you can provide would be really appreciated! Yes. There's currently a fixed reservation length of the following:
Normal (Marked as FT):
60/90/120/150 minutes with 15 minutes of set-up and 15 minutes of bussing
Events (Marked as AO):
120/150/180 minutes with 30 minutes of set-up and 15 minutes of bussing
It's only in 15 minute time periods to properly block of bussing and times.