# Relation Column Not Showing as an Option

**URL:** https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017
**Category:** Ask for Help
**Created:** [February 18, 2021, 8:03pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017 "2021-02-18T20:03:51Z")
**Posts on this page:** 10
**Page:** 2

<div class="post-metadata">

### Author: ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 19, 2021, 8:19am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/21 "2021-02-19T08:19:44Z")

</div>

There’s no way to change the color of the button when its clicked correct? You can’t really tell if you are currently set to yes or no as the button itself doesn’t change.

---

<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: [February 19, 2021, 8:23am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/22 "2021-02-19T08:23:11Z")

</div>

My approach is usually have two button bars and show them based on the current “value” of the destination column.

To do this, you must have a lookup to return the boolean value from the HideFromChat column.

Then:

- If HideFromChat is True then show the button with the normal color on the “Show” button, and bordered color with no fill on the “Hide” button.

- Vice versa for the case when HideFromChat is False.

---

<div class="post-metadata">

### Author: ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 19, 2021, 8:12pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/23 "2021-02-19T20:12:25Z")

</div>

Hi Thinh, so when I click on the YES button, nothing is happening. This is what I have set up:  
User Profiles Sheet Hide Column:  
 ![hide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4da5e274c9888906c1b67b14a32ad882d9dfc566.png)

Chat Sheet Hide Relation:  
 ![hide1234](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/83559c488baee83fbe2f842ff7bf011f9a60217c.png)

Chat Button Bar and Set Column Settings:  
 ![hide1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1dd5abd76de712e54454ee385edce5368150de3e.png)

 ![hide123](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f953b741004e972b0d740208ff79ac28c447023.png)

I am thinking the set column should be writing to the hide chat boolean column in the user profiel sheet, somehow?

---

<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: [February 19, 2021, 11:44pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/24 "2021-02-19T23:44:00Z")

</div>

It looks like the right setup, can you check if the relation is actually returning a row?

---

<div class="post-metadata">

### Author: ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 20, 2021, 1:27am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/25 "2021-02-20T01:27:48Z")

</div>

Sorry, not sure what do you mean?

---

<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: [February 20, 2021, 2:36am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/26 "2021-02-20T02:36:41Z")

</div>

The relation is showing this “-“. I’m not entirely sure if it’s returning an empty column from the destination (which means there is a row to look at) or not.

Probably there’s a set column bug going around so would have to wait and see.

---

<div class="post-metadata">

### Author: ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 20, 2021, 3:41am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/27 "2021-02-20T03:41:23Z")

</div>

Hmm, I’m never too sure what the ‘-’ symbols mean.

---

<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 20, 2021, 4:02am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/28 "2021-02-20T04:02:06Z")

</div>

When you see a minus ‘-’ in a (single) relation column, it means the relation is broken (empty).  
In a multi-relation, a broken relation will appear empty.

PS. The above just based on my own observation, I may not be 100% correct.

---

<div class="post-metadata">

### Author: ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [February 20, 2021, 4:03am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/29 "2021-02-20T04:03:21Z")

</div>

Hmm…thanks! I’ve also noticed it pulls the name of the app or some other random data.

---

<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 20, 2021, 4:04am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/30 "2021-02-20T04:04:44Z")

</div>

> [@I just realized](https://community.glideapps.com/t/i-just-realized/22893/4):
>
> Yes, this should be improved. The bubble is supposed to represent the entire related row, and the logic for what we display in the bubble is “show the value from the leftmost column in the row”—ideally, you’d tell us which column contains the name (and photo!) and we would render a better bubble.

[Previous page](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017.md?page=1)
