Introduction
Form Data Options allows for rows to be retrieved from an existing Form Data to be used as options.
Form Data Options Properties
| Name | Description |
|---|---|
| Form | Source form to load records from |
| ID Column | Field ID from source form to set as the option value. (Default: id) |
| Label Column | Field ID from source form to set as option label. (e.g. name) |
| Grouping Column | Field ID from source form to set as option grouping value. |
| Extra Filter Condition | Filter conditions in HQL to refine the selections. |
| Add Empty Option | If checked, an empty option will be added to the selections. |
| Empty Option Label | Empty option label. Only in use when Add Empty Option is checked. |
| Use AJAX for cascade options? | When checked, this allows these fields to dynamically load available options based on the other field value (grouping column) when dealing with a tremendous amount of selections. Read more at Ajax Cascading Drop-Down List. |
Form Options Caching
| Name | Description |
|---|---|
| Sync Cache Interval | How often to activate cache synchronization (in seconds). For example, when set to 180 seconds, background synchronization in the server will take place every 180 seconds to refresh with the new/latest data. |
| Pause sync after idle | How long to wait to pause synchronization after idle. |
Tip
This may be used in conjunction with User Options Binder to return all the users into a dropdown selection. If the user records are large (in the tens of thousands), it is recommended to set "Pause sync after idle" to a larger value and the sync will continue to update the cache in the background. If the dropdown selections are unlikely to change in a very short interval, it is recommended to set the "Sync Cache Interval" to a larger value too so that the server does not perform a new cache again in a short span of time.
Related 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