I have a table that contains my users, and their current balance of chips in a casino. I’m building a leaderboard that will tell them who the top five chip holders are. (This is the easy part.)
I also want to tell them what place THEY are in, if they’re not in the top five. This requires one of two solutions:
- Grab all of the data, and iterate through it until I find the user. This is a heavy operation, because I’d have to pull all of the user data to my application before iterating through all of it.
- Have a ranked column that automatically updates every time that a user’s balance changes, much like Lookup, Rollup, or Formula fields. This is my preferred approach, but I can’t figure out how to do this.
Do any of you amazing people have some guidance or advice? Thanks!