Create a score ranking for an app

[Anonymous]

Hello everyone,

I've created a quiz app, where the user answer 5 random questions and get one point per right answer. Now, I need a ranking system at the end of the app, where he can se his score and the score of the other users, sorted by points scored, from highest to lowest. Also, the user can answer this quiz more than one time (I would like to block the access to five times, but I think this is not possible), so I would need to add points to his rank if he participated more than one time. How can I create this ranking screen? Is it possible? 

[Gochix]

Hi @Anonymous ,

Do you need to see the scores after the person completed the quiz or already showing up the current score through the quiz?

'I would like to block the access to five times, but I think this is not possible' - This is possible. You can add another column to your datasource for example lets call it "QuizCount".
Now you could check before entering the quiz if person has 5 in the columns "QuizCount" then disable entrance to that quiz or hide it at all. If under 5 then each time person completes the quiz then update "QuizCount" +1.

Sample of your score label :

LookUp('DataSource',name = User().FullName,Score)

Sample of Top 5 score :

Add new gallery and set Items properties.

Sort(FirstN('DataSource',5),Score,Descending)

[Anonymous]

I would like to show the scores after the person finished the quiz, showing all the users who answered and their scores. Also, thank you for answering the other doubt I had

[Gochix · Accepted solution]

OnSelect property of your submit button for quiz -

Set(varScores, true)

on "Visible" property of your gallery, set:

varScores

[Anonymous]

Ok, and how can I display the scoreboard at the end screen? 

[v-jefferni]

Hi @Anonymous ,

Do you have any data sources to store all the scores, like an Excel table? If you have, you can use a Gallery with it's Items set to this table, sort by the score column. If you don't, it's not possible for a user to see other's scores. The table structure need to be as follows:

ID	Name	Score	TimeOfAnswer

However, with a data source, you will need to give access to all the users who will use this app. 

Best regards,

[Anonymous]

Thank you for the answer! Yes, I do have an excel table for this. At first, I didn't understand the previous answer from @Gochix , because I didn't have the knowledge about galleries. I searched about that and my ranking is working, so my app is finished and ready to use! 

[Anonymous]

Can you help me granting access to everyone? I made the data source through a sharepoint list