Versions Compared

Old Version 4

changes.mady.by.user Gerryn Goh Jo-Vee

Saved on

compared with

New Version 5

changes.mady.by.user Gerryn Goh Jo-Vee

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Advanced Grid Properties

Edit Advanced Grid

Image RemovedImage Added

NameDescription
Label

Element Label to be displayed to the end-user.

ID

Element ID. (By declaring as "entries", a corresponding database table column "c_entries" will be created)

Please see Form Element for more information about defining the ID and list of reserved IDs.

LabelElement Label to be displayed to the end-user.
FormTarget form for record editing.
Columns

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

NameDescription
Field ID

ID of the target form.

Info
iconfalse
titleExample

In "Expense Claim Entry" form, there are Form Elements with the ID "date", "category", "purpose", and "formattedAmount"

LabelColumn Label.
Format Type

If you would like to format the returned value, you may make use of the format type.

Available Format Types

  • Date - formats the field as date.
  • Decimal - formats the field as decimal.
Width (px)

Column width in characters.

Code Block
titleSample
200px
Readonly

Determines if the column is editable.

...

NameDescription
Validator

Attach a Validator plugin to validate the input value. Please see Form Validator.

Info
titleWhen will validation takes place?

Validation will take place whenever a form is submitted except when it is submitted as "Save as Draft".

Unique ColumnColumn/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.


Data Binder

NameDescription
Load Data From
& Save Data To

Load Data From allows you to customize the method for data retrieval to populate the advance grid in the form.

Save Data To

Save Data To allows you to customize the method on how the advance grid row records are saved to.

This option is empty by default. An empty binder means that the advance grid records will be saved/loaded as a JSON format in the parent form & database table. See the list of available Form Binders.

The recommended binder to use is the Multirow Form Binder so that each record is saved into a child database table via a subform definition. The binder will update the foreign key "parent id" into each child record to point to the parent database table

.

.