Forum Discussion

Qrew Cadet

2 months ago

Record Details

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

other

MarkShnier__You
2 months ago
Roula,
You can enable logging of selected fields by going into field Properties and enabling the setting for
Track field This field will be tracked for audit purposes
.
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.

If you had a strong enough business need, 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. If you had a need for that and a very small Consulting budget we could book some one on one and get that working for you mark.shnier@gmail.com

DonLarson

Qrew Elite

Not by just looking at the record. 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.... is not really a change but an addition to the child table. That is not a good strategy for a long list of demographic fields but hopefully takes care of your most important ones.

RoulaHabbal

Qrew Cadet

2 months ago

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
Qrew Elite
2 months ago
Roula,
The audit log will tell you that information. However the last time I saw a presentation on it, there was a limit to the total number of things you could track there. 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.
- MarkShnier__You
  Qrew Legend
  2 months ago
  Roula,
  You can enable logging of selected fields by going into field Properties and enabling the setting for
  Track field This field will be tracked for audit purposes
  .
  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.
  
  If you had a strong enough business need, 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. If you had a need for that and a very small Consulting budget we could book some one on one and get that working for you mark.shnier@gmail.com
  - RoulaHabbal
    Qrew Cadet
    2 months ago
    Thank you, Mark.
- RoulaHabbal
  Qrew Cadet
  2 months ago
  Thank you, Don.
  Roula