# Relation Column Not Showing as an Option **URL:** \ **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:** 20\ **Page:** 1
**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 18, 2021, 8:03pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/1 "2021-02-18T20:03:52Z")
Hi, I am trying to pull in a relation column to use in a switch component. Are there reasons why the relation or lookup column doesn’t appear as an option? Also no option to pull data from another sheet. Thanks! ---
**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\ **Post date:** [February 18, 2021, 9:27pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/2 "2021-02-18T21:27:32Z")
Hey ! Thanks for sharing your issue with us. While I’m looking for a way to resolve your issue, please move your topic to the #help-how-to category to keep the community well organised ! ---
**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 18, 2021, 11:37pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/3 "2021-02-18T23:37:13Z")
Do you want to pull the relation over to use in a conditional visibility? ---
**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 18, 2021, 11:50pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/4 "2021-02-18T23:50:10Z")
Actually, it’s data from a boolean column in the user profile sheet. I want this switch component to be tied to that. The business checks it on or off. ---
**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 18, 2021, 11:50pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/5 "2021-02-18T23:50:49Z")
So you want to switch a user profiles sheet value on or off, while viewing the app from another sheet? ---
**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 18, 2021, 11:54pm UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/6 "2021-02-18T23:54:14Z")
The boolean column is if they want to be hidden from the list of businesses to contact, accessible only by other businesses. True= hide, false=be seen. ---
**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, 12:01am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/7 "2021-02-19T00:01:18Z")
Ok just to be clear here, you can’t switch a checkbox on a lookup column. There must be a boolean column in the Sheet you’re viewing to store the checkbox value. You can store the checkbox value in the sheet you’re viewing, then bring that back to the user profiles sheet. ---
**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, 12:08am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/8 "2021-02-19T00:08:41Z")
OK I see that,Thanks! So, I can’t select another sheet as well? If I could choose the boolean column on the user profile sheet that would work. At the bottom of the data selection drop down for components I sometimes see an option to pull data directly from another sheet. ---
**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, 12:11am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/9 "2021-02-19T00:11:19Z")
I think your best bet is to create a relation from your current Sheet back to the user profiles sheet, then use a button bar with a set column action to directly interact with the boolean column. ---
**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, 12:40am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/10 "2021-02-19T00:40:28Z")
Will take a look. Thank you! ---
**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, 4:30am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/11 "2021-02-19T04:30:14Z")
Am I linking this button bar to the relation column in the ‘current sheet’? I was also looking at the choice component. Is that automatically user-specified? I find they are both hard to tell which choice you are actually selecting. ---
**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, 5:36am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/12 "2021-02-19T05:36:14Z")
You should use a set column on the relation linking back to the user profiles sheet and set the true/false value using that. ---
**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, 6:00am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/13 "2021-02-19T06:00:43Z")
Ok, so I set the title for one button to YES and the other NO, then have set column actions for both? This is what I have: ![chat89](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f1592afb2a780eeb33a88c9ea31fd8e93a032cb.png) ---
**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, 7:37am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/14 "2021-02-19T07:37:57Z")
Yeah, but you would want to set them to true or false. ---
**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, 7:48am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/15 "2021-02-19T07:48:54Z")
Ahh, I see it has to be exactly what’s written to the column. I think that’s kind of weird for display text. Do you know if there is a way to have display text that’s different from what’s actually written to the column? ---
**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, 7:56am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/16 "2021-02-19T07:56:34Z")
You can name the button whatever you want, the value is configured independently in the action part, you can write the true/false value there using a custom value option. ---
**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:00am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/17 "2021-02-19T08:00:24Z")
Ahh, so like this for both sides of the button: ![chat89](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9778bd7cdb3fab0326b60f10bbb6c5c94418fc9.png) As you can tell , it’s my first time doing set columns 😬 ---
**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:05am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/18 "2021-02-19T08:05:00Z")
Let’s say you want the left button to set to Hide, then the left action will write true. The right action to set to Show, then the right action will write false. ---
**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:15am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/19 "2021-02-19T08:15:03Z")
Yes that sounds right. The Left button is set to ‘Yes’ and the Right Button to ‘No’. The question is: ‘Hide From Chat’ Ohh, Ithink I see what you mean…have this set up for Yes: ![chat89](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7bb6f0be72e9571ae52690051eba39d1262806cf.png) and swap out true for false for the No button? ---
**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:18am UTC](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017/20 "2021-02-19T08:18:16Z")
Yes that’s right. [Next page](https://community.glideapps.com/t/relation-column-not-showing-as-an-option/23017.md?page=2)