# Form Designer: How to filter a drop-down list

**URL:** <https://discuss.workflowgen.com/t/form-designer-how-to-filter-a-drop-down-list/273>\
**Category:** Form Designer\
**Created:** [July 30, 2014, 8:33pm UTC](https://discuss.workflowgen.com/t/form-designer-how-to-filter-a-drop-down-list/273 "2014-07-30T20:33:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![wfg-admin](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/wfg-admin/32/714_2.png) [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)\
**Post date:** [July 30, 2014, 8:33pm UTC](https://discuss.workflowgen.com/t/form-designer-how-to-filter-a-drop-down-list/273/1 "2014-07-30T20:33:03Z")

</div>

In this example, we’ll filter the country list by a text.

1. Add a text tool with the Id `FILTER`.

2. Add a drop-down list with the Id `COUNTRY`.

3. Edit this drop-down list and bind it to a data source or a global list.

4. In the **Filter** section, select the column to filter.

5. Select the comparison operator (`Equal`, `Not Equal`, `Greater than`, etc.).

6. Select the `REQUEST_FILTER` field.

The list is now filtered according to the text entered in the filter.

 ![](https://quip.com/blob/AUPAAALXe04/vYrivXlifi3cNmIpnkcL2w?s=NiLIAPs5UWet)​

---

<div class="post-metadata">

**Author:** ![r.tobasi](https://avatars.discourse-cdn.com/v4/letter/r/a587f6/32.png) [@r.tobasi](https://discuss.workflowgen.com/u/r.tobasi)\
**Post date:** [March 26, 2018, 6:54pm UTC](https://discuss.workflowgen.com/t/form-designer-how-to-filter-a-drop-down-list/273/2 "2018-03-26T18:54:39Z")

</div>

HI  
I want to ask about how to filter a drop-down list based on values of two request fields

Best Regards  
Rami Tobasi

---

<div class="post-metadata">

**Author:** ![eddy.daouk](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/eddy.daouk/32/672_2.png) [@eddy.daouk](https://discuss.workflowgen.com/u/eddy.daouk)\
**Post date:** [March 26, 2018, 7:02pm UTC](https://discuss.workflowgen.com/t/form-designer-how-to-filter-a-drop-down-list/273/3 "2018-03-26T19:02:19Z")

</div>

Hi Rami,

The Form Designer can only support one filter.

Here is how you can achieve what you need using code behind:

> [@How to configure a data source with a parameter based on a form field value from code-behind](https://discuss.workflowgen.com/t/how-to-configure-a-data-source-with-a-parameter-based-on-a-form-field-value-from-code-behind/291):
>
> The sample process below shows how to configure a custom SQL datasource to populate a drop-down list. The SQL datasource has a parameter named ID\_DIR in the SQL command WHERE clause. This parameter receives the selected value of the form’s REQUEST\_DIRECTORIES drop-down list. It is possible to add multiple parameters to the same SQL command in this way. string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MainDbSource"].ToString(); string providerName = Sys…

Best Regards,  
Eddy.

---

<div class="post-metadata">

**Author:** ![r.tobasi](https://avatars.discourse-cdn.com/v4/letter/r/a587f6/32.png) [@r.tobasi](https://discuss.workflowgen.com/u/r.tobasi)\
**Post date:** [March 26, 2018, 7:14pm UTC](https://discuss.workflowgen.com/t/form-designer-how-to-filter-a-drop-down-list/273/4 "2018-03-26T19:14:35Z")

</div>

Dear eddy,  
Thank you for your quick reply

🙂

Best Regards  
Rami Tobasi