ContributionsMost RecentMost LikesSolutionsRe: Audit Log - Add field that identifies which field changedThank you! Yes, I was definitely overthinking it. I appreciate your assistance!! ------------------------------ Connie Broadie ------------------------------ Re: Audit Log - Add field that identifies which field changedI think the light bulb just went off. I got it. Thanks! ------------------------------ Connie Broadie ------------------------------ Re: Audit Log - Add field that identifies which field changedYes, I have 25 different automations, one for each field we need logged. I didn't know I could do that... So how would I do that? I don't want the info that is in the field, I want the field name. Would it be a formula field? It is probably a super simple thing, but the lightbulb is not going off. ------------------------------ Connie Broadie ------------------------------ Re: Audit Log - Add field that identifies which field changedI am not sure I follow. Plz let me provide a little more detail to make sure we are talking apples to apples. Main table is Nonconformances (NCRs). We document any nonconformances to SOPs and need an audit trail of most changes made to the NCR record after creation. I do log edits within some NCR fields, but it isn't feasible with many of the fields. So we created a second table called NCR Audit Log. We made the two tables related; with NCRs having many NCR audit logs. We have 5 fields in the NCR Audit Log, one of which is the related NCR#. The other 4 fields are 'Last modified by', 'Date Last Modified', 'Old Value' and 'New Value'. I set up an automation for 25 NCR fields. Trigger is when that specific field is modified, with action to add a record to the NCR Audit Log. Within the Automation, each of the 4 fields in the NCR audit log are listed copying the values of a specific field before and after the change. Those values could be text, multi-line text, dates, etc. It works very nicely, except it doesn't tell me in the audit log record the name of the field that had the change. With 25 fields, it isn't intuitive to know which field the before and after are showing. It seems I would need another field added to the NCR Audit Log that can somehow capture the name of the field that was changed. I am not sure it is possible. I know I can create an email notification that will show that. I originally thought about saving the e-mail notifications as a PDF and attaching them, along with manually entering the field name, but that defeats the idea of automation. ------------------------------ Connie Broadie ------------------------------ Audit Log - Add field that identifies which field changedI have a table (Audit Log) that logs changes made in another table. They are related. I have an automation set up for each field I want to track changes in. The Audit Log form has Old Value field, New Value field, Date Last Modified and Editor (person making change). My issue is I can't figure out how to identify and include the name of the field (field label) being changed in the Audit Log form. I am grateful for any suggestions! ------------------------------ Connie Broadie ------------------------------