# Lookup value app

**URL:** <https://community.glideapps.com/t/lookup-value-app/16890>\
**Category:** Ask for Help\
**Created:** [October 7, 2020, 7:49pm UTC](https://community.glideapps.com/t/lookup-value-app/16890 "2020-10-07T19:49:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![NorrisealWellmark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/norrisealwellmark/32/7665_2.png) [@NorrisealWellmark](https://community.glideapps.com/u/NorrisealWellmark)\
**Post date:** [October 7, 2020, 7:49pm UTC](https://community.glideapps.com/t/lookup-value-app/16890/1 "2020-10-07T19:49:15Z")

</div>

Hi Glide Experts,  
I would like ask for your guidance on making this app.

I started this app by creating a google sheet with 2 tabs, first tab is to record the user input as usual, and the second tab has 3 columns, “item number”, “Description” and “unit of measure”.  
PN Description UOM  
123 Hat Each  
456 Jeans Dozen  
789 Shirt Each

Base on the user input of “PN” the “description” and “UOM” will pop up on the app

Is there any way I can make this app without having to ask the user to use “Add” button on the top right corner? so in other words, they can only see the input field, and as long as they type 3-digit, the description and UOM will show up down below the 3-digit. they can click on the field again to lookup a second value, and so on so forth.

Thanks for your help in advance,

Didi

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 7, 2020, 11:00pm UTC](https://community.glideapps.com/t/lookup-value-app/16890/2 "2020-10-07T23:00:17Z")

</div>

You can use the built-in search function for this. What did you use the add button for?

---

<div class="post-metadata">

**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 9, 2020, 2:30pm UTC](https://community.glideapps.com/t/lookup-value-app/16890/3 "2020-10-09T14:30:36Z")

</div>

You can also create entry components on the screen that save to user specific columns and then use a relation to get a list of matching items to display in an inline list.

Or you could do something like this.

> [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932):
>
> [[Glide: Filter an Inline List with Choice Components] ](https://www.youtube.com/watch?v=NOYFsVUWQXw) Updated July 2022 
> 
> > **Version 1**
> >
> > \<a href="https://www.youtube.com/watch?v=rtbFccDKuH0"\>https://www.youtube.com/watch?v=rtbFccDKuH0\</a\>

---

<div class="post-metadata">

**Author:** ![NorrisealWellmark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/norrisealwellmark/32/7665_2.png) [@NorrisealWellmark](https://community.glideapps.com/u/NorrisealWellmark)\
**Post date:** [October 12, 2020, 9:14pm UTC](https://community.glideapps.com/t/lookup-value-app/16890/4 "2020-10-12T21:14:27Z")

</div>

Thank you this help!

---

<div class="post-metadata">

**Author:** ![NorrisealWellmark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/norrisealwellmark/32/7665_2.png) [@NorrisealWellmark](https://community.glideapps.com/u/NorrisealWellmark)\
**Post date:** [October 13, 2020, 8:16pm UTC](https://community.glideapps.com/t/lookup-value-app/16890/5 "2020-10-13T20:16:49Z")

</div>

You got straight to the point, and it works! Thanks.
