Multirow Form Binder with Condition and Ordering

Introduction

The Multirow Form Binder with Condition and Ordering extends the standard Multiple Form Row binder by allowing child records to be selectively loaded based on configurable conditions. It also supports loading records in ascending or descending order using a specified ordering field. Multiple filter conditions can be combined to create more complex filtering logic.

Plugin Info

Plugins Available In The Bundle

• Multirow Form Binder with Condition and Ordering

This plugin is compatible with Joget DX 9.

Get Started

Where To Get The Plugin

You can download this plugin from the latest Releases.

How To Install

1. Click Download on the plugin page (the downloaded file will be a .jar file).
2. In Joget, navigate to Admin Bar → System Settings → Manage Plugins.
3. Click Upload Plugin.
4. Select the downloaded .jar file and click Upload.
5. The binder will now be available under Load Data From Save Data From in Form Grid / Form Row elements.

How To Use It

1. Open your parent form in Form Builder.

2. Add a Form Grid (or other supported multi-row element for eg: spreadsheed, list grid etc).

3. In Data & Validation section--> Data Store--> Load Data From, select Multirow Form Binder with Condition and Ordering.

4. Configure the binder properties:

• Form – Select the child form.
• Foreign Key – Select the child form field that stores the parent record ID.
• Order – Select the field used for sorting.
• Order By – Select Ascending or Descending.
• Extra Filter Condition (Optional) – Configure one or more conditions to selectively load child records.

5 Under Save Data To, select Multiple Form Row and configure:

• Form – Select the same child form.
• Foreign Key – Select the same child form field used in the load binder.

6. Save and publish the application.

Configure Multirow Form Binder with Condition and Ordering

Fields to Configure

Form: Select the child form that stores the multi-row records.

Foreign Key: Select the field in the child form that stores the parent record ID. This field is used to associate child records with their corresponding parent record.

Order: Select the child form field used to sort the loaded child records.

Order By: Determines the sorting direction for the loaded child records.

• Ascending – Loads records in ascending order based on the selected Order field.

• Descending – Loads records in descending order based on the selected Order field.

Retain Existing Data When Storing: Determines whether existing child records matching the configured conditions are retained when the parent form is saved.

• Enabled – Existing matching child records are retained.

• Disabled – Existing matching child records that are no longer present in the submitted Form Grid are deleted.

Extra Filter Condition: Defines one or more conditions used to selectively load child records.

Each condition consists of the following fields:

• Join Type – Specifies how multiple conditions are combined (for example, AND or OR).

• Field ID – The child form field used for filtering.

• Operator – The comparison operator used to evaluate the field (for example, =, !=, <, >, or LIKE).

• Value – The value used for comparison.

Multiple conditions can be combined to create more complex filtering logic.

Other Data Handling: 

1. Handling for Field Workflow Variable?

Determines whether workflow variable values are processed when storing and loading multi-row data.

• Enabled – Workflow variable fields are handled during data storage and retrieval, allowing values to be synchronized with workflow variables where applicable.
• Disabled – Workflow variable fields are ignored by the binder during data handling.

2. Handling for Uploaded Files?

Determines whether uploaded files contained in the child form should be processed by the binder.

• Enabled – Uploaded files are handled during data storage and retrieval. Enabling this option also displays the Form to Store Uploaded Files property, allowing you to specify the form used to store uploaded files.
• Disabled – Uploaded files are not processed by the binder, and the Form to Store Uploaded Files property is hidden.

Expected Outcome

After configuring the Multirow Form Binder with Condition and Ordering, child records are loaded according to the configured foreign key, optional filter conditions, and ordering settings.

How to Test It

1. Navigate to the Parent Form that contains the Form Grid configured with the Multirow Form Binder with Condition and Ordering. Create a new parent record.

2. In the Form Grid, add the following child records. Save the parent record. Reopen the saved record.

Items	Priority
Pen	3
Pencil	1
Notebook	2

 

Example 1 – Descending Order

Configure the binder as follows:

• Order: Priority
• Order By: Descending

Expected Result

The child records are displayed in descending order of the Priority field.

 

Example 2 – Ascending Order

Configure the binder as follows:

• Order: Priority
• Order By: Ascending

Expected Result

The child records are displayed in ascending order of the Priority field.