Form ID

Table Name

leaveApplication

leave_application

leaveDetails

leave_details

Relationship: One leave application has multiple leave details.

Parent Form: leaveApplication

Child Form: leaveDetails

Configuring the Grid

Storing Data

By default, data will be stored in JSON format in the parent table.

Storing in Separate Table

Data can be stored using the Multirow Form Binder set as the Store Binder and Load Binder.

In the selected table, one must create a field to keep the parent ID.

Note: Every "value" in the Grid properties must match their corresponding fields in the selected table.

Each child record must have a unique ID as the primary key.

Table: leave_application

id

name

....

1550

David

....

Table: leave_details

id

leave_application_id

...

800

1550

....

801

1550

...

802

1550

...

  • No labels