# Can I search the menu opened by the Choice component? **URL:** \ **Category:** Feature Requests\ **Created:** [October 7, 2019, 8:12pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980 "2019-10-07T20:12:46Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 7, 2019, 8:12pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/1 "2019-10-07T20:12:46Z")
Is it possible to put a search function to search a. Choices box option. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 7, 2019, 8:16pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/2 "2019-10-07T20:16:53Z")
Not possible now but it has been asked for in a few Feature Request posts. It may be on the list of enhancements, but I don’t know that for a fact. ---
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 7, 2019, 8:29pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/3 "2019-10-07T20:29:41Z")
I wonder if i create a search function in my sheets and add it to the choice list will it let me use it to search the list ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 7, 2019, 8:53pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/5 "2019-10-07T20:53:14Z")
I think @George_B meant to link this post maybe: [Filter Product from Code](https://community.glideapps.com/t/filter-product-from-code/940) Here’s the sample sheet I shared with him: See FILTER example in the first tab, cell B2. Enter search term in A2! [https://docs.google.com/spreadsheets/d/1D3IKIxhBMENPRX9mPfUnzPjlHri2t4pMKCbH-fF633Q](https://docs.google.com/spreadsheets/d/1D3IKIxhBMENPRX9mPfUnzPjlHri2t4pMKCbH-fF633Q) ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 8, 2019, 12:45am UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/6 "2019-10-08T00:45:40Z")
Yes, I did post the wrong one. I’ll delete it so as not to confuse others. Thanks Megann. ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [October 9, 2019, 6:32pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/7 "2019-10-09T18:32:04Z")
@MegannLock How would you use this filter in the app? ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 9, 2019, 7:38pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/8 "2019-10-09T19:38:04Z")
A quick example in this app (likely has some errors/typos), but you’ll get the idea: [https://ivq8d.glideapp.io](https://ivq8d.glideapp.io) ---
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 10, 2019, 12:54am UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/9 "2019-10-10T00:54:15Z")
Can you provide the way the Google Sheet is setup? When i open the app you shared the search function doesn’t work. ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 10, 2019, 2:46am UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/10 "2019-10-10T02:46:34Z")
It’s the one linked above! ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 10, 2019, 2:47am UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/11 "2019-10-10T02:47:27Z")
Oops forgot to add edit permissions on there. My bad! ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [October 10, 2019, 5:28am UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/12 "2019-10-10T05:28:45Z")
Still not working. It’s like your screen is on freeze ---
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 10, 2019, 12:51pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/13 "2019-10-10T12:51:46Z")
This search filter is amazing. Is there a way to add a ‘if search result contains this “”’ to pull a list of items into the column so it can be used as a choices menu ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 10, 2019, 1:07pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/14 "2019-10-10T13:07:35Z")
Do you mean you’d like users to be able to choose from a list? Yielding one results or multiples? ---
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 10, 2019, 1:22pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/15 "2019-10-10T13:22:28Z")
So basically my app is set up so you would select an issue, cause its a tech support ticket tracker. I want to, if I search for something - say “Applications” the populated field will pull all results with the word Applications in it in a Column which will be “current search results” The app will use the Choices option so that that column of current search results can change the listed items to whatever the search results are. Not a single choice but all choices that have the searched content ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 10, 2019, 1:23pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/16 "2019-10-10T13:23:56Z")
That might work if using editable components in detail view since changes are posted back to the spreadsheet immediately. Add/Edit mode require the submit button before anything is posted back to the spreadsheet. ---
**Author:** ![Christopher\_Breen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_breen/32/649_2.png) [@Christopher\_Breen](https://community.glideapps.com/u/Christopher_Breen)\ **Post date:** [October 10, 2019, 1:24pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/17 "2019-10-10T13:24:07Z")
Much like “if search column of issues contains X text import all items from searchable list with X text in it” kind of like an import range but based on the queried text. Does that make sense? ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 10, 2019, 1:31pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/18 "2019-10-10T13:31:03Z")
Just to clarify, the users would select a category? Or would the search term be manually entered? If they’re picking from choices, this is ideal. You can add columns to your data tab that would match those search terms, then use a filter, query, or regex formula. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 10, 2019, 1:32pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/19 "2019-10-10T13:32:02Z")
Also might be able to use regular expressions in the filter to handle multiple results instead of an exact match. > ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [October 10, 2019, 1:40pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/20 "2019-10-10T13:40:13Z")
Yes!! Regex would work well here! ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 10, 2019, 1:51pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/21 "2019-10-10T13:51:27Z")
Just an FYI I tried to use FIND and it DIDN’T work: ```auto =iferror(FILTER('Data to Search'!A:D, FIND(A2,'Data to Search'!B:B) > -1,"No Results")) ``` [Next page](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980.md?page=2)