Using a combination of new Glide Plugin Columns, you can now rank items based on a raw value (points, score, scale, etc.) [Glide: Create a RANKED Leaderboard!]

Awesome! Instead of Join, Split, try Lookup Points on the Things table.

Make this adjustment in order to have your list items “tie” for rank values without skipping ranks: [image] RANK VIA New data columns Ask for Help This worked! https://www.loom.com/share/a43335985a8e4502af4cb6cda7f39b86

@Robert_Petitto do you mind if I use this in an education video? Will give you a shoutout.

Hmm… looks like we need to add numerical sorting to make this really work? [CleanShot 2021-11-08 at 11.53.52@2x]

Oof. Good catch. Yes, for sure.

@Darren_Murphy has also noted the other types we need Sort Array does not work on arrays of dates · Issue #58 · glideapps/glide-code-columns · GitHub I’m still going to use it though. Thanks @Robert_Petitto . I needed a good use case to crack open tutorials on Array column stuff.

Ya…this is disappointing. [Screen Shot 2021-11-08 at 7.52.49 AM] @david I submitted an issue: Sort Array column does not sort numbers · Issue #85 · glideapps/glide-code-columns · GitHub

Hola @Robert_Petitto and @JackVaughan Very weird the situation, I tested that plugin days ago and worked perfectly using a Number or Text column, it was even very smart by sorting the array. Today I retested it and it still works perfectly!. Here my result when my Num column is Number type [imag…

@gvalero you’re right. It does sort arrays of numbers correctly. @JackVaughan @Robert_Petitto how did you guys manage to break it? :thinking: :rofl: Okay, I think I figured out how it breaks. It depends how you create your array. If you create the array via Joined List → Split text, then pass tha…

🥇🥈🥉 Convert Number Score to Rankings in Glide!

Community Resources

Robert_Petitto November 7, 2021, 11:53pm 4

Make this adjustment in order to have your list items “tie” for rank values without skipping ranks:

2 Likes

Topic		Replies	Views
RANK VIA New data columns Ask for Help	15	1532	November 9, 2021
Issues of Ranks in Leaderboard Ask for Help	11	942	January 23, 2023
How to Rank High to Low numbers from 1st to 10th etc Ask for Help	4	676	April 4, 2022
Rank Date Ask for Help custom-code	45	1803	August 20, 2021
Ranking dentro do aplicativo Ask for Help	5	210	January 1, 2024

🥇🥈🥉 Convert Number Score to Rankings in Glide!

Related topics