I have come across a requirement where we need to maintain a table where all the edit information needs to be shown. The requirement is as follows:
When someone edits anything in a Request form (has 9 inputs fields which can be edited), a new “Edit Log” read-only table should appear.
Columns in the Table should include:
Input Field Name that was changed
Initial Input Data (Data provided when creating a request first time)
Input Data that was provided during the edit (Current)
Date and Time of Edit
Name of the Editor
Status of the Request at the time of the Edit (Can be Pending, Approved, etc.)
It should look something similar to this:
Your open inputs are invited for handling this in database (how can we maintain this log in DB) and showing in Sail UI.
Thanks in advance
Discussion posts and replies are publicly visible
Have you looked at this https://community.appian.com/b/appmarket/posts/audit-history-application as a possible solution? How often will these fields be edited? If the customer is only looking for an audit type capability, the process instances provide a nice way of seeing who changed what and when. We've used Process Models as a nice way to tracking who changed what and when. Depending on how quickly you are archiving your process models, you could build a process report to display that data before it is archived. If there are ever any questions after an instance is archived, process instances could be un-archived.
bryant.st39 Thanks Bryant. Will definitely look into that.