Forum Discussion

WarrenBarbour's avatar
WarrenBarbour
Qrew Member
5 years ago

Re: Equipment Rental App - Utilization Rates

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
------------------------------

3 Replies

  • WarrenBarbour's avatar
    WarrenBarbour
    Qrew Member
    5 years ago
    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's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      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
      ------------------------------
      • WarrenBarbour's avatar
        WarrenBarbour
        Qrew Member
        5 years ago
        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
        ------------------------------