Report to show duration between each status change

Question

I set up notifications to go to a GMail account for any changes to a "Status" field (multiple choice). I then made a new table title "Edit Log" and linked it to the GMail data. Within this table, I have columns "Subject" and "Date Created" ....Within the Subject column for my notifications, I've chosen to display the Record ID, Date, and Status (ie Billed, Invoiced, etc.)

Can I somehow create a report to show duration between each change on a each record? I'm trying to find any delays in our billing work flow.

Example:
Record 20
Status changed "Report Generation" to "Billed" on 3/12/17
Then changed from "Billed" to "Invoiced" on 3/24/17

Those are reflected in my QB table as:

Subject                                       Date Created
20,3/12/17,Billed                          3/12/17
20,3/24/17,Invoiced                      3/24/17

In order to do what I need, I feel like I need additional fields for the Record, and Status, but not sure if it's possible to show duration once I get those fields to populate (Using functions "Right" and "Left"). I hope I'm making sense! Any input is appreciated.

MCFNeil · Answer

You should make the "Status Change" a child table of the the main Job.

Then you can do it all within QuickBase without notifications, or sync. Then you can easily see the duration of each status right in one spot.
You can also make the status change, but clicking "one" button. You can also see who, and when status changed.

Its a much cleaner solution, happens instantly, much easier to maintain, and is not dependent on outside systems.

Sign up

Login to the community