Audit Log - Add field that identifies which field changed

I 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
------------------------------