# 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:** 17\ **Page:** 2
**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:56pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/22 "2019-10-10T13:56:05Z")
Will this work if it’s pulling the text from a search box instead of a set word. Like say: =FILTER(J3:J, ARRAYFORMULA(REGEXMATCH(J3:J, “._km._”))) Where J3:J is a list of issues to search through Can I replace the “._km._” with “._"&H2&"._” Where H2 will be the text in the Search box. And would this formula pull all items in the J3:J that contain the searched text into a choice option in my App that has the column with the formula set as the available choices I essentially want a user to be able to Search a term that term would pull the items of the issues list that have that term in it and will build a choices menu that has just those items with that term as opposed to the 1,000+ list of issue options ---
**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, 2:16pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/23 "2019-10-10T14:16:32Z")
=FILTER($D2:D,REGEXMATCH($D2:$D,H2)) Yay!!! This works $D2:$D column to search and H2 term to search for. It imports all rows with H2 in it anywhere. Now to test it in the app lol ---
**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, 2:59pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/24 "2019-10-10T14:59:41Z")
So yeah need this to function so when they type in the Search term before hitting add it can pull from the correct column. Is there a way to program say a button that pulls the formula or… A way to get it to add the Search Result into the Google Sheet without hitting the check Mark to add the whole thing. Kind of like an Add/Edit with the functions of the Edits immediate posting ---
**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, 3:06pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/25 "2019-10-10T15:06:32Z")
@Jeff_Hager Can you add a button that allows a custom formula to be put in it or allow it to choose a formula from the Google Sheet ---
**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, 3:47pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/26 "2019-10-10T15:47:59Z")
Or maybe a special value that allows us to set a formula that runs automatically when says a text box detects text Writing a Google script would be simple lol but I dont see a way to add scripts to the apps 😛 ---
**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, 4:11pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/27 "2019-10-10T16:11:12Z")
@Christopher_Breen To include a script in your spreadsheet is as simple as writing the script function and in the cell just put =YourScriptFunction() in the cell. ---
**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, 5:45pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/28 "2019-10-10T17:45:23Z")
I don’t think you can add scripts into an app itself. I don’t think setting a formula from within the app would work either, as google may only see it as text instead of a formula. The only option I can think of while in Add/Edit mode would be to use a Form Button to submit your search term to a new sheet. Then use a formula to pull the last submitted search term into the cell that you are using to filter your choice list. I would think this would update the Choice component while your are still in the Add/Edit mode, but may take a few seconds to update. It wouldn’t be a very smooth process, but may be something to try. ---
**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, 6:10pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/29 "2019-10-10T18:10:51Z")
Lol that I know but I want to incorporate the script in my 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 10, 2019, 7:44pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/30 "2019-10-10T19:44:59Z")
I’m not following really well, but are you asking if the populated results could somehow be part of an added row? Like for example: 1. User searches a term 2. Search term populates results 3. User adds a new item 4. Search results are also added to their new item ---
**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, 8:03pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/31 "2019-10-10T20:03:22Z")
Id like to create a way where if I am adding a ticket when I click the Issues box to set it to a specific issue i don’t want to have to scroll through hundreds of options I want to be able to search that Choices option for an item to select ---
**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, 8:23pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/32 "2019-10-10T20:23:17Z")
Nevermind doesn’t work. I need to be able to allow multiple users to search the list simultaneously which means I’ll have to wait for Glide to program a search function into its app building process ---
**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\ **Post date:** [October 10, 2019, 8:36pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/33 "2019-10-10T20:36:56Z")
Yeah I was trying to steal some ideas here for my list problem,… and it sounds promising until you add multiple users at the same time,… since the source sheet results will change with each user. ---
**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 11, 2019, 8:24am UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/34 "2019-10-11T08:24:51Z")
Maybe you could filter the search screen by user, and add a form button like Jeff suggested. Then maybe use Glide’s filter option to filter out old searches? Idk. I added an array formula to the filter formula, so that rows could be added & still filter results. ---
**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 11, 2019, 11:32am UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/35 "2019-10-11T11:32:36Z")
I’m trying to see if there’s a way to get a live search that filters as you type to work in my glide app. I’ll update as I go ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [October 30, 2019, 12:54pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/36 "2019-10-30T12:54:20Z")
Great and smart solution! I’d rather use Query() function to look for the results rather than Filter(), I think Query() is more powerful and flexible but it is a matter of taste. Feliz día, saludos! ---
**Author:** ![Doomba](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/doomba/32/1133_2.png) [@Doomba](https://community.glideapps.com/u/Doomba)\ **Post date:** [October 30, 2019, 1:07pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/37 "2019-10-30T13:07:58Z")
Wow, this is so cool! I’m going to use this in my app. 🤩 ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [March 17, 2020, 8:43pm UTC](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980/38 "2020-03-17T20:43:04Z")
> [@Search in Choice Now Available](https://community.glideapps.com/t/search-in-choice-now-available/5495): > > If your Choice has more than 10 options, you will now get a search entry: [Previous page](https://community.glideapps.com/t/can-i-search-the-menu-opened-by-the-choice-component/980.md?page=1)