Need some pointers on a leaderboard

[CoachTom]

OK - we got our Purple Pizza Eater game going and now we have some users. So now we want to create a leaderboard so that people anywhere (we even have testers in India) who get a high score can enter their usernames and scores and they will go into a database that will automatically rank them by score and show their username and score along with the top 5 users and scores.

I have just started experimenting with TinyWebDB but I dont see how to associate usernames with scores and automatically order that list. Any pointers?

[Alpha2020]

I would be good to use CloudDB or Firebase

[CoachTom]

ok, but how would you do automated list ordering of paired objects?

[SteveJG]

There is a plethora of advice about how to use a leaderboard with various database options See https://community.appinventor.mit.edu/search?q=leaderboard . Pick one. for ideas.

Exactly what you need to do depends on your existing code. You have not shared that with the community so look through the links; there is probably something appropriate for your Project.

[CoachTom]

OK, thanks - I tried a bunch of other searches but not leaderboard

[ABG]

Also see

How to share Top Ten Daily Scores in TinyWebDB

max_score_TinyWebDB How to share Top Ten Daily Scores in TinyWebDB Abe Getzler April 2020 How to share Top Ten Daily Scores in TinyWebDB Background The App The shared update problem A practical approach to a solution Designer Blocks Screen1.Initialize TWDBInitialRead.GotValue Category Global category_key Global scores_key Default_webreturn Global web_return_dict Display Scores Global score_labels and name_labels When btnAdd.Click TWBDBReadForUpdate.GotValue set_Category up…

[CoachTom]

Hey great - this should get me going - thanks

[TIMAI2]

For firebase:

How to Create a Scoreboard

Without going into the blocks: Firebase data (WordZazzle at root): [image] Firebase Rules: "rules:" { "WordZazzle": { ".read": true, ".indexOn": ".value" } } Web Url: https:///<FirebaseURL>/WordZazzle.json?orderBy="$value"&limitToLast=3 responseContent (returns the top three, but NOT in order): { "Lini": "\"123456\"", "Thivia": "\"1234\"", "Tia": "\"12345\"" } You will then have to get the responseContent into a list or dictionary and sort by the scores