Record Details

Question

Hello:Is there a way to get details about a specific record, such as who worked on the record, edits made, etc.?The Admin Console Audit Logs are not giving me what I need.Thank you,Roula

donlarson · Answer

Not by just looking at the record.&nbsp; It will tell you, who modified it and when it was last modified, but not what they changed.If there are fields that you really need to track, I make them as child records so that a change of status, forecast date....&nbsp; is not really a change but an addition to the child table.&nbsp; &nbsp; That is not a good strategy for a long list of demographic fields but hopefully takes care of your most important ones.

roulahabbal · Answer

Hi Don:Thank you. Are you saying the Audit Logs would provide who and when a specific record was modified? I see a field to specify the application name, but that's all.Thank you,Roula

donlarson · Answer

Roula,The audit log will tell you that information.&nbsp; However the last time I saw a presentation on it, there was a limit to the total number of things you could track there.&nbsp; You have to set it up for the specific things that you want to audit, it is not not automatically tracking 100% of your data changes.&nbsp;

markshnier__you · Answer

Roula,You can enable logging of selected fields by going into field Properties and enabling the setting for&nbsp;Track field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This field will be tracked for audit purposes.&nbsp;There is some limit to how many fields you can track and it might be 10 but I'm not sure of that number, it may be a higher limit. The current problem with native audit logging is that it is more suited for forensic analysis as only a Quickbase administrator can go in and dive into the details and it's a bit hard to use.&nbsp;&nbsp;If you had a strong enough business need,&nbsp; there is a way to set up a native Quickbase child table that would show the name of the field the old value the new value and the date and time and who changed it.&nbsp; If you had a need for that and a very small Consulting&nbsp; budget we could book some one on one and get that working for you mark.shnier@gmail.com&nbsp;&nbsp;

Forum Discussion

Record Details