Hello, i built a quiz game with a leader board inside that the players can check the top 10 scores.
What i have:
My problem is if the score is bigger than his personal best it adds the record to the base but at the same time keeps the previous score inside and having for example:
how do you know that row no 20 is the exact row not of that user?
The row 20 is an empty row and out of my top 10 leaderboard so i just put the record here and airtable sort it where it should be.
no you have to create a method first to check user record, and then just compare if score is > than privious then update, this block with and option will not work as good, use if not is empty username, then if score is > old score than update row ( index of username in list all username)
Oh you understood my point! That’s my problem.
How i’ll find that username index?
first use get column for user name, when got column, store all username to a list, and then use that,
Perfect. That worked well!!
Thank you very much!! 
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
