Enhanced Grid Form Element extends the default functionalities of a typical grid element. Unlike the generic grid element that only accepts standard text field for its inputs, the Enhanced Grid Form Element captures data by making reference to another form element. Hence, one can take full advantage of what a typical form element has to offer, e.g., validation and formatting.
Figure 1: Properties of Enhanced Grid Form Element
Apart from setting up the columns, an external form can also be set to capture more data than what the grid actually shows. One can also define the format on the returned data.
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: [input format]|[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.
Enhanced Grid Form Element in a Form
Adding a new row would bring up the external form and upon submission, the data will be stored accordingly in the background and in the columns, with matching IDs.
Figure 2: Working Example of the Enhanced Grid Form Element
Figure 3: Adding New Entry in the Working Example of the Enhanced Grid Form Element
Limitation: This element may not work well when the referencing form contains Add a Grid, Enhanced Grid Form Element (Form Grid), Subforms and AJAX Sub Form.