RebeccahDemaray
Qrew Member
Joined 5 years ago
User Profile
User Widgets
Contributions
Report to show duration between each status change
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.1View2likes8CommentsRe: Is there a method to track/log changes to a singular report within Quickbase?
Interesting! I set up the "Medium Tech" option and on the linked table I have columns "Subject" and "Date Created" ....Within the Subject column, 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 separate fields for the record id, date and status, but not sure if that's a possibility with the link between GMail and this table. I hope I'm making sense! Any input is appreciated.0Views0likes0Comments