...
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.
...
| 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.
...
| 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.
...