Introduction
Form Store Binder Audit Trail would allow to store data that have been modified as audit trail data.
Plugin Info
Plugin Available in the Bundle:
Workflow Form Binder with Audit Trail
This plugin bundle is compatible with Joget DX 8.
Expected Outcome
Data modified will be stored as an audit trail data.
Figure 1: Expected Outcome
Getting Started
Prerequisites
1. Form Store Binder Audit Trail Plugin
Download the plugin at Joget Marketplace. Source code of the plugin: https://github.com/jogetoss/form-store-binder-audit-trail.
2. JSON to Table Formatter Plugin
Download the plugin at Joget Marketplace. Source code of the plugin: https://github.com/jogetoss/JSON-to-Table-Formatter.
Setting up Workflow Form Binder with Audit Trail
Before setting up the plugin. We need to create two forms two input data and store the data.
Example form to input data named Contract:
Figure 2: Example Input Form
Example form to store data named Trail:
Figure 3: Example Sore Data Form
After creating the form. Click on Generate App > Generate Crud for both forms.
Next, go to Contract Form > Settings > Advanced > Data > Save Data To and choose Workflow Form Binder with Audit Trail.
Figure 4: Workflow Form Binder with Audit Trail Configuration
| Name | Description |
|---|---|
| Save Data To(Workflow Form Binder with Audit Trail) | |
| Textual Data Field | Tampered values will be stored in this field as texts. |
| Copy Parent Field Value to Audit Trail Field | |
| Current Form | The parent/main form. |
| From | The form field value wanted to be copied into the audit trail form. |
| To | The form field to store the copied value. |
| Foreign Key | The form field to store parent form ID |
| Tracks Everything | Click the checkbox if you want to track any tampering of the data |
| Other Data Handling | |
| Handling for Field Workflow Variable? | Click the checkbox so the plugin will update workflow variable based on form field. Not applicable to grid elements. |
| Handling for Uploaded Files? | Click the checkbox if you are using file or image attachments in your form elements. It will store uploaded files to .wflow\app_formuploads based on form properties table name. |
Setting up JSON to Table Formatter
Go to List - Trail and click column History(JSON). Set the formatter to JSON to Table Formatter.
Figure 5: List Column Formatter Setup
Figure 6: Field Mappings
| Field Mappings | |||
|---|---|---|---|
| Name | Description | ||
| Attribute Name | Name for each attributes. | ||
| Column Label | The name of each column in the table. | ||
| Column Inline Style | Column inline styling in CSS. | ||
| Hide Column | Click the checkbox to hide the column in runtime. | ||
| Show Unmapped Fields | Click the checkbox to show unmapped fields. | ||
Runtime
In runtime, click on the Manage Contract > New which is the main form and fill in the new details.
Figure 7: Add New Data
After saving, you can click on the arrow beside the Name value and the Trail data list will drop down. Though there will be no value since there are no changes made yet in the data.
Figure 8: View Trail Data list
Edit the data and change value or add new value into the current one. Save the form.
Figure 9: Change/Add Value into the Current Value
View the Trail Data list again and you can see all the changes made in the data.
Figure 10: View Changes in Trail Data List
Source Code and Plugin Download
- Please visit https://github.com/jogetoss/form-store-binder-audit-trail. for the plugin's source code.
- You can find the latest release at https://github.com/jogetoss/form-store-binder-audit-trail/releases .
- Upload the plugin to your Joget by navigating to Settings > Manage Plugins > Upload Plugin as admin.
