Is there a method to track/log changes to a singular report within Quickbase?

Question

We permission some users to edit the report, but would like to capture WHO did WHAT in a basic auditable fashion?

quickbasecoachd · Answer

There are low tech and Hi-Tech solutions.

QB does not support native audit logging.

Low tech:

Set up a gmail email called mycompany.audit.logger@gmail.com

Set up an email notification to fire when records are added modified or deleted. Include the Record ID or Record identifier in the subject line. use the default message as it will tell you what changed. When you need to know who screwed up a record, then l;ook back into that email; account.

Medium Tech

Same as above but them put icing on that cake by using native QuickBase Sync to Sync to that gmail email content. Then the app will actually have its own table of all changes.

High Tech

Several of the QuickBase Solution partners have add on that do this logging. Not sure who, but probably it includes Trinity and MCF. Here is a list of QuickBase Solution Partners.

I can help you one on one on one off line with solutions Low and Medium. Contact me directly via the information in my profile, or we can continue here.

gerrydaney · Answer

Thanks so much - this worked great. I went with the MEDIUM tech - and all is in good working order. &nbsp;Appreciate the assist -&nbsp;Gerry

quickbasecoachd · Answer

OK, thx for letting me know. &nbsp;Just for the record, i can also set up logging changes via webhooks.

bryanfichtner · Answer

This is genius.&nbsp; I may need some help with the medium tech.

rebeccahdemaray · Answer

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 20Status changed "Report Generation" to "Billed" on 3/12/17Then changed from "Billed" to "Invoiced" on 3/24/17Those are reflected in my QB table as:Subject &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date Created20 3/12/17 Billed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3/12/1720 3/24/17 Invoiced&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3/24/17In 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&nbsp; making sense! Any input is appreciated.&nbsp;

Forum Discussion

Is there a method to track/log changes to a singular report within Quickbase?