Fill Drop Down With Query

Fill Drop Down With Query is an action used in the Rule Panel to dynamically populate one or more dropdown fields in a form based on the results of a query or formula. This action is triggered by an event, such as a button click or a change in a field value.

When executed, the action:

• Evaluates the provided query/formula to fetch data.

• Maps the results to dropdown items (with name and id).

• Populates the specified dropdown, multi-select, or table-select fields with the fetched options.

Properties

Here are the steps to follow in order to use the Fill Drop Down With Query action:

1

Field Name

Specifies the target dropdown field(s) to be populated. You must select one or more field names (Element IDs) corresponding to dropdown, multi-select, or table-select elements in your form. Multiple fields can be selected to populate several dropdowns at once.

2

Query

This property defines the dynamic or static query that will be executed to fetch the dropdown options. The query can be a plain SQL statement, a formula, or any expression supported by the Formula Editor. The result of this query determines the items that will appear in the dropdown(s). The Query utilizes the Formula Editor. See how the Formula Editor works.

Example

Below is a screenshot of the Fill Drop Down With Query action configuration, showing all properties set for the Query and Field Name:

• In this example, the dropdown element(s) are selected by their Element IDs.

• When an event (like a button click) occurs, the "Fill Drop Down With Query" action executes the specified query and updates the dropdown(s) with the resulting options dynamically.