For the life of me can't figure this out...
Imagine a non-human resource scheduling system (ie hotel rooms - not really, but close enough). We would like to be able to use timeline view to list all 'rooms' in the building, so that 'booking agents' can distribute incoming guests among available rooms.
What we've done is create a table called 'rooms' and create a table called 'bookings', with bookings table having a timeline view, with records being grouped by 'room' on the Y axis and booking duration on X axis.
The problem is that airtable timeline view only shows rooms that have bookings assigned to them. If a room has 0 bookings, it does not show us on the Y axis. How can we make it so that resources show up on the Y axis of the timeline, regardless of whether they have bookings on them? lack of this feature is the only thing holding us back from migrating from a 20 year old ERP system.
the reason we can't use calendar or grid view for this is because we have 500 'rooms' and each 'guest' books multiple rooms for multiple weeks at a time. A timeline view is the only sane way for a booking agent to be able to gauge how busy the business is and distribute 'bookings' accordingly, ensuring that one 'guest' gets group of rooms that are close together.
would really appreciate any advice of this. thank you.
