Hey, i’m new on glide and i would like to make an exercice for myself, make a leaderboard.
Let me explain: in tab 1 I have user names that are ordered from the one with the most commands to the one with the least. The problem is that I can’t do a ranking from this tab because there is a row owner that prevents me from being able to show everyone’s ranking to all users. So I decided to create a second tab in which I rewrite all the users names but I can’t put in the second table their ranking index.
The problem you have though is that you are using row owners in tab1 one. Your lookup column pulls in all rankings, but in reality it won’t in the app. Rows under row ownership won’t be downloaded on the end user device, so at most, that lookup I’ll only return one array value for the signed in user.
I guess the first question is, do you really need row owners on tab 1? Maybe you’ll end up having data that needs to be protected and need row owners, but it’s hard to tell in your example. My first thought would be to split bup your data. Have a user table (tab1), but also have your second table, like you already do, and move that formula to that table instead.
