Joget DX Available for Download
Check out Joget DX, the next generation successor to Joget Workflow for faster, simpler digital transformation.
Multirow Form Binder gives you the ability to save multirow data such as (i.e., grid data) into its designated table.
In the example below, one can make use of this binder in the in Enhanced Grid Form Element (Form Grid) element to to store items for the Application Form.
Figure 1: Application Form (Table nameName: applications)
In figure Figure 1, apart from the normal input fields, there's a Form Grid element will that makes reference to the to Item Form (as depicted shown below).
Figure 2: Item Form (Table nameName: application_items)
In figure Figure 2, one will need to add an additional (hidden) field as the foreign key (parent_id) to the Application Form.
As required by the Form Grid set upsetup, one will need to match the columns with the referencing table.
Figure 4: Configuring Load and Store binder using Binder Using Multirow Form Binder
And finally, to make sure that the grid data is saved into the application_items table, select Multirow Form Binder as the both store and load binderbinders. Then, choose Item form and map the foreign key to parent_id as required.