# Lookup Values in Basic Table **URL:** \ **Category:** Ask for Help\ **Created:** [May 27, 2021, 11:45am UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300 "2021-05-27T11:45:25Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![JAIN\_PROPERTY\_BANGAL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jain_property_bangal/32/26924_2.png) [@JAIN\_PROPERTY\_BANGAL](https://community.glideapps.com/u/JAIN_PROPERTY_BANGAL)\ **Post date:** [May 27, 2021, 11:45am UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/1 "2021-05-27T11:45:25Z")
I have created an app where it can record payment received against a product in instalments. So I have 2 sheets: 1. One with product information 2. To record the payments with amount & date Then I’m using a relation between 2 sheets and using a lookup to get the payments received & date of payment against each product, so it gives me an array column for multiple results. **I want to display this in a table when I open any product’s detail page in the app.** **Can someone guide me with this?** P.S. Screenshot attached ![Screenshot 2021-05-27 at 5.14.39 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56440dd94ead35bbb4423967cbdb9117a0876778.png) Thanks in advance… ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 29, 2021, 1:54am UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/2 "2021-05-29T01:54:53Z")
Hey @JAIN_PROPERTY_BANGAL You cannot display Lookup values once you’re picking those values from a multiple relation It worked only it is single - with ✅ Multiple option not checked in the relation ---
**Author:** ![JAIN\_PROPERTY\_BANGAL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jain_property_bangal/32/26924_2.png) [@JAIN\_PROPERTY\_BANGAL](https://community.glideapps.com/u/JAIN_PROPERTY_BANGAL)\ **Post date:** [May 29, 2021, 6:28am UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/3 "2021-05-29T06:28:19Z")
Hey Lucas! Thanks for the reply… Would you suggest any other workaround? ---
**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 29, 2021, 8:47am UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/4 "2021-05-29T08:47:11Z")
If you want to actually display the values rather than the relation, the only way is to pull them back using a joined text column. ---
**Author:** ![Fred\_Marker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fred_marker/32/27977_2.png) [@Fred\_Marker](https://community.glideapps.com/u/Fred_Marker)\ **Post date:** [May 29, 2021, 7:40pm UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/5 "2021-05-29T19:40:28Z")
Hey @JAIN_PROPERTY_BANGAL If you simply want to display the payments made with date, take a look at this > [@Data editor not supporting markdown tables](https://community.glideapps.com/t/data-editor-not-supporting-markdown-tables/16356/10): > > Not sure if this is what you are talking about, but this is what I have in my app. It’s an html table, because I needed the ability to span the width 100%, change the font size, and get the layout I want. I’ve been unable to get close to this with markdown, although the process I explain below would work for markdown as well. If you are familiar with html tables, then you will see that what I am doing, is I have a lessons sheet where I dynamically build each \ table row for each … ---
**Author:** ![JAIN\_PROPERTY\_BANGAL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jain_property_bangal/32/26924_2.png) [@JAIN\_PROPERTY\_BANGAL](https://community.glideapps.com/u/JAIN_PROPERTY_BANGAL)\ **Post date:** [May 30, 2021, 8:58am UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/6 "2021-05-30T08:58:38Z")
I want to display the multiple values against a particular transaction. ---
**Author:** ![JAIN\_PROPERTY\_BANGAL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jain_property_bangal/32/26924_2.png) [@JAIN\_PROPERTY\_BANGAL](https://community.glideapps.com/u/JAIN_PROPERTY_BANGAL)\ **Post date:** [May 30, 2021, 8:59am UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/7 "2021-05-30T08:59:24Z")
Woah! This looks great.I’ll try this out ---
**Author:** ![JAIN\_PROPERTY\_BANGAL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jain_property_bangal/32/26924_2.png) [@JAIN\_PROPERTY\_BANGAL](https://community.glideapps.com/u/JAIN_PROPERTY_BANGAL)\ **Post date:** [June 5, 2021, 5:20am UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/8 "2021-06-05T05:20:44Z")
I tried a workaround and it works smoothly. So, I have a sheet where the entries of payments (“Payments Sheet”) are stored and one sheet where the products (“Products Sheet”) are stored. Step 1: Use Template column (naming it as “Combined”) to format into the following type “Amt - Date” replace “amt” with the amount replace “date” with the payment date Step 2: Create a relation in products sheets which relates the “product name” from products sheet to “product name” in payments sheet. Step 3: Use lookup column (naming it as “Get Payments”) in products sheet to lookup “Combined” from payments sheet Step 4: Set up a new column with joined list component (naming it as “display payments”) and refer it to the “Get Payments” column replace “,” as a separator with “new line” (by pressing enter) Voila! It’s done, you’re all set to go. Now you can make any entry to the payments sheet and it will immediately be added to the display. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/lookup-values-in-basic-table/27300/9 "2024-01-17T16:51:52Z")