# Dropdown filter option

**URL:** <https://forum.bubble.io/t/dropdown-filter-option/23088>\
**Category:** App Organization\
**Created:** [January 16, 2018, 5:28am UTC](https://forum.bubble.io/t/dropdown-filter-option/23088 "2018-01-16T05:28:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![swvann](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/swvann/32/14747_2.png) [@swvann](https://forum.bubble.io/u/swvann)\
**Post date:** [January 16, 2018, 5:28am UTC](https://forum.bubble.io/t/dropdown-filter-option/23088/1 "2018-01-16T05:28:52Z")

</div>

Hello fellow Bubble Users!

I have a problem that is probably an easy solution, but can’t seem to figure it out. I have a data type called Blends that I want to filter by Type and Abrasive. Currently I have one dropdown that searched the data table “Blends” for “Type”. I want to filter the 2nd dropdown for 'Abrasives" by 'Type". I have a total of 102 different abrasive models, but only 12 types of abrasive.

How can I set a filter on a Dropdown to search by a certain type, selected in a previous dropdown? Right now the 2nd dropdown is showing all 102 different abrasives, but I want to filter it by “type” from the first dropdown. Any assistance would be greatly appreciated!

1st Dropdown

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/6/c/6ce215cf2c83bf24b01492a89609b7be55f1a9df.png)

2nd Dropdown

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/3/a/3a9d1bbb05af008f46fe25244aba98201d7104c1.png)

Data types

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/0/c/0cb38005b1baa2cc04d40be72cb2f2d76c571132.png)

---

<div class="post-metadata">

**Author:** ![seanhoots](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/seanhoots/32/12224_2.png) [@seanhoots](https://forum.bubble.io/u/seanhoots)\
**Post date:** [January 16, 2018, 5:38am UTC](https://forum.bubble.io/t/dropdown-filter-option/23088/2 "2018-01-16T05:38:08Z")

</div>

On the second dropdown use the `:filtered` function on the Choices source and in the filtered contraint call the first dropdown value.  
For example `Search for Blends:filtered` then add the constraint `Type = Abrasive type_input's value`

If no option has been selected in the Abrasive Type option all the abrasives will show. But if a type is selected then only abrasives of that type will be available in that dropdown

---

<div class="post-metadata">

**Author:** ![swvann](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/swvann/32/14747_2.png) [@swvann](https://forum.bubble.io/u/swvann)\
**Post date:** [January 16, 2018, 2:53pm UTC](https://forum.bubble.io/t/dropdown-filter-option/23088/3 "2018-01-16T14:53:50Z")

</div>

@seanhoots thank you!! This is exactly what I need. I appreciate the feedback!

---

<div class="post-metadata">

**Author:** ![gnelson](https://avatars.discourse-cdn.com/v4/letter/g/6bbea6/32.png) [@gnelson](https://forum.bubble.io/u/gnelson)\
**Post date:** [September 16, 2018, 11:45am UTC](https://forum.bubble.io/t/dropdown-filter-option/23088/4 "2018-09-16T11:45:41Z")

</div>

Hi @seanhoots,

Where is this ;Filter function? I don’t see it for my dropdown. I don’t know if this is the right solution to what I’m trying to accomplish anyway. What I’m needing, in my case working with a datatype called subjobs, is to have the dropdown show ONLY SOME of the available subjobs based on several names. I need an OR option when setting it up but I can’t seem to figure it out.

![filter%20function](https://us1.discourse-cdn.com/bubble/original/3X/0/5/055b04f19359f3be19d1148bc855bf0750f96843.png)

---

<div class="post-metadata">

**Author:** ![keith](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/keith/32/56020_2.png) [@keith](https://forum.bubble.io/u/keith)\
**Post date:** [September 16, 2018, 9:54pm UTC](https://forum.bubble.io/t/dropdown-filter-option/23088/5 "2018-09-16T21:54:13Z")

</div>

It’s a LIST type operator. Structure your expression to resolve to a list of any type and you’ll see it.

---

<div class="post-metadata">

**Author:** ![dan8](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/dan8/32/33110_2.png) [@dan8](https://forum.bubble.io/u/dan8)\
**Post date:** [December 13, 2018, 11:50am UTC](https://forum.bubble.io/t/dropdown-filter-option/23088/6 "2018-12-13T11:50:23Z")

</div>

I am trying to do a similar thing but having issues. Screen attached.

FYI, it keeps forcing me to select “Text”. Something about a dropdown needing to display a text value. I personally went to “Device” as that is where the data is stored. Chosing “Text”, I get the first Dropdown to work correctly but trying to filter the second dropdown with the constraint of the option selected in the first is throwing an error.

 ![07](https://us1.discourse-cdn.com/bubble/original/3X/a/f/af390b0a0e82acac0db406ef470ca5e479bf99f1.png)

---

<div class="post-metadata">

**Author:** ![dan8](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/dan8/32/33110_2.png) [@dan8](https://forum.bubble.io/u/dan8)\
**Post date:** [December 13, 2018, 3:22pm UTC](https://forum.bubble.io/t/dropdown-filter-option/23088/8 "2018-12-13T15:22:42Z")

</div>

Resolved: Down to my database architecture. I created a more standard structure and was able to select the correct options.

---

<div class="post-metadata">

**Author:** ![fabian.banushi](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/fabian.banushi/32/135641_2.png) [@fabian.banushi](https://forum.bubble.io/u/fabian.banushi)\
**Post date:** [November 1, 2022, 6:05pm UTC](https://forum.bubble.io/t/dropdown-filter-option/23088/9 "2022-11-01T18:05:46Z")

</div>

Hello Sean

I have the same problem.  
I don’t see the name of the Dropdown when filtering…

Any idea how to select the value of the first dropdown list?

Thanks in advance  
Fabian
