Thu, 24 Sep 2026
Login

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

Confluence User - 19 Jun, 2020

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

forms;datalists;userviews;server

3

Confluence User •
19 Jun, 2020 •
confluenceUser •
•
confluenceUser •

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.

Confluence User •
22 Jun, 2020 •
confluenceUser •
•
confluenceUser •

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?

Confluence User •
22 Jun, 2020 •
confluenceUser •
•
confluenceUser •

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?

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
i am building an app, and for some reason i am not able to open it anymore. All apps --> my app --> system error
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print