# How do I get another column value by using Lookup?

**URL:** <https://community.glideapps.com/t/how-do-i-get-another-column-value-by-using-lookup/38257>\
**Category:** Ask for Help\
**Created:** [February 8, 2022, 3:26pm UTC](https://community.glideapps.com/t/how-do-i-get-another-column-value-by-using-lookup/38257 "2022-02-08T15:26:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [February 8, 2022, 3:26pm UTC](https://community.glideapps.com/t/how-do-i-get-another-column-value-by-using-lookup/38257/1 "2022-02-08T15:26:07Z")

</div>

Or, at least I think I need to use Lookup column. Here is my current app: I want to show user friend’s story

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

In the User Friend table below, I already add link to picture from Users table

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/129273812cb5c9e2863f4d620bdababa30302753.jpeg)

But I can’t show them in Inline List. Was expecting to have below image field showing Picture column. But can’t see this.

What I am doing wrong here?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/454a1e5ce19bff90bf58d9bfb97ddb0a4304bcf3.png)

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 8, 2022, 3:52pm UTC](https://community.glideapps.com/t/how-do-i-get-another-column-value-by-using-lookup/38257/2 "2022-02-08T15:52:53Z")

</div>

Is your relating single or multiple? You can only pull lookup values through a single relation.

---

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [February 8, 2022, 4:14pm UTC](https://community.glideapps.com/t/how-do-i-get-another-column-value-by-using-lookup/38257/3 "2022-02-08T16:14:29Z")

</div>

I think it is single… but let me rewatch glideapp video about it.

---

<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 8, 2022, 5:18pm UTC](https://community.glideapps.com/t/how-do-i-get-another-column-value-by-using-lookup/38257/4 "2022-02-08T17:18:17Z")

</div>

Your Email Friend column needs to be used to create a single relation to whichever table contains the full user profile. Then a lookup column to retrieve that user image. Maybe that’s what you are doing, but I can’t tell from the screenshots. Looks like your relation column is empty, so I’m not sure how you have that set up, and I don’t see a Lookup column, so you’ll need to add that if you haven’t.

---

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [February 9, 2022, 2:31pm UTC](https://community.glideapps.com/t/how-do-i-get-another-column-value-by-using-lookup/38257/5 "2022-02-09T14:31:52Z")

</div>

Yes! Great. Thanks!

Just realize that I first need to create relation column THEN a lookup column.  
Was thinking it is one step process!

I have been searching for a way to add picture and username from Users table by Friend Email. Now I can easily add Lookup column for that.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d7bcee3deeceb5a119e358afb3899639c618932c.jpeg)

---

<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 10, 2022, 2:32pm UTC](https://community.glideapps.com/t/how-do-i-get-another-column-value-by-using-lookup/38257/6 "2022-02-10T14:32:25Z")

</div>

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