| Table of Contents |
|---|
Introduction
Form Store Binder Audit Trail would allow to store data that have been modified as audit trail data.
...
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.
...
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 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.
Demo App Download
| View file | ||||
|---|---|---|---|---|
|