Options Formatter

The Options Formatter allows you to transform values in a list column into their corresponding option values and labels, enhancing the data display for end users.

Configure options

To add this Formatter, go to the element's properties under Formatter and choose Options in the Formatter field.

When adding Options, you will see the following fields available for configuration:

• Options: Define a set of options to be matched against the column value. The column value will be matched against the value, and the corresponding label will be displayed.
• Or Load Data From: Populate options dynamically using the Options Data Store plugin.
  Configuring any options Data Store here will override the values set in the Options property.
  Available Options Data Stores:

• • Bean Shell Options Data Store
  • Database SQL Query Options
  • Database Wizard Options Data Store
  • Department Options
  • Form Data Options
  • Grade Options
  • Group Options
  • JSON API Options
  • Multiple Form Row
  • Organization Options
  • User Options

These data stores allow for a flexible and dynamic population of options, making it easier to manage large data sets and ensure that the list displays accurate and up-to-date information.