Form Data Options

Form Data Options allow you to retrieve rows from an existing form data source and use them as selectable options in your form fields.

Configure form data

Configuring Form Data Options involves specifying the source form, setting up the necessary columns for option values, labels, and grouping, and defining any extra filter conditions to refine the selections.

Configure the following fields:

• Form: Specify the source form from which to load records.
• ID Column: Field ID from the source form to set as the option value. (Default: id)
• Label Column: Field ID from the source form to set as the option label. (e.g., name)
• Grouping Column: Field ID from the source form to set as the option grouping value.
• Extra Filter Condition: Filter conditions in HQL (Hibernate Query Language) to refine the selections.
• Add Empty Option: If checked, an empty option will be added to the selections.
• Empty Option Label: Label for the empty option.
  This is only applicable when the Add Empty Option is checked.
• Use AJAX for Cascade Options?: Enable to dynamically load available options based on the grouping column when dealing with many selections. For more information, see Ajax Cascading Drop-Down List.

Form options caching

Caching options allow you to manage how often the form data options are refreshed, which can significantly improve performance in environments with large datasets. 

Configure the following fields:

• Sync Cache Interval: Duration in seconds for cache synchronization activation.
  For example, with a setting of 180 seconds, background synchronization on the server occurs every 180 seconds to update with the latest data.
• Pause Sync after Idle: Duration to wait before pausing synchronization after idle.

Video tutorials

How to use form data options?

In Previous Joget Versions, Form Data Options was called Default Form Options Binder.

How to design dynamic forms that change on user input