# Visibility -\> connect to more than just the current sheet-tab

**URL:** <https://community.glideapps.com/t/visibility-connect-to-more-than-just-the-current-sheet-tab/5198>\
**Category:** Feature Requests\
**Created:** [March 5, 2020, 12:38pm UTC](https://community.glideapps.com/t/visibility-connect-to-more-than-just-the-current-sheet-tab/5198 "2020-03-05T12:38:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [March 5, 2020, 12:38pm UTC](https://community.glideapps.com/t/visibility-connect-to-more-than-just-the-current-sheet-tab/5198/1 "2020-03-05T12:38:04Z")

</div>

Here’s the challenge:

- app is email with password
- when user comes into the app they must create a Profile to be able to see things
- then use Visibility and Filters through the app to control who sees what

The problem:

- there are sheets / tabs that do NOT contain every email - e.g. Trips only has emails of the people who have created Trips… and News has no emails in there at all
- and right now if the email exists in the sheet, then I can use my visibility things nicely… but if they have not created a doct in that sheet, the visibility approach does not work

The best way to handle would be a lookup in Visibility to another sheet (i.e. Profile)  
I am using Rel columns in Glide… but the Trips and News sheet needs to make a rel with something… and there is no Email to tie on to!

Argh!

Very open to ideas of workarounds! Thanks, M

---

<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:** [March 5, 2020, 1:00pm UTC](https://community.glideapps.com/t/visibility-connect-to-more-than-just-the-current-sheet-tab/5198/2 "2020-03-05T13:00:17Z")

</div>

In the sheets that don’t have an email, create a template column that contains a value, such as"Profile". Create the same column in your profile sheet. This will allow you to create a relation column from any sheet to the profile sheet using the “Profile” template columns. Finally create a lookup column that, uses the relation, to get a list of emails from users who have created a profile. You can use the lookup column to set visibility based on signed in user.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 5, 2020, 1:06pm UTC](https://community.glideapps.com/t/visibility-connect-to-more-than-just-the-current-sheet-tab/5198/3 "2020-03-05T13:06:51Z")

</div>

Exactly what I was going to suggest. This is what I did in [itemstore.glideapp.io](http://itemstore.glideapp.io)

Eg, if you haven’t created a profile and visit the shop tab, you won’t be able to make purchases.

---

<div class="post-metadata">

**Author:** ![messly](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/messly/32/4431_2.png) [@messly](https://community.glideapps.com/u/messly)\
**Post date:** [March 25, 2020, 11:27am UTC](https://community.glideapps.com/t/visibility-connect-to-more-than-just-the-current-sheet-tab/5198/4 "2020-03-25T11:27:50Z")

</div>

Thanks for this. I’m also trying to achieve the same thing but I’m wondering whether this solution is scalable? I have a list of 1000 items and 5000 user profiles. I presume with this method each item will have to lookup all 5000 profiles which would have a big impact on performance?

---

<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:** [March 25, 2020, 12:31pm UTC](https://community.glideapps.com/t/visibility-connect-to-more-than-just-the-current-sheet-tab/5198/5 "2020-03-25T12:31:46Z")

</div>

Hard to say. Try it and see what happens.

---

<div class="post-metadata">

**Author:** ![Caring](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/caring/32/15140_2.png) [@Caring](https://community.glideapps.com/u/Caring)\
**Post date:** [April 22, 2020, 5:21pm UTC](https://community.glideapps.com/t/visibility-connect-to-more-than-just-the-current-sheet-tab/5198/6 "2020-04-22T17:21:34Z")

</div>

So helpful, thank you!
