Permitted Values Demo (User Inferface Options)

AdapTable follows a series of steps when it wants to provide a list of values for a column (e.g. in a column filter, or when building a query or in Bulk Update).

It will first look for any Permitted Values for that column, set via the permittedValues property in UserInterface Options - where you can provide either a list or a function.

Here we set 4 Permitted Values:

  • A 'hard-coded' set of Values for Contact and Employee columns - so only this list of values is displayed in their Column Filters (and Expression Editor).
  • For Cust Ref. column a function that will be evaluated each time the list is required; this allows you to get the values from your local store or via an external look-up.
  • An empty array [' '] for the Order Date Column so that NO distinct column values are diplayed, and only the System Filters for Date columns are shown.

Note: if there are no Permitted Values provided, then AdapTable will dynamically build a list of current distinct values for the column.

AdapTable Help Resources:

Generating dummy data, please wait ...