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