Formula for Hire Management
Hi all,
I have a table called 'Assets' with an 'Asset Name' and 'Qty' field.
I also have a 'Asset Bookings' table with a Date + Time fields 'Hire Out' and 'Hire In'.
The Asset Bookings table has a subtable called 'Items' which contains the fields 'Asset Required' and 'Qty Required' and a formula field called 'Conflict'
I am looking for a formula for the Conflict field in the subtable, to check if the ''Qty Required' is available, based on other Bookings of that Asset.
Any help would be appreciated.
Thanks.
2 replies
-
Adding some more details here, the closest similar post I can find is here: https://forum.ninox.com/t/x2h7flg/script-to-confirm-date-time-availability#60h7frq answered
Which I've tried to adapt to include Quantity, but have had no luck in doing so, even if I can get something that doesn't show errors, it just doesn't work at all.
Screenshots below of my setup.
-
Here is a sample DB. I took a different route. I figure you only need to see conflict when you enter in a booking. So I created a Date Entry Page that shows how this could be done.
Once you select a date range, which I have already done, then you can select an Asset and see how many is inventory and how many has been allocated in that date range. It will also show you the Bookings that fall within that range and the assets assigned and quantity.
Content aside
- 10 days agoLast active
- 2Replies
- 24Views
-
2
Following