Forum Discussion
RebeccahDemaray
8 years agoQrew Member
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.
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.