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.
Question
Is there a way to track who modified a specific field being changed?
This topic has been closed for replies.
+17Hi 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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.