Discussions

Expand all | Collapse all

Is there a way to track who modified a specific field being changed?

  • 1.  Is there a way to track who modified a specific field being changed?

    Posted 05-24-2019 01:38
    Is there a way to track who modified a specific field being changed? I have a a check box called "Checked In". I would like to be able to see which user selected this option and when it was done so it could be referenced later if needed. There may be other changes in the form that could occur after the "check In' box was selected so i can not relay on the "last modified by" remarks on the bottom of the form to specifically provide accurate details as to who changed the specific  checkbox once other fields are edited in the future.  


  • 2.  RE: Is there a way to track who modified a specific field being changed?

    Posted 05-28-2019 14:25
    Hi Brian,

    This is often a really great use of Actions or Quick Base Automations to help you track when a specific field is changing. Actions/ Automations can be set up to trigger off of specific field changes and can capture certain pieces of information. In this instance you could create an Audit table to track when a checkbox field was checked and by who. When I do this I usually make a table called Audit and include the following fields:

    Record ID of Parent Record
    Date Modified 
    User 

    this way you have a place to put the Record ID of the record that triggered the change, when it was changed, and who is it was trained by. Then on the table that has the checkbox you create an Automation so that whenever a record on this table is edited and specifically the Checked in field is changed create a record in the new Audit table and copy over the record id, date modified, and modified by fields. This way each time that checkbox field is changed a new record is created to capture everything you know. Now you have an Audit table you can set permissions on so that only specific people can see or everyone can see the record of changes. I hope this information is helpful.