Equipment Rental App - Utilization Rates
I'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 f...
Forum Discussion
Thanks so much Mark! As always from you, fantastic solution!
------------------------------
Warren Barbour
------------------------------
------------------------------
Warren Barbour
------------------------------
Hi 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 arguments that 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
------------------------------
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 arguments that 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
------------------------------
- Hi. 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
------------------------------- MarkShnier__You
Qrew Legend
Yes, that is a Great solution. I think my flaw was that since one record crosses many days you need to know many days it was rented and not how many times.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thanks 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
------------------------------
