I'm trying to track edits / modifications by user, for multiple fields in a form or record. I cant seem to figure out how to create a basic audit log. That gives me a simple historic view of changes to a record. I need to show the user who made a change and what fields were changed on that record with date & time stamp at the minimum. It also needs to allow simple reporting.
Our basic app layout
Customer Table (Primary) - Support Task Table (Child)
Customer Form (Cust Record) - Support Task Form (Task Record)
Each customer record is assigned an Account Manager (User)
Task records share a related field with customers for Account Manager to show whos assigned to that account.
Support Task Records have a 2nd assigned agent, Fulfillment Assistant (User) not present in the customer table.
Looking for something like the below per record. Similar to the last modified by but logging the complete trail and specific fields changed , suggestions?
Task # 123456
(Field Name) Modified by John Doe 3/6/2018 11:18 AM (PST)
(Field Name) Modified by Christian Stamper 3/7/2018 9:10 AM (PST)
(Field Name) Modified by Christian Stamper 3/7/2018 9:18 AM (PST)