You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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

Modified the form in http://localhost:8080/jw/web/console/app/crm/1/form/builder/crm_contact

Figure 2: Screenshot highlighting adding new records using List Grid in Form

Figure 3: Screenshot highlighting new records added in List Grid in Form

Figure 4: List Grid Properties

NameDescription
IDElement ID (By declaring as "account", a corresponding database table column "c_account" will be created)
LabelElement Label to be displayed to end user.
Data ListData List to display for selection.
Columns

The columns defined here must be correspondent to the Data List chosen above.

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

LabelColumn Label.
EditableYes/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.
FormatDepending on your chosen Format Type, additional argument may be entered here.
Width

Column width in characters.

Sample
200px

Figure 5: List Grid Properties - UI

NameDescription
Enable Sorting Feature 
Field ID for Sorting
 
Insert Button Label
 
Form to Edit Row
 
Form Submit Button Label (Normal Mode)
 
Form Submit Button Label (Readonly Mode)
 
Display field as Label when readonly?
 
Readonly 
Disable Add Feature
 
Disable Delete Feature
 
Delete confirmation message
 
Show Row Numbering?
 
Popup Dialog Height
 
Popup Dialog Width
 

Figure 6: List Grid Properties - Validation & Data Binder

NameDescription
Validator 
Unique Column 
Min Number of Row Validation (Integer)
 
Max Number of Row Validation (Integer)
 
Error Message
 
Load Binder
 
Store Binder
 

NameDescription
URL Request Parameters for Datalist
 
  • No labels