# Displaying Lookup column's values in the layout

**URL:** <https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629>\
**Category:** Ask for Help\
**Created:** [February 7, 2023, 9:11pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629 "2023-02-07T21:11:01Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vaoyim74](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vaoyim74](https://community.glideapps.com/u/Vaoyim74)\
**Post date:** [February 7, 2023, 9:11pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629/1 "2023-02-07T21:11:02Z")

</div>

I have a lookup column filled with values that I would like to display in the layout. However, when I’m in the component’s configuration menu, I cannot select the lookup column in order to have it display the values it contains in a list.

The relation and lookup columns do not appear as a possible choice for the data source, therefore, I can’t select them…

How do I display them in the layout in a list format along with the rest of the row’s information?

Thanks for the help!

---

<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:** [February 7, 2023, 9:17pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629/3 "2023-02-07T21:17:47Z")

</div>

How are you trying to display it? Do you have screenshots of what you have and what you want to see?

Long story short, you can’t display an array of multiple values in something that only accepts a single value.

But, there are several options depending on how you want it to look visually.

- Change your relation to a single relation, so the lookup only returns a single value.
- Use a Joined List column instead of a lookup to return multiple values as a single delimited list (single value instead of array)
- Display your multiple relation as an online list.

There’s a few other ways too, but it really depends on what you want the end result to look like.

---

<div class="post-metadata">

**Author:** ![Vaoyim74](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vaoyim74](https://community.glideapps.com/u/Vaoyim74)\
**Post date:** [February 7, 2023, 9:22pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629/4 "2023-02-07T21:22:45Z")

</div>

Hey Jeff, thanks for the reply.

So’im trying to display it in a data grid. Here a the screenshots from my tab, my layout, and the component’s configuration drop-down menu. As you can see, even though I have the proper columns, they don’t appear in the drop-down menu…

 ![Capture1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f2b0772916d29ba79db8bc4506df6700234f41f0.png)

---

<div class="post-metadata">

**Author:** ![Vaoyim74](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vaoyim74](https://community.glideapps.com/u/Vaoyim74)\
**Post date:** [February 7, 2023, 9:23pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629/5 "2023-02-07T21:23:16Z")

</div>

![Capture2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e84877a61fabfb39640f5cfac56f01501ad5cfae.png)

---

<div class="post-metadata">

**Author:** ![Vaoyim74](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vaoyim74](https://community.glideapps.com/u/Vaoyim74)\
**Post date:** [February 7, 2023, 9:24pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629/6 "2023-02-07T21:24:12Z")

</div>

![Capture3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d102e04a808405c534631462246c19a861f9c9d5.png)

---

<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:** [February 7, 2023, 10:04pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629/7 "2023-02-07T22:04:10Z")

</div>

OK. Have you tried either changing your relation to a single relation, or add a Joined List column instead of a Lookup column?

---

<div class="post-metadata">

**Author:** ![Vaoyim74](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vaoyim74](https://community.glideapps.com/u/Vaoyim74)\
**Post date:** [February 7, 2023, 10:15pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629/8 "2023-02-07T22:15:54Z")

</div>

The Joined List worked great, thank you very much for your help 🙂

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 8, 2023, 10:16pm UTC](https://community.glideapps.com/t/displaying-lookup-columns-values-in-the-layout/57629/9 "2023-02-08T22:16:14Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
