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

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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.  
Photo of Brian

Brian

  • 200 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,658 Points 10k badge 2x thumb
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.