How to perform Audit Trail for only Field Modified/changed in a Form?

 
1
0
-1

Hi ,

    I was in thought of developing a application which has many forms and each form contains more than 60 fields and i am using Crud operation tool for editing the form and many users will work on that form and now i want to perform audit trail on that form like for example it has a field named as Active which is  a select box having two options Yes and No lets consider myself as User1 and there are other users also named as User2,User3,etc..

Now i need to perform audit trail like when user 1 changed the active status from Yes to No 

i need to list that one in a same or seperate form or grid like User1 changed the Active status from Yes to No

As like the above example i need to perform audit trail for every single field in the form 

I had tried using Form Audit trail Plugin but that one is listing all the fields value in a single cell of a column as json and i was not able to get previous value of a form too.. Kindly help me to sort out this issue


Thanks,

Arun Mano

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      I think that to be efficient, you should save in a different record each time you edit the form, and when displaying the data you must load the one from the last date. This can be accomplished by altering the store and load procedures of the entire form. In the tables (physical of the DB) you will always have access to the id and name of the user who last edited. Do you have the published application or part of it to share it?

      1. Arun Mano Thiruppathi

        But in my case i dont want to save it in a different record i need to edit in a same record and i need to perform audit trail..Is there is any possibility of seperating the fields from json fromat in a audit trail table?

      CommentAdd your comment...
    2.  
      2
      1
      0

      This seems like a classic case of "custom Bean", unfortunately.

      Where you get the values at the Load of the form store them in memory and then at the time of save compare with Loaded value and save into the audit trail table. 

      There is also a possibility to try PreLoad SQL and Postload SQL 

      Finally, some tricks can be played with SubForms but I am not well versed on the subforms. Goodluck.

        CommentAdd your comment...