# I think this might be called a LOOKUP?! **URL:** \ **Category:** Ask for Help\ **Created:** [May 24, 2020, 10:33pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702 "2020-05-24T22:33:29Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Robert\_Partridge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_partridge/32/7868_2.png) [@Robert\_Partridge](https://community.glideapps.com/u/Robert_Partridge)\ **Post date:** [May 24, 2020, 10:33pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/1 "2020-05-24T22:33:30Z")
I have 2 sheets: Sheet 1 is a list of product codes & product data, i.e. PC1 / Name / Description / Colour / weight PC2 / Name / Description / Colour / weight Sheet 2 is a list of product codes with their unique serials, from production, i.e. PC1 / 0001 PC1 / 0002 PC1 / 0003 PC2 / 0004 PC2 / 0005 I’m hoping to build a layout where no product data is displayed, only a search bar, where the serials “003” can be entered, and the relevant product data is displayed, then can be saved to the sign-in account. I believe this is possible with Glide, can anyone comment on tools/methods to achieve? Thanks, Rob ---
**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:** [May 24, 2020, 10:50pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/2 "2020-05-24T22:50:15Z")
What do you mean by “saved to the sign in account”? ---
**Author:** ![Robert\_Partridge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_partridge/32/7868_2.png) [@Robert\_Partridge](https://community.glideapps.com/u/Robert_Partridge)\ **Post date:** [May 24, 2020, 11:02pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/3 "2020-05-24T23:02:10Z")
The emphasis is less on the save function, and initially the lookup function. But in the long run, I am hoping to have customers create accounts, search for serials, and save the serial + product data to their account ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [May 24, 2020, 11:15pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/4 "2020-05-24T23:15:48Z")
Have a look at this app (draft++), it should cover your need : [https://3dmeo.glideapp.io/](https://3dmeo.glideapp.io/) You can copy it ---
**Author:** ![Robert\_Partridge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_partridge/32/7868_2.png) [@Robert\_Partridge](https://community.glideapps.com/u/Robert_Partridge)\ **Post date:** [May 24, 2020, 11:23pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/5 "2020-05-24T23:23:16Z")
Thanks Christphe, apologies, I can see I missed off an important feature requirement, in the full release of this desired app, there would be 1000s & 1000s of serials, which I don’t want to display. ![Serials](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8162d9918a7a9f0fcf527badc5fb3d75d811a14b.jpeg) In this shot, can the rows of serial data be hidden / not visible, but when the serial 0003 is entered, it pulls up the product data? ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [May 24, 2020, 11:28pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/6 "2020-05-24T23:28:03Z")
The search bar has to be linked to an inline list displayed in the page, so your use case can’t be implemented like that, you have to display “something” in the screen, and the search will apply to what is displayed… ---
**Author:** ![Robert\_Partridge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_partridge/32/7868_2.png) [@Robert\_Partridge](https://community.glideapps.com/u/Robert_Partridge)\ **Post date:** [May 24, 2020, 11:31pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/7 "2020-05-24T23:31:04Z")
Hmm interesting. I was wondering about writing a VLOOKUP on a blank sheet, and replacing the search bar with the ability for the user to enter the serial, which would trigger the Vlookup and pull the data forward. Is this type of interaction between app & sheets typical? ---
**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:** [May 24, 2020, 11:47pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/8 "2020-05-24T23:47:31Z")
You can use VLOOKUP, FILTER or QUERY for that, depends on your specific use case. The user input goes into a cell in the sheet, then the formula takes care of the rest. However there would be a gap for the data to be shown, which would not be really ideal. ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [May 24, 2020, 11:50pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/9 "2020-05-24T23:50:15Z")
Take a look at the new version of the app. You now have a text entry with which you can search for serials. If founf, you can book the product (and if found, Product data are displayed) The text entry is a user specific column, and using Product and Serials relations and lookup , you can get the product data once the typed serial is found. This is a draft app, you’ll have to add some adjustment if it matches your need (example : once the product is found and booked, do no more display this product data in the search screen, in order to avoid double booking of the same product / serial) ---
**Author:** ![Robert\_Partridge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_partridge/32/7868_2.png) [@Robert\_Partridge](https://community.glideapps.com/u/Robert_Partridge)\ **Post date:** [May 24, 2020, 11:52pm UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/10 "2020-05-24T23:52:37Z")
That looks promising, thanks ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [May 25, 2020, 12:12am UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/11 "2020-05-25T00:12:04Z")
App up to date, the second tab now displays the products / serials owned by the signed in user. ---
**Author:** ![Robert\_Partridge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_partridge/32/7868_2.png) [@Robert\_Partridge](https://community.glideapps.com/u/Robert_Partridge)\ **Post date:** [May 25, 2020, 4:58am UTC](https://community.glideapps.com/t/i-think-this-might-be-called-a-lookup/9702/12 "2020-05-25T04:58:54Z")
Thanks Christophe, that’s certainly cracked a few parts 😃 Any ideas on how to accrue a list of products in the search, for example: search for 0001, finds it, adds to list, search for 0003, find it, adds it list then, “add all serials to owner”?