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. | Name | Description |
|---|
| Value | Field ID of the target form. Example: In "Account" form sourced in the Data List "Account Listing", there are Form Elements with the ID "id", and "accountName". | | Label | Column Label. | | Editable | Yes/No | | Format Type | If you would like to format the returned value, you may make use of the format type. Default choice: Text. Available Format Types - Text - formats the value as text
- HTML - outputs data as HTML
- Date - formats as date. Original Date and New Date formats are expected in the "Format" field.
Format: [KB:input format]|[KB:output format]
Example of usage:
Original value: 5/23/2012
Expected value: 2012/5/23
Format: M/d/y|y/M/d
Note: Please refer to Java SimpleDateFormat for date format. - Decimal - formats as decimal. Number of decimals is expected in the "Format" field.
- File - Show the value as a link to the attachment. Form Def id is expected in the "Format" field.
- Image - Show the value as a thumbnail of the attachment. Form Def id is expected in the "Format" field.
| | Format | Depending on your chosen Format Type, additional argument may be entered here. | | Width | Column width in characters. |
|
Figure 5: List Grid Properties - UI
...
| Name | Description |
|---|
URL Request Parameters for Datalist | |