...
Introduction
| English |
|---|
The List Grid is best described similar to a Form Grid, but with the capability to add new records from a Datalist instead. The Advanced Grid is only available on Professional and Enterprise Edition. |
Get Started
The easiest way to see how the List Grid works is to create a new app. Here are the steps:
...
| Name | Description |
|---|
| ID | Element ID (By declaring as "account", a corresponding database table column "c_account" will be created) Please see Form Element for more information about defining the ID and list of reserved IDs. |
| Label | Element Label to be displayed to the end-user. |
| Datalist | Datalist 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 the "Account" form sourced in the Datalist "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
- Multiple lines text - maintains the spacing formatting for multiple lines text, such as TextArea.
- Decimal - formats as a decimal. The number of decimals is expected in the "Format" field.
Date - formats as a date. Original Date and New Date formats are expected in the "Format" field. | Panel |
|---|
| borderColor | blue |
|---|
| borderWidth | 1 |
|---|
| titleBGColor | #ddffcc |
|---|
| borderStyle | solid |
|---|
| Format: (original format)|(new 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. |
File - Show the value as a link to the attachment. Form Def ID is expected in the "Format" field. | Info |
|---|
| title | Expected Form Def ID |
|---|
| Specify the Form Def ID that contains the actual File Upload form element. |
Image - Show the value as a thumbnail of the attachment. Form Def ID is expected in the "Format" field. | Info |
|---|
| title | Expected Form Def ID |
|---|
| Specify the Form Def ID that contains the actual Image Upload / File Upload form element. |
Options - Show the label of a multiple-choice element given the value given. Form Def ID is expected in the "Format" field. | Info |
|---|
| title | Expected Form Def ID |
|---|
| Specify the Form Def ID that contains the actual Select Box / Radio / CheckBox form element. |
| | Format | Depending on your chosen Format Type, an additional argument may be entered here. | | Width | Column width in characters. |
|
UI
Sorting
| Name | Description |
|---|
| Enable Sorting Feature | Determines if the 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. |
...
| Name | Description |
|---|
URL Request Parameters for Datalist | Refine the target Data List selections by defining the filter criteria here. | Name | Description |
|---|
| Parameter | Target Data List filter parameter name | | Field ID | Current form element field ID | | Default Value | Default Value for the search parameter |
|
Download Demo App