# 🥇 Creating Private Leaderboards **URL:** \ **Category:** Project Showcase\ **Created:** [June 17, 2020, 6:36pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044 "2020-06-17T18:36:11Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [June 17, 2020, 6:36pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/1 "2020-06-17T18:36:11Z")
# Hey all! I had a request from a Glide user the other day and how to create **private leader boards** in an app. I managed to figure it out and thought that this community could benefit from the logic. Take a look! [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9733a545c8c74b8d112daf662eb518511eb3bb60.jpeg "Glide: Create Private Leaderboards") ](https://www.youtube.com/watch?v=1Ja8tsDdOkE) ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [June 17, 2020, 7:31pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/2 "2020-06-17T19:31:32Z")
Nice thank for sharing @Robert_Petitto ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [June 17, 2020, 7:37pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/3 "2020-06-17T19:37:47Z")
Can I have a link to the app ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [June 17, 2020, 10:29pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/4 "2020-06-17T22:29:37Z")
Great stuff from you as always. Just a quick question that I can’t wrap my head around. Why do you have a relation to the same item in the same tab? I mean, not in this specific case, but in general… what does that allow you to achieve? ---
**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:** [June 17, 2020, 11:28pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/5 "2020-06-17T23:28:15Z")
I do it every so often to create a single component / lookup using that tab’s data (avoids the need to create a new tab with similar data for relations/lookups). I usually do it to create an inline list of a single item, place it in cards/tiles view, and display the information. Prior to inline list \> Action \> Link to screen, the details view of said inline list would loop back to same screen, so I used to always say Action -\> None. But now we can link that item in the list to a new screen to prevent the looping. Here’s an example of a single tile view from a relate to self: ![Screen Shot 2020-06-17 at 7.27.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c757461d54bfaff328433b1e97a7fce1005b97ba.jpeg) ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [June 18, 2020, 4:14pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/6 "2020-06-18T16:14:58Z")
Avant this be used to create a kind of group chat ---
**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:** [June 18, 2020, 4:56pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/7 "2020-06-18T16:56:56Z")
Sure could! ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [June 18, 2020, 8:50pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/8 "2020-06-18T20:50:21Z")
Looking forward to it 👍 👍 ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 13, 2020, 12:57pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/9 "2020-07-13T12:57:18Z")
Hello Robert, Thanks as ususal ! I just don’t get what is this relation : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e37a6f3b751e22f5e274bce59e6eb9442f7758a8.jpeg) From where ? and how do you make it ? 🙂 Maybe it is possible to have the link of your app ? 😬 🙂 ---
**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:** [July 13, 2020, 1:12pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/10 "2020-07-13T13:12:03Z")
I can’t share the app as it belongs to one of my clients. I mentioned this relation in the video—its a relation from the user email to the email address of joining/creating a leaderboard. ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 13, 2020, 1:47pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/11 "2020-07-13T13:47:15Z")
Thanks for your answer. 🙂 I just dont understand how you create that rel\_leaderboard **S** that is your bottom inline list. I guess it would be that one : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b4acce83e8a22d414d1d0bb2e203d2ba1a6d3c08.jpeg) But you don’t show how you make it 😓 i think ---
**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:** [July 13, 2020, 1:59pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/12 "2020-07-13T13:59:37Z")
I do…but here’s a further explanation: https://www.loom.com/embed/3392832ac05e4984b89c1018f914357c ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 13, 2020, 3:37pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/13 "2020-07-13T15:37:08Z")
Got it, Thanks a lot Robert ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [July 13, 2020, 6:01pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/14 "2020-07-13T18:01:21Z")
My leaderboard works, and i am trying now to be able **to eliminate choices when they were selected before, in my different leaderboards** (like party). 😅 I am trying to use your method : [How to eliminate choices after they've been selected: Many-to-many relations](https://community.glideapps.com/t/how-to-eliminate-choices-after-theyve-been-selected-many-to-many-relations/9140/14)) 🥵 🥵 🥵 🥵 But i can’t figured out how to turn that pattern : **email - team1** to that pattern : **email - team 1 - leaderboard** ([here](https://youtu.be/6ucd1PkHDbE) in your tuto) We would need some leaderboard dynamics data i guess. Any idea ? 😃 Maybe another challenge for @Robert_Petitto = Glide god! 😇 ---
**Author:** ![Golf\_en\_la\_Nube](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golf_en_la_nube/32/9593_2.png) [@Golf\_en\_la\_Nube](https://community.glideapps.com/u/Golf_en_la_Nube)\ **Post date:** [July 14, 2020, 12:23pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/15 "2020-07-14T12:23:32Z")
I was the one who made the consultation, I appreciate the presentation but it is not the solution I need because the logic is different, added to the fact that the results of mathematical operations carried out in GLIDE cannot be exported, it is making me rethink the use of GLIDE or look for another similar solution. What I need is when generating a new tournament, in addition to various data, a tournament ID is generated as a single value. Then the players load the scores of each hole in a sheet to load the scores, using a row for each one and through a lookup of the relationship with the tournament listing sheet I bring the tournament ID in each row. What I want to do is in the same sheet or another group by tournament ID all the players and their scores and be able to show the data sorted by scores. GLIDE seems to me an excellent way to enter the data, so I will see how to use it as a “data entry” and I will have to see other options for the treatment of the generated data. Thanks again. ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 14, 2020, 2:09pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/16 "2020-07-14T14:09:01Z")
what if the admin joins the group again with his own invite code how to prevent this ---
**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:** [July 14, 2020, 2:49pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/17 "2020-07-14T14:49:48Z")
Hm. There isn’t because Glide doesn’t have data validation. ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 15, 2020, 9:28am UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/18 "2020-07-15T09:28:05Z")
hi @Robert_Petitto i just found out that users can add other users to a group i made a form to add another user to group and only two text entries which where the email(of the user they want to add not thiers) and invitecode and it worked ---
**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:** [July 15, 2020, 11:55am UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/19 "2020-07-15T11:55:31Z")
Yep that should work! ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 15, 2020, 1:20pm UTC](https://community.glideapps.com/t/creating-private-leaderboards/11044/20 "2020-07-15T13:20:24Z")
i have one problem i do not want users to create more than 2 groups unless they are admin [Next page](https://community.glideapps.com/t/creating-private-leaderboards/11044.md?page=2)