# Dropdown List Manual Selection in Addition to Scroll!

**URL:** <https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [January 5, 2022, 8:41pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700 "2022-01-05T20:41:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\
**Post date:** [January 5, 2022, 8:41pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700/1 "2022-01-05T20:41:41Z")

</div>

I have a droplist list whose data source is an SQL table (1 column.) My question is how to give the user the option to start typing in the dropdown list to select the item directly and still have the ability to scroll thru the items in the list? Is there any example that you can refer me to?

 ![2022-01-05_15-37-02](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/f/7fb369d0d0e9d99260428a6a95434dee54998eb6.jpeg)

---

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [January 6, 2022, 2:35pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700/2 "2022-01-06T14:35:03Z")

</div>

I’m not sure if you can directly type in the dropdown, but one solution could be to modify your query to accept a parameter and use SQL “LIKE”.  
Allow the user to type what they’re looking for in an input field above the dropdown and use that as your parameter to filter the dropdown menu.

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [January 6, 2022, 3:10pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700/3 "2022-01-06T15:10:09Z")

</div>

There is one on the exchange, Lookup Table Dynamic Dropdown for Vision,

> **[Ignition Exchange](https://inductiveautomation.com/exchange/2003/overview)**
>
> Discover, share, and download community made Ignition resources in collaboration with your organization or the Ignition community.

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [January 6, 2022, 3:13pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700/4 "2022-01-06T15:13:50Z")

</div>

This may be a good time to make your own template and use @amarks logic of using a `"WHERE someColumn LIKE 'enteredText%'` to populate a list or tiny table beneath a text input component. If this is a functionality you want all over application consider making it generic so that it could easily be used in other tables. Perhaps the name of the namedQuery which utilizes the LIKE where clause is a parameter for instance.

But in terms of built-ins, I don’t think vision has a component that does this out of the box.

---

<div class="post-metadata">

**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\
**Post date:** [January 6, 2022, 3:23pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700/5 "2022-01-06T15:23:47Z")

</div>

Thank you guys - You are awesome. I appreciate your help.

---

<div class="post-metadata">

**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\
**Post date:** [January 6, 2022, 3:24pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700/6 "2022-01-06T15:24:05Z")

</div>

Thank you!