# Suggestion needed

**URL:** <https://community.glideapps.com/t/suggestion-needed/6489>\
**Category:** Ask for Help\
**Created:** [April 6, 2020, 10:03am UTC](https://community.glideapps.com/t/suggestion-needed/6489 "2020-04-06T10:03:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Suleimaan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/suleimaan/32/2503_2.png) [@Suleimaan](https://community.glideapps.com/u/Suleimaan)\
**Post date:** [April 6, 2020, 10:03am UTC](https://community.glideapps.com/t/suggestion-needed/6489/1 "2020-04-06T10:03:24Z")

</div>

I want to create an online school app. The challenge I am facing is _" how to make the app smart enough to differentiate between the user’s class and payment status contained in the home sheet of the app and relate it with the subject’s sheet of the App so as to decide for a unique visibility for each user. The subjects sheets only contained columns related to subjects."_

---

<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:** [April 6, 2020, 12:35pm UTC](https://community.glideapps.com/t/suggestion-needed/6489/2 "2020-04-06T12:35:32Z")

</div>

- In the home sheet, create a column that’s filled with true whenever the user is paid up.
- In the class sheet, create a template column with a value that’s always true.
- Create a related from the class sheet to link the true template to the true column in the home sheet.
- Create a lookup column in the class sheet to return all emails from the relation that are set to true.
- Set visibility and filtering checking if the lookup column is signed in user.

Further discussion on this thread:

> [@Hide Elements When User Not Signed In](https://community.glideapps.com/t/hide-elements-when-user-not-signed-in/4723):
>
> I’m having trouble hiding elements from none signed in users. Trying to display a create profile on the “Home” tab if the isn’t signed in. I can hide elements on the “Profile” tab but not the home tab. No option to only display for signed in user. Any help much appreciated.

---

<div class="post-metadata">

**Author:** ![Suleimaan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/suleimaan/32/2503_2.png) [@Suleimaan](https://community.glideapps.com/u/Suleimaan)\
**Post date:** [April 11, 2020, 11:32am UTC](https://community.glideapps.com/t/suggestion-needed/6489/3 "2020-04-11T11:32:50Z")

</div>

Thanks for this suggestion, I have tried it. The issue am having is in ste 4, the column is returning only the first row’s email and when set to multiple, returns more than 1 email/row of the email lookup column there by making visibility impossible.

is there sth am getting wrong or there’s another trick to it?

---

<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:** [April 12, 2020, 3:11pm UTC](https://community.glideapps.com/t/suggestion-needed/6489/4 "2020-04-12T15:11:57Z")

</div>

You want multiple emails to be returned. This will contain all the emails of users that have paid. This way you can set visibility, using the lookup column, to ‘is signed-in user’ and any of the users that have paid will see the component.

‘Is Signed-In User’ works great with an array of multiple email addresses.

---

<div class="post-metadata">

**Author:** ![Suleimaan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/suleimaan/32/2503_2.png) [@Suleimaan](https://community.glideapps.com/u/Suleimaan)\
**Post date:** [April 13, 2020, 9:41am UTC](https://community.glideapps.com/t/suggestion-needed/6489/5 "2020-04-13T09:41:25Z")

</div>

Thank you, I have tried it but is like I’m not getting what you are pointing at. Let me post a video about it and then you can explain to me in light of the video. Thanks

---

<div class="post-metadata">

**Author:** ![Suleimaan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/suleimaan/32/2503_2.png) [@Suleimaan](https://community.glideapps.com/u/Suleimaan)\
**Post date:** [April 13, 2020, 2:19pm UTC](https://community.glideapps.com/t/suggestion-needed/6489/6 "2020-04-13T14:19:47Z")

</div>

Here we go

---

<div class="post-metadata">

**Author:** ![Suleimaan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/suleimaan/32/2503_2.png) [@Suleimaan](https://community.glideapps.com/u/Suleimaan)\
**Post date:** [April 13, 2020, 2:27pm UTC](https://community.glideapps.com/t/suggestion-needed/6489/7 "2020-04-13T14:27:54Z")

</div>

ALSO THIS

---

<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:** [April 16, 2020, 1:44am UTC](https://community.glideapps.com/t/suggestion-needed/6489/8 "2020-04-16T01:44:09Z")

</div>

@Suleimaan You are very close. The relation column you have does show the email addresses, but relation column is designed to always show the first column. What it is really doing is just showing that it found a matching row. That’s why to also need a lookup column. You created your lookup column correctly (‘New Column’) in your first video. In your second video you were still trying to use the relation column. You should instead use the Lookup column you created, which contains the email addresses of all the users that are found in the relation.

Like I said, you were very close, but you need to use the lookup column to set visibility and filtering. Think of the relation column as the entire matching row. The lookup column selects one column from that row. When you use the lookup column, you can then select to match ‘is signed-in user’.
