Form Options Binder is used on form element such as Select Box to dynamically populate its selections.

Available Options Binders

Form Options Caching

Joget v6.0.9 has a new feature to enhance the performance of Form Options Binder via a new caching option for large data set. You can see the following new field after selecting any "Options Binder" option:

NameDescription
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 new/latest data.

Pause sync after idle

How long to wait to pause synchronization after idle.

For example, this may be used in conjunction with User Option Binder to return all the users into a dropdown selection. If the users' records are large (in the ten of thousands), it is recommended to set the "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 short span of time.