# Visibility based on text in column

**URL:** <https://community.glideapps.com/t/visibility-based-on-text-in-column/23538>\
**Category:** Ask for Help\
**Created:** [February 28, 2021, 5:36am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538 "2021-02-28T05:36:41Z")\
**Posts on this page:** 20\
**Page:** 1

<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 28, 2021, 5:36am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/1 "2021-02-28T05:36:41Z")

</div>

Hi!

How can I set the visibility for a component based on if a specific column has a certain word…for example the word ‘true’ or the word ‘yes’.

Thanks!

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 28, 2021, 5:40am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/2 "2021-02-28T05:40:27Z")

</div>

![Screen Shot 2021-02-28 at 12.39.31 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0a4a71897b33a3310cd5f30a9c498e69815f187d.png)

---

<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 28, 2021, 5:45am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/3 "2021-02-28T05:45:23Z")

</div>

It’s for text found in the ENTIRE column. I used a lookup and a rollup on two seperate accounts. Does visibility settings not work for those two?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 28, 2021, 5:49am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/4 "2021-02-28T05:49:37Z")

</div>

it should work, remember these columns are user specific, so it will work only for the user who set these columns

---

<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 28, 2021, 6:27am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/5 "2021-02-28T06:27:49Z")

</div>

I have the following set up and it’s not working…  
 ![false1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/568246fe9ba9899d1b32b314fdd159f117d28ba3.png)

 ![false](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/10131614d46b17770668d7ac4590c6bcf672a13f.png)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 28, 2021, 6:32am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/6 "2021-02-28T06:32:38Z")

</div>

when you change includes to is, still not working?  
also check if true dont have a space before or after, and if true value is on the user that you are sign in  
are you sure you wanna do visibility option not filter???  
let me check if i understand what you trying to do…  
you wan to component not showing for specific user if the value in his row is true? or if any value in this column is true?

---

<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 28, 2021, 6:45am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/7 "2021-02-28T06:45:07Z")

</div>

Yes, there is no space. When I make it ‘is included in’ true the text is displayed. I don’t understand that part however.

I want the text to show or not show depending on what is in that specific column, not user specific.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 28, 2021, 6:46am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/8 "2021-02-28T06:46:36Z")

</div>

if any row is true ? or only this row is true?

---

<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 28, 2021, 6:46am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/9 "2021-02-28T06:46:54Z")

</div>

If any row is true.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 28, 2021, 6:48am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/10 "2021-02-28T06:48:26Z")

</div>

than you need to add one more column to join LU eats column, and use that new column in visibility condition

---

<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 28, 2021, 7:01am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/11 "2021-02-28T07:01:23Z")

</div>

ok thanks! what type of column?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 28, 2021, 7:02am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/12 "2021-02-28T07:02:23Z")

</div>

![Screen Shot 2021-02-28 at 2.01.57 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8ac7a4682c57248be552a170c75c141e0ca248c.png)

Joined List

---

<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 28, 2021, 7:06am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/13 "2021-02-28T07:06:14Z")

</div>

Thanks! I see I was using rollup which is for numbers only.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 28, 2021, 7:07am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/14 "2021-02-28T07:07:13Z")

</div>

not only… but for your goal, only joined list will work, BTW rollup is a very confusing name for this function, i had a problem with that too

---

<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:** [March 1, 2021, 4:41am UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/15 "2021-03-01T04:41:43Z")

</div>

Hi Uzo,

So I’m trying to do this in another part of my app and for some reason the joined list is not coming up as an option for visbility. Would there be reason for this? Thanks!

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2021, 2:57pm UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/16 "2021-03-01T14:57:59Z")

</div>

you have to create joined column in that sheet where the list is located or create relation column to that joined column.

---

<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:** [March 1, 2021, 3:11pm UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/17 "2021-03-01T15:11:57Z")

</div>

Yup, its on the same sheet. It’s set up the exact same way, just not showing up as an option.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2021, 3:13pm UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/18 "2021-03-01T15:13:36Z")

</div>

you must be on the deferent sheet in editor, or the screen you are on is deferent sheet than inline list

---

<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:** [March 1, 2021, 3:29pm UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/19 "2021-03-01T15:29:23Z")

</div>

OK I see, the inline list is on a different sheet from the tab. I created 4 joined lists, so I have to move them over to the same sheet as the tab?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2021, 3:31pm UTC](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538/20 "2021-03-01T15:31:15Z")

</div>

yes or relate to them

[Next page](https://community.glideapps.com/t/visibility-based-on-text-in-column/23538.md?page=2)
