Re: Is there a way to track who modified a specific field being changed?
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.
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.
