# Values from Lookup columns showing in UI but not in published app

**URL:** https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104
**Category:** Report a Bug
**Created:** [March 29, 2020, 9:38pm UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104 "2020-03-29T21:38:28Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![psik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/psik/32/4861_2.png) [@psik](https://community.glideapps.com/u/psik)
#### Post date: [March 29, 2020, 9:38pm UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/1 "2020-03-29T21:38:28Z")

</div>

(First time Glide-builder here)

Context:  
One of my tabs is a List view whose Titles and Images are powered by Lookup columns defined in the Data Editor for the appropriate tab.

Problem:  
The item titles and images render fine when I view them in the Glide UI (see RHS screenshot in the attachment), BUT when I **publish** my app then these titles and images are blank when viewed on my phone or at the app’s URL (see LHS screenshot in the attachment). In trying to debug this I tried creating the lookup column manually in the google sheet itself (using an arrayformula) and that method renders fine in my published app. So it seems like there’s something preventing the Lookup values from the Data Editor making it through to the published app? For what it’s worth, the Relation column powering the Lookup columns IS NOT set to match multiple.

 ![Published vs GlideUI](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d21286234de95ef50080f2cdffa4010aa24f833b.jpeg)

---

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [March 29, 2020, 11:05pm UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/2 "2020-03-29T23:05:40Z")

</div>

Would you mind sharing your app, please?

---

<div class="post-metadata">

### Author: ![psik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/psik/32/4861_2.png) [@psik](https://community.glideapps.com/u/psik)
#### Post date: [March 30, 2020, 10:27am UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/3 "2020-03-30T10:27:17Z")

</div>

Hi Mark. Sorry for the inconvenience, but is there a way to share the link privately with you? It’s a product prototype I’d rather not circulate at the moment.

---

<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 30, 2020, 11:52am UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/4 "2020-03-30T11:52:06Z")

</div>

Click on a user’s name and click Message to do a private message.

---

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [March 30, 2020, 1:21pm UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/5 "2020-03-30T13:21:42Z")

</div>

@psik Like Jeff said, you can PM me.

---

<div class="post-metadata">

### Author: ![psik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/psik/32/4861_2.png) [@psik](https://community.glideapps.com/u/psik)
#### Post date: [March 30, 2020, 2:06pm UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/6 "2020-03-30T14:06:41Z")

</div>

Thanks! Done.

---

<div class="post-metadata">

### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [March 30, 2020, 6:37pm UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/7 "2020-03-30T18:37:34Z")

</div>

There are two problems, one is with your data model, the other is a bug in Glide:

1. You have a row owner column set in your “Users” table, which means that each user only has access to their own row in that table. The “Contacts” table does a lookup into another user’s row in Users, which comes up empty, because users don’t have access to other user’s rows.
2. The Glide builder doesn’t show that like it should. We’ll fix that soon.

---

<div class="post-metadata">

### Author: ![psik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/psik/32/4861_2.png) [@psik](https://community.glideapps.com/u/psik)
#### Post date: [March 30, 2020, 7:01pm UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/8 "2020-03-30T19:01:06Z")

</div>

Ah, that makes sense. I’ll have a think about whether I can accomplish the same thing efficiently with better use of the Data Editor, or otherwise I’ll settle for the in-sheet workaround. Thanks a lot for the speedy triaging - much appreciated!

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 25, 2024, 3:22pm UTC](https://community.glideapps.com/t/values-from-lookup-columns-showing-in-ui-but-not-in-published-app/6104/9 "2024-02-25T15:22:55Z")

</div>


