Creating an Audit Trail in a Form

compared with
Current by Howard Treisman
on Mar 23, 2009 15:50.

Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (9)

View page history
Although LC Workflow automatically stores information in the database about each step that is performed, it is often more useful to embed this information directly into the form, in an "audit trail" or "history" table, where anyone who opens the form can see its history.
 
For example, a customer might need to be contacted in future using a temporary phone number while he or she is abroad. Little items of information like this are essential to the seamless customer experience workflow always promises. So how would we record these additional pieces of information into the form?
A real process would be much longer than this however for purposes of expediency we stop there.

h3. The Process
Below we see a toy-example form containing an address block, a Name\|Date\|Comment table and a text block for entering new comments. We can use the Avoka TaskHistory Solution Component to pick up any new comments being entered into the New Comment text field. TaskHistory can be configured to find out who made the comment and enter that, along with the time the comment was made, into our table. This allows our collaborators to better understand any important facts about this specific case, keeping the flow of work smooth.
 
Below we see a toy-example form containing an address block, a Name|Date|Comment table and a text block for entering new comments. We can use the Avoka TaskHistory Solution Component to pick up any new comments being entered into the New Comment text field. TaskHistory can be configured to find out who made the comment and enter that, along with the time the comment was made, into our table. This allows our collaborators to better understand any important facts about this specific case, keeping the flow of work smooth.
To begin the new employee process the supervisor fills in details about the new employee such as first name, last name, and the password the new employee wants to have.

!Form1.jpg!
The above form shows that the process creator (Tony Blue) has made an informal comment about the essential skills and abilities of the new employee (Susan Friend).

!Process3.jpg!
The first step (Lookup Creator) is used to lookup the first and last name of the process creator.
 
The second step (Record Comments of Process Creator) is then used to update the table in the form with the comment made by the process creator, and the name of the comment author and when the comment was made.

The results of this update to the form are visible when the user task (Create Employee Email Account) gets executed, as shown in the below screen-shot.
!Form3.jpg!
 
An archive file containing the process, forms, and component resources can be downloaded from [here|Creating an Audit Trail in a Form^New Employee-29-10-2007-1550.lca]. NOTE: to run the process add a task manager endpoint to this process.