Is this approach limited to rooms?
No it is not. When you rent out cars it works as well or anything else that gets out and comes back in (moving like cars or fixed like meeting rooms). When you have bookings with time slots, it works. This also works for hotel rooms. When you rent out the room for the night, the clients leaves early, you clean and you can rent the room for (a part of the day) before the next client comes in for the night. It works for all ‘things’ time related like renting cars, bikes etc. Anything, isn’t it wonderful we can achieve that in Coda?
To keep the doc fast reservations older than a week are moved to another table. This limits the filter reach and helps to keep the doc fast.