Fill Drop Down with Query Action

Functionality

Fill drop down with query will let you set the options of the dropdown with query. Query should be returning the options of the dropdown. This rule can be triggered with any event or condition.

Steps

When using the editor to fill drop down the query, follow these steps:

1

Field Name:

Select the dropdown in which you intend to fill options.

2

Query:

write the query which must be returning name and id from any table in your database.the action with your element ID from the available options.

3

Play Button:

Click the play button to check the results of the query in the result field.

By following these steps you will be able to successfully fill the drop down with query.

For Example

Let's say you want to create a drop-down menu that displays the names of all the available users from the database. To populate the drop-down menu with the query result, you can use the SQL query "Select name from t_user" in the query field and the drop-down name in the “Field Name” field in the editor and trigger it on any event/condition. Here the action is triggered on button click event.