Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Hotel room capacity/contingent planning

Topic Labels: Formulas
801 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey everyone,
I’m trying to create a hotel room capacity plan so I can see if we have enough rooms of a category left or if we’re overbooked.
I have one table where I create rows for each speaker who needs a hotel room from arrival to departure date. image.png
In another table I have my capacity plan that applies for each day.
image
Now I’m trying to make a capacity plan for each day for each room to see if we’re overbooked or have spare rooms. I know how to do it in Excel but am not quite sure how to continue here. I started with another table that has all dates and booked and available rooms but don’t know how to get all booked rooms within in the date ranges.
Appreciate your feedback.
Isabelle

0 Replies 0