Hi everyone,
I'm currently building a rental (lending) system for my inventory and I need help tackling an issue with how I register multiple rentals on the same item.
I've entered an inventory of some 150 items in one table, a lender registry in another and a project list in a third.
I've made a separate table where I register loans and returns back into the inventory. Consider this a log.
Here I've made a formula, where you pick who the lender is, what project they are affiliated with, and what items they are lending.
When the record is submitted, it updates all items in the inventory and changes their status from in-house to unavailable or vice versa.
All of that works thanks to several links, automations and formulas.
However!
I would like to register future loans and when they are expected to be returned.
And here is where it all gets dicey.
How do I register multiple dates in a timeline or gant view on the same item and line?
Especially since the solution should suit infinite entries due to the fact that logs will continue to be made into the foreseeable future.
I could gather all of the start and end dates in a lookup field, but the Timeline and Gant view obviously cannot compare the start and end date lookup fields and make the right conclusion on what are intervals.
Furthermore it would be great if I could make a check in formula making it impossible to lend stuff which is unavailable on certain dates - but that seems like science fiction at this point.