# Drop Down Filter

**URL:** <https://forums.knack.com/t/drop-down-filter/12055>\
**Category:** Get Answers\
**Created:** [February 16, 2022, 7:49am UTC](https://forums.knack.com/t/drop-down-filter/12055 "2022-02-16T07:49:03Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![TamerAltah86075](https://avatars.discourse-cdn.com/v4/letter/t/b38774/32.png) [@TamerAltah86075](https://forums.knack.com/u/TamerAltah86075)\
**Post date:** [February 16, 2022, 7:49am UTC](https://forums.knack.com/t/drop-down-filter/12055/1 "2022-02-16T07:49:03Z")

</div>

Is anyone able to achieve the below-categorized filter dropdown?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/b/b967f78a713372b970fe4fb19b90022d419a3773.jpeg)

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [February 16, 2022, 5:47pm UTC](https://forums.knack.com/t/drop-down-filter/12055/2 "2022-02-16T17:47:33Z")

</div>

I’m not clear what you are trying to achieve, could you provide more information please.

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [February 16, 2022, 6:22pm UTC](https://forums.knack.com/t/drop-down-filter/12055/3 "2022-02-16T18:22:47Z")

</div>

Hey,

Can you check it in the below link.

[https://roberts.knack.com/farmers#dropdown/](https://roberts.knack.com/farmers#dropdown/)

for this, I just create a view with rich text and add that dropdown there …  
when we change dropdown value then i add selected value in textbox .

Regards,  
Sunny Singla

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [February 16, 2022, 8:34pm UTC](https://forums.knack.com/t/drop-down-filter/12055/4 "2022-02-16T20:34:58Z")

</div>

Hey @Sunny_Singla - I hope you are keeping well.  
Now that I’ve seen your example I understand the original requirement.  
I like the solution 👍  
Are you using any code to achieve this?  
If not, could you explain in more detail as this an interesting drop down solution.

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [February 17, 2022, 3:01am UTC](https://forums.knack.com/t/drop-down-filter/12055/5 "2022-02-17T03:01:23Z")

</div>

Hello Carl,

I’m well, hope you are good as well.

Yes, it’s a customization solution. For this, i created a rich-text area above the view and add this category dropdown html .

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/f/ffa227d0356023046a820690b355578a41086d33.png)  
also we can create this opt group using javascript as well from any table dynamically

Regards,  
Sunny Singla

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [February 17, 2022, 7:28am UTC](https://forums.knack.com/t/drop-down-filter/12055/6 "2022-02-17T07:28:29Z")

</div>

Thanks @Sunny_Singla - I thought this must be using custom code to achieve the desired result.  
Good to know this type of option can be built if required. 👍

---

<div class="post-metadata">

**Author:** ![TamerAltah86075](https://avatars.discourse-cdn.com/v4/letter/t/b38774/32.png) [@TamerAltah86075](https://forums.knack.com/u/TamerAltah86075)\
**Post date:** [February 25, 2022, 10:45am UTC](https://forums.knack.com/t/drop-down-filter/12055/7 "2022-02-25T10:45:13Z")

</div>

Thanks for your support.

---

<div class="post-metadata">

**Author:** ![Pablo1](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@Pablo1](https://forums.knack.com/u/Pablo1)\
**Post date:** [February 25, 2022, 3:39pm UTC](https://forums.knack.com/t/drop-down-filter/12055/8 "2022-02-25T15:39:21Z")

</div>

Hi, Thanks Sunny.

Great solution,  
but How do you add selected value in textbox?

Rgds, Pablo

Pablo Marzoratti  
[pablo@garlantech.com](mailto:pablo@garlantech.com)

> ![](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/45/1007_2.png "Sunny\_Singla") | [Sunny\_Singla](https://forums.knack.com/u/sunny_singla) Knack Expert  
> February 17 |
> 
> - | - |

Hello Carl,

I’m well, hope you are good as well.

Yes, it’s a customization solution. For this, i created a rich-text area above the view and add this category dropdown html .

also we can create this opt group using javascript as well from any table dynamically

Regards,  
Sunny Singla

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [February 25, 2022, 3:56pm UTC](https://forums.knack.com/t/drop-down-filter/12055/9 "2022-02-25T15:56:48Z")

</div>

Hello Pablo,

just 2 line javascript used to put value in the textbox  
$("#selectName").live(“change”, function () {  
$("#field\_168").val($(this).val());

});  
selectName-\> dropdown id  
field\_168-\> textbox id

Regards,  
Sunny Singla  
[ssingla1985@gmail.com](mailto:ssingla1985@gmail.com)

> **[Database consultant – Software database consultant](http://sandt-consultancyservices.com)**
>
> Knack Database consultant

---

<div class="post-metadata">

**Author:** ![Pablo1](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@Pablo1](https://forums.knack.com/u/Pablo1)\
**Post date:** [February 26, 2022, 12:07am UTC](https://forums.knack.com/t/drop-down-filter/12055/10 "2022-02-26T00:07:13Z")

</div>

Many thanks Sunny

---

<div class="post-metadata">

**Author:** ![Duncan](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/duncan/32/2308_2.png) [@Duncan](https://forums.knack.com/u/Duncan)\
**Post date:** [January 14, 2023, 11:47am UTC](https://forums.knack.com/t/drop-down-filter/12055/11 "2023-01-14T11:47:28Z")

</div>

Hello Sunny,

I’ve made the HTML Dropdown which you kindly showed us how to do, but how do I make that become a Search Filter for my database, as in how do I create the search/reset button to use the dropdown selection please.

I’m totally new to this, so please forgive me, but what I need to be able to do is allow searches from dropdown menus rather than users having to type in everything. I intend to have a few of these to enable searches from different fields (which I’m aware will only work individually), unless you know of a way to select multiple criteria and then hit the search to find all records meeting the multiple criteria.

Kind regards,

Dunkie  
Data Breaches Digest
