List Grid is best described as a Form Grid but with the capability to add in new records from a Data List.
Figure 1: Screenshot highlighting List Grid in Form Builder
...
Figure 4: List Grid Properties
| Name | Description | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | Element ID (By declaring as "account", a corresponding database table column "c_account" will be created) | |||||||||||||||||||
| Label | Element Label to be displayed to end user. | |||||||||||||||||||
| Data List | ||||||||||||||||||||
| Columns | ||||||||||||||||||||
| Data List to display for selection. | ||||||||||||||||||||
| Columns | The columns defined here must be correspondent to the Data List chosen above.
|
Figure 5: List Grid Properties - UI
| Name | Description | |||||
|---|---|---|---|---|---|---|
| Enable Sorting Feature | Determines if ordering of rows is to be enforced. | |||||
Field ID for Sorting | Field to keep the ordering sequence; must correspond with a field id in the target form. | |||||
Insert Button Label | Insert Button Label | |||||
Form to Edit Row | After addition of row, user may edit the record row by opening it in the Form defined here. | |||||
Form Submit Button Label (Normal Mode) | Label of the Submit button in normal mode. | |||||
Form Submit Button Label (Readonly Mode) | Label of the Submit button in read-only mode. | |||||
Display field as Label when readonly? | ||||||
| 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? | Show additional column on the leftmost to denote numbering. | |||||
Popup Dialog Height | Height in character
| |||||
Popup Dialog Width | Width in character
|
Figure 6: List 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. | |||||
Store Binder | Option by default. Grid data will be saved/loaded in JSON format in its defined database cell. |
Figure 7: List Grid Properties - Advanced
| Name | Description |
|---|---|
URL Request Parameters for Datalist |
...
Refine the target Data List selections by defining the filter criteria here.
|