# Stuck - cannot use Lookup columns in Inline list (video to explain)

**URL:** <https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628>\
**Category:** Ask for Help\
**Created:** [March 1, 2021, 11:45pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628 "2021-03-01T23:45:47Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [March 1, 2021, 11:45pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/1 "2021-03-01T23:45:48Z")

</div>

Argh! I have made a Home Page with an inline list - using View Details and 'independent screen configuration per item" ticked yes. the inline list values come from a simple 2 column thing in my UI sheet (i.e. 'My Cards" and an image, etc)

When I try to edit and design the details for each area, I want to pick the relevant sheet / Glide Table (e.g. to get ‘My Swipes’ I need ‘Swipes’ and then filter by email is signedin user). I can pull in the data! Yippee…

But when I want to display the data nicely, such as a card title and the image, the columns I need to access are not available. In my video you can see that I have a card rel (connecting the swiped card to the Card), and then look=ups to get the Card Title and Card image. I can see them in the sheet… but I cannot select these options for the Inline List.

I also have no Rels I can reference as the initial component in the previous screen, the ‘home’, was merely a UI.

Each of the 4 boxes on the home would point to different areas:

- My Cards = Cards sheet
- My Swipes = swipes sheet
- Chats = chat tab ideally
- Networks = network sheet

I am stuck ☹ so any help would be greatly appreciated! thanks, M

> **[2 March, 2021 - Loom Recording](https://www.loom.com/share/e584844444a44d6c983c4b8cd33bd089)**
>
> Check out a video I made via Loom

---

<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:** [March 1, 2021, 11:55pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/2 "2021-03-01T23:55:29Z")

</div>

Switch it to a single relation and it will work.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 2, 2021, 12:08am UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/3 "2021-03-02T00:08:14Z")

</div>

uncheck “Match multiple” , relation have to have only 1 match for lookup to work 😉

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [March 2, 2021, 12:13am UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/4 "2021-03-02T00:13:37Z")

</div>

Sadly not…

1. in Swipes, if I have Card Rel = 1 match, then the lookups are empty
2. with OR without 1 match or multiple, the Lookup columns still do NOT appear in my inline list as values

☹

Any other routes? Or is this a bug? I hope I am still missing something easy (and I had tried the single - multiple values, having did a search beforehand – but worth repeating the method!)

Thanks, M

 ![Screenshot 2021-03-02 at 01.10.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a1205b3c99eaf4a633b00eefda73b34c2945c559.png) ![Screenshot 2021-03-02 at 01.10.10](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3e92d2dae64b566d39649451e86c4958d3463b65.jpeg) ![Screenshot 2021-03-02 at 01.10.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6769c60bb35765eee590224fc8fafc7558bb7e0.png) ![Screenshot 2021-03-02 at 01.11.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/626f9b353b4f06eb4bc6fd8700c05db85dd30f25.jpeg) ![Screenshot 2021-03-02 at 01.11.05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/538855ee8a7dd2e2717c0ce7b1a085c58f19fd98.jpeg) ![Screenshot 2021-03-02 at 01.11.11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/eaab0c794acd7e41d544aacd30ff62db5f854531.jpeg)

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [March 2, 2021, 12:25am UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/5 "2021-03-02T00:25:17Z")

</div>

I have the same problem in my new Networks area.  
I am using a Glide Table.  
If I use Multiple for a Rel, then values for lookups are populated (but I cannot see them)  
If I use 1 match, then I get no values in the lookups, and I still cannot see anything

 ![Screenshot 2021-03-02 at 01.21.59](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/2/b2552fe49f756de2f7741e888e2516f5e8ea2087.png) ![Screenshot 2021-03-02 at 01.22.15](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a7bf4bcc8bb13a8ffa0bbf64eb9032e419313179.jpeg) ![Screenshot 2021-03-02 at 01.22.25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d0335b1c4eabdf3c97a017d2494e0b023798776.png) ![Screenshot 2021-03-02 at 01.23.19](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d08c6bfc82182102f9cd603b7e5f0d2d7404199.png) ![Screenshot 2021-03-02 at 01.23.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/bea16ceb36f0a557a015e3e25e71688c21282e7d.jpeg)

---

<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:** [March 2, 2021, 12:30am UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/6 "2021-03-02T00:30:17Z")

</div>

It should work. The reason you can’t use a multiple relation is because you could potentially have 1000s of matching rows resulting in a lookup array with 1000s of results. You can’t put an array of multiple values into a title or any other setting that can only hold a single value. If your multiple relation is linking to a single row, then there is no reason that a single relation shouldn’t pull back that same single row.

First set it back to a single relation because it has to be a single relation. Once you do that, refresh the browser to make sure that it recognizes that change. If that still doesn’t work, then I would recreate your lookup columns. It should definitely work.

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [March 2, 2021, 12:34am UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/7 "2021-03-02T00:34:49Z")

</div>

Yes - this worked (and the explanation makes sense too).

I closed down the browser, then deleted the lookups. Then set rel to be 1 match… and when I recreated my lookups they actually worked.

Thanks, @Jeff_Hager !

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 2, 2021, 12:35am UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/8 "2021-03-02T00:35:49Z")

</div>

yes, you are missing understanding how relations works, it looks for values in columns that matches values in parent column. If lookup is not bringing back a value, that mean there is no value for that request, or browser did not registered yet… you need to refresh if data is being feed from google sheets it takes time or action for Glide to refresh. also Gsheets when open doesn’t work fast… so there is a double accumulation delay in communication between Glide and Google

---

<div class="post-metadata">

**Author:** ![michaelofficial](https://avatars.discourse-cdn.com/v4/letter/m/7ea924/32.png) [@michaelofficial](https://community.glideapps.com/u/michaelofficial)\
**Post date:** [April 24, 2023, 8:39pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/9 "2023-04-24T20:39:35Z")

</div>

Similar question to above.

I read through the thread and understand that the rel column cannot allow for multiple matches.

My issue is that I when trying to serve up data from a lookup column within a component (any type), it shows the data in the table as well as in the data preview in the right hand side when selecting which column to use in that component… But then when I select that column, nothing is served up within the component so the component just disappears.

This only happens with some of my lookup columns and I’ve rigorously gone through ones that worked and compared with ones that don’t and don’t see anything different. I mean, there’s not that many steps involved…

Data is in Glide Tables and I’ve given this a lot of time so I know it’s not a latency issue.

Could there be any other cause beyond a lookups’ relation value allowing for multiple matches?

I really appreciate any information.

Best,  
Michael

---

<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:** [April 24, 2023, 8:59pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/10 "2023-04-24T20:59:31Z")

</div>

Do you use Row Owners in any of the tables that the Lookup column would be pulling from?

---

<div class="post-metadata">

**Author:** ![michaelofficial](https://avatars.discourse-cdn.com/v4/letter/m/7ea924/32.png) [@michaelofficial](https://community.glideapps.com/u/michaelofficial)\
**Post date:** [April 24, 2023, 9:25pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/11 "2023-04-24T21:25:13Z")

</div>

Thanks for the reply here.

I do not…

---

<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:** [April 24, 2023, 11:43pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/12 "2023-04-24T23:43:34Z")

</div>

So you don’t have row owners in any related tables? Can you show us some screenshots or a video of how you’re setting it up?

---

<div class="post-metadata">

**Author:** ![michaelofficial](https://avatars.discourse-cdn.com/v4/letter/m/7ea924/32.png) [@michaelofficial](https://community.glideapps.com/u/michaelofficial)\
**Post date:** [April 26, 2023, 6:55pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/13 "2023-04-26T18:55:22Z")

</div>

I do not. Should I be?

Okay, here are some screenshots showing how the lookup and relation columns are built, as well as how it’s acting in the front end component:

 ![Screenshot 2023-04-26 at 11.42.02 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/698e94f66ace6d6180cccdc75a02c7fa118ec7dd.jpeg)

 ![Screenshot 2023-04-26 at 11.50.19 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/2133b77da380cbce40ae5c585c583802d3ffe7b9.png)

^ This is how the relation table is set up. The ‘Host\_email’ is a direct input on a different table filled via form and works as expected.

 ![Screenshot 2023-04-26 at 11.37.28 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd5eaed1602d106aaaa59dae314058b92e6d835a.png)

^This is the column in the table with the lookup: the lookup is working as expected pulling in the Host Phone based on the Host email rel.

 ![Screenshot 2023-04-26 at 11.37.56 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d661569d00c11815410b3b5bf4559c53034c7cab.png)

^This is in the front end where you choose a column to tie to a component: you can see the lookup feeds through properly here as well.

However:

 ![Screenshot 2023-04-26 at 11.38.10 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6fd8a211c9baa214ab9a7f2ac6c5357a9c6d25c1.png)  
The component (regardless of type) remains empty in the front end and therefore does not get served…

I hope this helped a bit… Again, thank you so much for always being such a valuable resource.

Best,  
Michael

---

<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:** [April 26, 2023, 11:27pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/14 "2023-04-26T23:27:17Z")

</div>

![Screenshot 2023-04-26 at 11.37.28 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd5eaed1602d106aaaa59dae314058b92e6d835a.png)

You show the “Host Phone” column here.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/9482555fbf9bebd1e4414ff72a5cb4cb65ef5256.jpeg)

But here you are showing the “Artist Phone” column. Is “Host Phone” not empty on that specific row, since I don’t see it in the dropdown.

---

<div class="post-metadata">

**Author:** ![michaelofficial](https://avatars.discourse-cdn.com/v4/letter/m/7ea924/32.png) [@michaelofficial](https://community.glideapps.com/u/michaelofficial)\
**Post date:** [April 27, 2023, 12:21am UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/15 "2023-04-27T00:21:44Z")

</div>

Nice eye! Here’s the right screen shot. Same problem though:

 ![Screenshot 2023-04-26 at 5.19.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/86845d3413ae6f42b6a1dd3a385fdc34f84df08a.png)  
^host phone at the bottom

---

<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:** [April 27, 2023, 12:22am UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/16 "2023-04-27T00:22:45Z")

</div>

That’s weird. Do you mind inviting me or one of the experts here to your team so we can look more into this problem?

---

<div class="post-metadata">

**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:49pm UTC](https://community.glideapps.com/t/stuck-cannot-use-lookup-columns-in-inline-list-video-to-explain/23628/17 "2024-01-17T16:49:08Z")

</div>


