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
MarkShnier__You
Qrew Legend
Qrew LegendOK, here is another solution.
Make a summary field on the Equipment for [# days rented out M0], where M0 means the current month.
Then duplicate that field to be called [# days rented out M-1] ie month zero minus 1 ie last month and adjust the filters.
Keep giong to about 24 of these so you have a two year history.
Then if you want to not have those somewhat non user friendly field names, you could create a nightly process to run 24 saved table to table copies to copy these to another table were each record represent an equipment and the first of the month dates (key field in the format [Record ID# [f equipment] - YYYMM01. so then it will easier to create proper report and nice charts.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Make a summary field on the Equipment for [# days rented out M0], where M0 means the current month.
Then duplicate that field to be called [# days rented out M-1] ie month zero minus 1 ie last month and adjust the filters.
Keep giong to about 24 of these so you have a two year history.
Then if you want to not have those somewhat non user friendly field names, you could create a nightly process to run 24 saved table to table copies to copy these to another table were each record represent an equipment and the first of the month dates (key field in the format [Record ID# [f equipment] - YYYMM01. so then it will easier to create proper report and nice charts.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------