Skip to main content
Question

Calculate time in stage

  • May 10, 2017
  • 0 replies
  • 183 views
Hi All,

I am creating an app to track performance by a team and need to be able to say how long an activity has been with them and how long they are waiting on another team. To do this I am looking at having a status field that tracks when the stage is changed. 



Can I use a time calculation to calculate the time in stage from the field history or is there a more sensible way to do this?
    This topic has been closed for replies.

    • MCFNeil
    • Registered
    • May 10, 2017
    Doing a "log Edits" never gives you the reporting capability that you need.

    Create a child table of "Status Logs" and then you can see when it changes from one status to another.  You'll be able to see who changed, when, and easily calculate the time.  even summarize and combine many of the same status times together.

    I've been setting one of these up right now for tracking the lead status for a door to door sales company.


    ***No reverse relationships needed***
    • MCFNeil
    • Registered
    • May 10, 2017
    One click Status Updates (from forms, reports or dashboards)
    If an application could have the status change based on the passage of time, how could those types of changes get logged automatically within this same framework? Likewise, grid edit throws a monkey wrench into all of this. How could those get logged as well?

    Thanks,
    Michael
    • MCFNeil
    • Registered
    • May 11, 2017
    I'm not sure I follow you completely, but...

    If the status changes over time, without a human touch, you would need a cron job running and some advanced logic in the script to update the status. (Either using this set up, or the traditional dropdown)

    Grid edit is a way to mass update records, if you really are mass updating status changes, then I think there might be something wrong with the process, or your should consider an import.
    In our PM system, the status is a formula field. It changes based on the passage of time, entries into a number of other fields, and context within a child table. Grid edit is used to update a number of these other fields, which then affect the status. 
    • MelissaDoran
    • Registered
    • November 29, 2017
    I'm looking into a possible solution with DOMO reporting that integrates with Quickbase. I've messaged them just now to see if their system could report on durations spent in a certain status. I just signed up for a 1 year free trial, and I can see there are many ways that they could overcome the "eyesore" pain of some of quickbases visual 'features'. This duration based reporting would just be another bonus :D
    Terms & ConditionsAccessibility statement