ContributionsMost RecentMost LikesSolutionsRe: Equipment Rental App - Utilization RatesThanks for all of your help and guidance! Fantastic to have you out there providing awesome support. I had been racking my mind on this one for a while and leveraging Quickbase's automated table imports is such a powerful option. I just finished building out the solution along with the reporting function and all seems to working as needed. Hope you stay safe and have a great summer! ------------------------------ Warren Barbour ------------------------------ Re: Equipment Rental App - Utilization RatesHi. What about this option. I create a new field on each rental record that determines if Today falls within the Start Date and End Date of the rental period, if it does a value of 'Active' is assigned, otherwise a value of 'Inactive' is assigned. I would then run a nightly automation to import only 'Active' equipment rental records (daily) through a table-to-table import routine into a new table, that would support any historical reporting needed. Does that seems to make sense? ------------------------------ Warren Barbour ------------------------------ Re: Equipment Rental App - Utilization RatesHi Mark, I tried to work through a number of ways in an effort to determine "# days rented out M0", without much success. I had tried a series of argumentsthat looked to check the month/yr values of current month to the Start Date and End Date of each rental period, and then make a series of calculations to count either days between Start Date and End Date, or days between start of month to End Date, or lastly, days from Start Date to end of month. Seems like there must be a better way. Can you offer any further guidance? ------------------------------ Warren Barbour ------------------------------ Re: Equipment Rental App - Utilization RatesThanks so much Mark! As always from you, fantastic solution! ------------------------------ Warren Barbour ------------------------------ Equipment Rental App - Utilization RatesI'm working on early phase design for an app that will be used to manage equipment rental for a small operator. One of the key design requirements is for the app to track dollar and time utilization for each piece of equipment, across the entire rental inventory on a monthly basis. At the end of a given month, I need to be able to be able to report that summarizes the number of days each piece of equipment had been rented out of the total days in the month. My initial thoughts are to create an Equipment table, with a unique record for each individual piece of equipment in inventory, and a related Rentals table to track individualrental agreements, along with a third table to manage Customers. To simplify the solution at this point, each rental record will only have one pieceof equipment, although a future many-many relationship could be in play. Rental periods will range from a minimum unit value of 1 day and 365 days. The challenge I'm having in the design is that if a rental period for a piece of equipment spans across more than one given month, I can't seem to find a way to allocate x days for month 1, and y days for month 2. I don't want to anchor a duration of rental days to either the start or end date of a rental record. The only thing I can think of at this point is to build an automation to create/import a month-end snapshot against the rental table and post those month end views into a 4th Monthly Report Snapshots table simply to track rental days per piece of equipment. As much as I'm sure this would be common for anything app used to track resource utilizationspanning periods of time, I can't seem to find any related solutions. Any other thoughts out there? ------------------------------ Warren Barbour ------------------------------