# Results of Lookup non-visible

**URL:** <https://community.glideapps.com/t/results-of-lookup-non-visible/6828>\
**Category:** Ask for Help\
**Created:** [April 11, 2020, 7:03pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828 "2020-04-11T19:03:45Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![SpyrosTsouk](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@SpyrosTsouk](https://community.glideapps.com/u/SpyrosTsouk)\
**Post date:** [April 11, 2020, 7:03pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/1 "2020-04-11T19:03:45Z")

</div>

I use Lookup to retrieve some values in the data editor. But its results are not available as a column in the drop-down lists (when I choose what to depict). What do I do wrong?

PS. Forgive me if I have lost my ability to think after hours in front of the screen!

---

<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:** [April 11, 2020, 7:07pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/2 "2020-04-11T19:07:58Z")

</div>

Are you using a lookup on a multiple relation column? If so, it won’t work properly.

---

<div class="post-metadata">

**Author:** ![SpyrosTsouk](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@SpyrosTsouk](https://community.glideapps.com/u/SpyrosTsouk)\
**Post date:** [April 11, 2020, 7:08pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/3 "2020-04-11T19:08:56Z")

</div>

Now that you mention that, it’s absolutely clear.

---

<div class="post-metadata">

**Author:** ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)\
**Post date:** [December 2, 2020, 12:01pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/4 "2020-12-02T12:01:15Z")

</div>

I’m not sure if this is the same problem, but I’m currently trying to set a visibility setting for one screen based upon a lookup from a different screen (different sheet) and I’m getting the opposite response.  
My visibility settings are for it to appear when it is “NOT empty” and it only appears when I set it to “IS empty”. I’ve quadruple checked this and I can’t figure out why it’s not working.  
Any ideas?

---

<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:** [December 2, 2020, 12:32pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/5 "2020-12-02T12:32:02Z")

</div>

Is your lookup based on a multiple match relation?

---

<div class="post-metadata">

**Author:** ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)\
**Post date:** [December 2, 2020, 12:40pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/6 "2020-12-02T12:40:47Z")

</div>

The lookup is only based on a single relation.

---

<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:** [December 2, 2020, 2:02pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/7 "2020-12-02T14:02:50Z")

</div>

Has your relation ever been set to Multiple in the past?  
Does the Lookup contain a value in the data editor?  
Are Empty and Not Empty the only choices you have? Would it be better to check IS blank or IS NOT blank?  
Are you viewing the details of the correct row?

If you have any screenshots of your relation and lookup settings, and filters you may have of the screen and the visibility settings, they may help us out.

---

<div class="post-metadata">

**Author:** ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)\
**Post date:** [December 2, 2020, 2:22pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/8 "2020-12-02T14:22:27Z")

</div>

Hi Jeff,  
When I was trying to figure out what was wrong, I did test it with multiple (even though it won’t ever have to be).  
The lookup in the data editor does contain a value.  
No, there are other visibility components but it’s the lookup that is creating the problem. In one list the one that are blank appear and in the other list are the ones that are not blank.  
Yes, viewing the details in the right row.

I’ve taken a couple screenshots. Note that the button that is currently showing should not be showing since the lookup in the data editor does contain value. The second screenshot shows the visibility components for a button that is not showing, but should be showing since the lookup contains value (but appears if I switch the lookup to "IS empty).

 ![Screen Shot 2020-12-02 at 2.18.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e6ac5aa50f8370b6de4e61e782b49383cceca5a.png) ![Screen Shot 2020-12-02 at 2.18.23 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/c/1c0717f2708e3a1634bebf2b7e606bfe6db8e139.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:** [December 2, 2020, 3:06pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/9 "2020-12-02T15:06:18Z")

</div>

What type of column is your Signalled Complete column looking up? Can your share some of the expected values in that column as well?

---

<div class="post-metadata">

**Author:** ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)\
**Post date:** [December 2, 2020, 5:38pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/10 "2020-12-02T17:38:11Z")

</div>

The signalled complete looks up another “signalled complete” column in another sheet that gets incremented when someone clicks a button on a different screen.  
In the screen shots, they can “commencer (begin) the visit” which takes them to another screen that has information they need to fill out (linked to another sheet) as well as a button that is called “complete the visit” which increments the signalled complete in that sheet, consequently modifying the lookup signalled complete.

---

<div class="post-metadata">

**Author:** ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)\
**Post date:** [December 7, 2020, 4:38pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/11 "2020-12-07T16:38:37Z")

</div>

@Jeff_Hager  
Hi Jeff,  
Any thoughts as to why this is going a bit haywire? Still seems to be happening.

---

<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:** [January 5, 2021, 4:26am UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/12 "2021-01-05T04:26:13Z")

</div>

Sorry, playing catch up on some old posts. Did you ever get anywhere with this?

---

<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:58pm UTC](https://community.glideapps.com/t/results-of-lookup-non-visible/6828/13 "2024-01-17T16:58:22Z")

</div>


