# Cel colors within Glide Data Editor

**URL:** <https://community.glideapps.com/t/cel-colors-within-glide-data-editor/62098>\
**Category:** Ask for Help\
**Created:** [May 24, 2023, 4:46pm UTC](https://community.glideapps.com/t/cel-colors-within-glide-data-editor/62098 "2023-05-24T16:46:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [May 24, 2023, 4:46pm UTC](https://community.glideapps.com/t/cel-colors-within-glide-data-editor/62098/1 "2023-05-24T16:46:35Z")

</div>

I have a lookup from a Query which shows up in the data editor (but it is grey within the cel) but does not show up in the Layout Editor when I try to use it.

I have the same exact lookup for a Relation which shows up in the data editor (but is aqua within the cel) and it DOES show up in the Layout Editor.

What does the colors mean?

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/84245b7f83449115880a6ad158cf1665d235e5f0.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:** [May 24, 2023, 4:57pm UTC](https://community.glideapps.com/t/cel-colors-within-glide-data-editor/62098/3 "2023-05-24T16:57:44Z")

</div>

Query always acts as a multiple relation, so you will need to use a Single Value column instead of a Lookup.

---

<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:** [May 24, 2023, 4:57pm UTC](https://community.glideapps.com/t/cel-colors-within-glide-data-editor/62098/4 "2023-05-24T16:57:47Z")

</div>

A lookup through a Query column is the same as a lookup through a multiple relation in that it will always return an array. If you want the same as you would get with a lookup through a single relation, then you need to use a single value column instead of a lookup.

---

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [May 24, 2023, 10:17pm UTC](https://community.glideapps.com/t/cel-colors-within-glide-data-editor/62098/5 "2023-05-24T22:17:13Z")

</div>

Thanks. This worked.

---

<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:** [May 25, 2023, 10:17pm UTC](https://community.glideapps.com/t/cel-colors-within-glide-data-editor/62098/6 "2023-05-25T22:17:31Z")

</div>

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