Hi Pushpakumar,
It is possible to use an automation or action to help you to track field changes and edits. This can be done by setting up an Action to copy over data from your existing table and have it create a new record for each edit in an Audit table. For example if I wanted to audit my projects table for every time a status is changed and I wanted to capture the changed status, the former status, the user who edited it, and when.
I would create a Project Status Audit table with a field for Status after edit, Status before edit, user who edited, date of edit, Project Name, and Record ID. Then I would create an Action on the table I wish to audit from and set it to fire whenever a Project is added or modified and the Project Status changes. Then I select the option to Add a record and select my new Audit table. From there I can choose to write over values from one field to another, and make use of the option to write the old value from the Status field to the Status before edit field and then the value after edit to the Status after edit field. This will give me a nice audit record to track my changes. Then I could set it up to capture the Date Modified and Last Modified By fields into my user and date field I created.
The key is just to have a place to copy over your data and build the action to fire off the field you are capturing. I hope this information is helpful Pushpakumar.
