Joget DX Beta Available for Download

Check out Joget DX, the next generation successor to Joget Workflow for faster, simpler digital transformation.

Versions Compared

Key

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

Multirow Form Binder gives you the ability to save multirow data such as grid data into its designated table.

In the example below, one can make use of this binder in the Enhanced Grid Form Element (Form Grid) element to store items for the Application Form.

Image Added
Figure 1: Application Form (Table name: applications)

In figure 1, apart from the normal input fields, there's a Form Grid element will makes reference to the Item Form as depicted below.

Image Added
Figure 2: Item Form (Table name: application_items)

In figure 2, one will need to add additional (hidden) field as the foreign key (parent_id) to the Application Form.

Image Added
Figure 3: Configuring Form Grid

As required by the Form Grid set up, one will need to match the columns with the referencing table.

Image Added
Figure 4: Configuring Load and Store 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 binder. Then, choose Item form and map the foreign key to parent_id  as required.