A Decision Table is an advanced form of a ListCombo; it uses data from an Excel list as values in a combo field. Decision Tables differ from ListCombos in that they also use business logic in determining which values to display.

For instance, you may have a list of different managers that are associated with different departments in your company. With a Decision Table, you can have a user select a department and the ListCombo values will display only managers associated with the selected department.

To create a decision table, we must format our fieldLabel's of our list slightly differently.

We will preface the name of a field that will filter values of another field with "In_". (e.g. - In_department, In_amount) and preface the the name of the field being filtered with "Out_" (e.g. - Out_role, Out_email).

If we are creating a decision table that will filter managers based on a selected department, our decision table might look something like this:

With this naming convention, the role, field name and email are defined as outputs of what is input in the department field in the example above.

Import your list to use it in a ListCombo (see How to Format and Import a List).

In the App Builder, Add a new field with a Type of "Listcombo". Select the List you're using as your decision table.

Select a list field as a Search_column. The data in this column will be what is displayed to the user.

Select a list field as a Value column. The data in this column will be what is stored by the app. In this case, the managers' email.

Select a list field as a in_department. The data in this column will filter the values of the field.

Select an app field as the Filter by field. Similar to a regular combo, this will link the ListCombo field with the field you want its values to filter by.

Your ListCombo field values will now be filtered depending on the value selected in the "Department" field.