# Lookup field not working

**URL:** <https://community.glideapps.com/t/lookup-field-not-working/28948>\
**Category:** Ask for Help\
**Created:** [July 10, 2021, 7:19pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948 "2021-07-10T19:19:52Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jvmenen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jvmenen/32/28897_2.png) [@Jvmenen](https://community.glideapps.com/u/Jvmenen)\
**Post date:** [July 10, 2021, 7:19pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/1 "2021-07-10T19:19:52Z")

</div>

My app’s URL: [Glide](https://go.glideapps.com/app/MpJnYgxlWDA7fFGbpMPP/layout)

I have recorded the issue in this youtube vid: [Lookup field bug - YouTube](https://youtu.be/0VXBT_yxhLM)

Maybe I’m doing something wrong… But cant figure out what.

Hope this helps. Let me know if more info is needed.  
Jeroen

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [July 10, 2021, 7:23pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/2 "2021-07-10T19:23:51Z")

</div>

Hola @Jvmenen

Is your relation multiple? If so, that’s the problem. Lookups work with single relations.

> **[Lookup Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/lookup-column)**
>
> Lookup values from another table

I hope this helps.

---

<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:** [July 10, 2021, 7:26pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/3 "2021-07-10T19:26:39Z")

</div>

Everything looks ok, but do you have row owners on your user table. Also, you could try refreshing your browser, or recreating the relation and lookup.

---

<div class="post-metadata">

**Author:** ![Jvmenen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jvmenen/32/28897_2.png) [@Jvmenen](https://community.glideapps.com/u/Jvmenen)\
**Post date:** [July 10, 2021, 7:33pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/4 "2021-07-10T19:33:06Z")

</div>

Hi Jeff, I Have row owner on the user table but not on the things table. It has for sure something to do with the option: Viewing as. (top left corner). When I uncheck, no names show up. When I check a name, only that name shows op in the list view for the items related to the “viewing” user. For the other items in the list the names stays blank.

---

<div class="post-metadata">

**Author:** ![Jvmenen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jvmenen/32/28897_2.png) [@Jvmenen](https://community.glideapps.com/u/Jvmenen)\
**Post date:** [July 10, 2021, 7:34pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/5 "2021-07-10T19:34:37Z")

</div>

Hi, thanx for the sugestion but the relation is not multiple (an item in the things list belongs to 1 user in the user table).

---

<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:** [July 10, 2021, 7:37pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/6 "2021-07-10T19:37:00Z")

</div>

Row owners still apply whether it’s coming through a relation or not. When Row Owners are applied, only the signed in user can see rows that have the same email address as the one they used to sign in. On a phone, none of the other data is even downloaded if they are not the owner of the data. Row owners is a security feature.

---

<div class="post-metadata">

**Author:** ![Jvmenen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jvmenen/32/28897_2.png) [@Jvmenen](https://community.glideapps.com/u/Jvmenen)\
**Post date:** [July 10, 2021, 7:38pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/7 "2021-07-10T19:38:32Z")

</div>

Hi Jeff, removing the Owner from the email field in the user table resulted in showing all the names for every item in the list.  
My bad, Ik can see this is intended functionality to keep info secure.  
Learned something! And thanx for pointing me in this direction!  
Jeroen

---

<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:** [July 10, 2021, 7:40pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/8 "2021-07-10T19:40:10Z")

</div>

Glad to help.

---

<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:51pm UTC](https://community.glideapps.com/t/lookup-field-not-working/28948/9 "2024-01-17T16:51:27Z")

</div>


