Equipment rental booking problem
For my company I've made an equipment booking solution in filemaker.
It works really well and users are able to enter a start and end date. Then they get to see the equipment that's available during that period and they can then book these items and enter a name for a project.
Booked items are stored with a start and end date, project name and invoice number.
This all works very well but there is one problem. This only works for "Unique items".
All your items need to be numbered and entered as seperate items.
But we have about 100 tables and about 500 chairs.
And I can't figure out how I could add these items into my system.
Because the way the availability search works now is simple. You set two dates, and any items booked anywhere during this date range are by defenition not available.
You would think just creating one record for tables and adding the amount in another field.
But then how do you compare different bookings to calculate the actual amount of tables available?
e.g. If you want to book tables for a two week project and there are 10 tables gone in the first week and 10 tables in the second week there are at all times still 90 tables available.
But if those two 10 table bookings overlap for only a day then during that day (and therefore the entire period) you only have 80 tables available.
The problem lies in making a correct calculation accounting for the overlap in dates.
Has anyone had any experience with this kind of situation?
This is a problem I've been wanting to solve for a long time now.