Forum Discussion

RoulaHabbal's avatar
RoulaHabbal
Qrew Cadet
1 year ago
Solved

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
    1 year 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 [email protected]

     

     

DonLarson's avatar
DonLarson
Qrew Deputy
1 year 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
    1 year 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 Deputy
      1 year 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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        1 year 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 [email protected]