# TOP 10 list

**URL:** <https://community.glideapps.com/t/top-10-list/37586>\
**Category:** Ask for Help\
**Created:** [January 23, 2022, 5:38pm UTC](https://community.glideapps.com/t/top-10-list/37586 "2022-01-23T17:38:07Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lubos\_Namyslo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lubos_namyslo/32/28677_2.png) [@Lubos\_Namyslo](https://community.glideapps.com/u/Lubos_Namyslo)\
**Post date:** [January 23, 2022, 5:38pm UTC](https://community.glideapps.com/t/top-10-list/37586/1 "2022-01-23T17:38:07Z")

</div>

Hello,  
I would like to introduce a TOP 10 feature.  
I have Users Glide tab with all sorts columns, some of them are user-specific (e.g. e-mail column is user specific). One column (non user-specific) shows values which I would like to use to create Top10 list of users.  
Now, I insert an Inline list component and it is showing Top 10 for that particular Column as a source of data since I’m Admin. However, the user can only see his result and thus Top 10 list is displaying just him and his value from the column.  
Is there any way I can figure it out so that each user can see Top 10 users?  
I do appreciate your advice.  
Lubos

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [January 23, 2022, 5:42pm UTC](https://community.glideapps.com/t/top-10-list/37586/2 "2022-01-23T17:42:57Z")

</div>

It sounds like your screen is either filtered by signed-in user, or you’re using Row Owners, so only the owner of the row can see that particular row, not all rows of data.

---

<div class="post-metadata">

**Author:** ![Lubos\_Namyslo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lubos_namyslo/32/28677_2.png) [@Lubos\_Namyslo](https://community.glideapps.com/u/Lubos_Namyslo)\
**Post date:** [January 23, 2022, 5:47pm UTC](https://community.glideapps.com/t/top-10-list/37586/3 "2022-01-23T17:47:58Z")

</div>

Thank you for your response. Yes, you are right. I have been using Row Owners as I do not want all data visible to all users. Is there any way around it? Or, I can not go around Row Owners?

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 23, 2022, 6:03pm UTC](https://community.glideapps.com/t/top-10-list/37586/4 "2022-01-23T18:03:24Z")

</div>

One way would be to build a small table without any row owners which contains the minimum amount of data for your top 10.

If you are currently using or upgrade to private pro, then you could implement Roles.

> **[Roles](https://docs.glideapps.com/all/topics/security-and-user-data/roles)**
>
> Define roles for your users

---

<div class="post-metadata">

**Author:** ![Lubos\_Namyslo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lubos_namyslo/32/28677_2.png) [@Lubos\_Namyslo](https://community.glideapps.com/u/Lubos_Namyslo)\
**Post date:** [January 23, 2022, 6:21pm UTC](https://community.glideapps.com/t/top-10-list/37586/5 "2022-01-23T18:21:41Z")

</div>

Thank you Eric. This is definitely a spot-on advice. Unfortunately, I assume to have hundreds of users in future (hundreds of rows) and it would mean I would have to have a separate table with other hundreds of rows. But a good point. So far, I’m using a free plan but upgrading is definitely an option for me.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 23, 2022, 6:35pm UTC](https://community.glideapps.com/t/top-10-list/37586/6 "2022-01-23T18:35:09Z")

</div>

> [@Lubos\_Namyslo](#):
>
> I have Users Glide tab

Is this a glide table or a Google Sheet?

If it’s a GSheet I’m thinking you could create a new tab, hard code a column with the numbers 1-10. Then do a =vlookup to the user profiles rank column. (Assuming you have a numbered rank column in user profiles)

---

<div class="post-metadata">

**Author:** ![Lubos\_Namyslo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lubos_namyslo/32/28677_2.png) [@Lubos\_Namyslo](https://community.glideapps.com/u/Lubos_Namyslo)\
**Post date:** [January 23, 2022, 6:37pm UTC](https://community.glideapps.com/t/top-10-list/37586/7 "2022-01-23T18:37:11Z")

</div>

Actually, I’m using Glide tables.

---

<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:** [January 23, 2022, 11:54pm UTC](https://community.glideapps.com/t/top-10-list/37586/8 "2022-01-23T23:54:09Z")

</div>

Then it’s a hard problem since you can’t use any helper formula to load the data, since the device does not load that data at all when the session is initiated.

Is removing Row Owners even an option for you? You might have to go Private Pro to use Roles for this.

---

<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:** [January 24, 2022, 1:26am UTC](https://community.glideapps.com/t/top-10-list/37586/9 "2022-01-24T01:26:32Z")

</div>

> [@Lubos\_Namyslo](#):
>
> some of them are user-specific (e.g. e-mail column is user specific).

Why would you make the email column user-specific?

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 24, 2022, 4:32am UTC](https://community.glideapps.com/t/top-10-list/37586/10 "2022-01-24T04:32:21Z")

</div>

You could add a Google Sheet to the app and redo the the entire user profiles tab in a new GSheet tab ([Find all uses](https://docs.glideapps.com/all/product/data-editor/managing-columns#find-all-uses) is your best friend)

Then you could leverage some helper formulas like `=filter` or `=vlookup` and build a simple 10 row table viewable to everyone.

My highest recommendation would still be to upgrade to private pro and take advantage of roles.

---

<div class="post-metadata">

**Author:** ![Lubos\_Namyslo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lubos_namyslo/32/28677_2.png) [@Lubos\_Namyslo](https://community.glideapps.com/u/Lubos_Namyslo)\
**Post date:** [January 24, 2022, 6:12am UTC](https://community.glideapps.com/t/top-10-list/37586/11 "2022-01-24T06:12:39Z")

</div>

I’m quite new to Glide, therefore inexperienced, and I thought it was imperative to protect sensitive personal data from being disclosed to other users. But the truth is I may use filters. I will try to remove Row Owner and see what it does to the app and if using filters is a working option here. Thank you for your insight.

---

<div class="post-metadata">

**Author:** ![Lubos\_Namyslo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lubos_namyslo/32/28677_2.png) [@Lubos\_Namyslo](https://community.glideapps.com/u/Lubos_Namyslo)\
**Post date:** [January 24, 2022, 6:13am UTC](https://community.glideapps.com/t/top-10-list/37586/12 "2022-01-24T06:13:11Z")

</div>

I will try this option

---

<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:** [January 24, 2022, 7:20am UTC](https://community.glideapps.com/t/top-10-list/37586/13 "2022-01-24T07:20:36Z")

</div>

My question was regarding [user specific columns](https://docs.glideapps.com/all/product/data-editor/user-specific-columns), not [row owners](https://docs.glideapps.com/all/topics/security-and-user-data/row-owners).

These are two completely separate things. You had mentioned that you were using user specific columns for emails. I can’t think of any scenario where this would make sense.

Row owners is different. Yes, it often makes sense to make the email column a row owner, and yes it is a security feature. The thing to understand with row owners is that once it is applied, then Glide will prevent data from being downloaded to an end users device if that user isn’t an “owner” of that data.

Filters on the other hand, are applied _after_ the data has been downloaded. So whilst filters can be used to hide data from view, the data is still there and available if users want to go looking for it (and know how to find it). So filters are not a security feature.

---

<div class="post-metadata">

**Author:** ![Lubos\_Namyslo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lubos_namyslo/32/28677_2.png) [@Lubos\_Namyslo](https://community.glideapps.com/u/Lubos_Namyslo)\
**Post date:** [January 24, 2022, 7:36am UTC](https://community.glideapps.com/t/top-10-list/37586/14 "2022-01-24T07:36:26Z")

</div>

Sorry Darren, this is my bad. I miswrote and confused user-specific and Row Owner. The e-mail column is Row Owner not user-specific. Thank you for explanation anyway, this is great piece of information.
