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 Data Store set as the Store Data Store and Load Data Store.
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 | ... |