Add a MultiSelect Drop Down

By Xelence Documentation posted 07-30-2021 14:43

Introduction

A multiselect drop down is a drop down that allows the user to select multiple values. This gives users an option when more than one value applies in a drop down. For example, a user might want to search for records by Relationship Status. With a multiselect drop down, they can search for all the records with a status of either Married or Divorced.

Prerequisites

The form you need to edit must already exist.
The picklists you are using must already be configured with the values of the list members you want in the framework table. You can edit the framework code table via the application’s Code menu or also from Xelence itself, from the Tools menu.

	Quick Steps
1	Add the control
2	Change the control
3	Edit the drop down properties
4	Move the controls
5	Save the form

Detailed Steps

Step 1. Add the control.

Open the Entity tab and drag the attribute you want to use to the form.

The control has been added.

Step 2. Change the control.

Xelence adds the attribute as a default control type based on the attribute properties. If you want to use a different control type, you'll have to change the type.

In this case, you are changing the control type to MultiSelect drop down.

To change the control type, right click it and select Change Control. You can also change the control by clicking the Change Control icon above the control.

Step 3. Edit the drop down properties, if desired.

The important properties are:

Search Field: Column whose value is linked to the control.
Caption: Text that the user sees.
Query Operator: SQL operator users in the appended where clause. For a multiselect drop down, this is usually "in".

If the PickList value is defined at the entity level, Xelence will use the same value in the form. You can override the value for the form if desired, or set a form value if not already defined.

To configure the multiselect drop down properties, open the Properties tab.