| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Advanced Grid is best described as a Grid with rich inline editing transformation. Depending on the target field, the Advanced Grid element would mimic the original target type for accurate and richer data entry capability. |
| Info | ||
|---|---|---|
| ||
Newly introduced in Joget Workflow v5 |
Figure 1: Screenshot highlighting Advanced Grid in Form Builder
...
A Date Picker will show up when editing as if the source field itself is a date picker element.
Figure 4: Screenshot highlighting Advanced Grid on Select Box element in Form Builder
A Select Box will show up when editing as if the source field itself is a select box element.
Figure 5: Advanced Grid Properties
| Name | Description | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | Element ID (By declaring as "entries", a corresponding database table column "c_entries" will be created) | |||||||||||||
| Label | Element Label to be displayed to end user. | |||||||||||||
| Form | Target form for record editing. | |||||||||||||
| Columns | The columns defined here must be correspondent to the Form chosen above.
|
Figure 6: Advanced Grid Properties - UI
| Name | Description |
|---|---|
| Search | Enable search capability within the grid data itself. |
| Readonly | Determines if the element is editable. |
| Disable Add Feature | Determines if a new row can be added. |
| Disable Delete Feature | Determines if a row can be removed. |
| Delete confirmation message | Confirmation message when deleting a row. |
| Show Row Numbering? | Shows numbering on the grid. |
| Key to save cell | Keyboard key to use to determine when to save and move on to the next cell. |
| Edit hint | Edit hint message. |
| Record Per Page | Paging Parameter - Record to show per Page |
| Paging Options | Paging Parameter - Paging Options |
Figure 7: Advanced Grid Properties - Validation & Data Binder
| Name | Description | |||||
|---|---|---|---|---|---|---|
| Validator | Attach a Validator plugin to validate the input value.
| |||||
| Unique Column | Column/Field ID to identify record ID. | |||||
Min Number of Row Validation (Integer) | Min Number of Row Validation (Integer) | |||||
Max Number of Row Validation (Integer) | Max Number of Row Validation (Integer) | |||||
Error Message | Error message to be shown when row requirements set above is not met. | |||||
Load Binder | Option by default. Grid data will be saved/loaded in JSON format in its defined database cell. In this example, Multirow Form Binder is used to load data from other form. See list of available Form Binder. | |||||
Store Binder | Option by default. Grid data will be saved/loaded in JSON format in its defined database cell. In this example, Multirow Form Binder is used to load data from other form. See list of available Form Binder. |