Forum Discussion

RoulaHabbal's avatar
RoulaHabbal
Qrew Cadet
19 days 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's avatar
    MarkShnier__You
    19 days 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's avatar
    DonLarson
    Qrew Elite
    19 days ago

    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's avatar
      RoulaHabbal
      Qrew Cadet
      19 days 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's avatar
        DonLarson
        Qrew Elite
        19 days 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.