# Creating a local leaderboard using user input names + score

**URL:** <https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [March 25, 2024, 9:59pm UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302 "2024-03-25T21:59:11Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![30176229rbm](https://avatars.discourse-cdn.com/v4/letter/3/f9ae1b/32.png) [@30176229rbm](https://community.thunkable.com/u/30176229rbm)\
**Post date:** [March 25, 2024, 9:59pm UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/1 "2024-03-25T21:59:11Z")

</div>

Hi, Im pretty new to thunkable and been using it for college to create a app of my choice. I decided on a game app, and want to be able to have a user input their name, store it, work their way through the quiz using my data spreadsheet, then display the score at the end with their name, but have a button to display a local leader board where I can have the stored users names + scores. Yet, I am able to create the score system using a couple of tutorials, but the user input and another post mention lists is completely throwing me off… Any help is much appreciated. Ill share my project so far so you can see the blocks already. Thanks all !

[https://x.thunkable.com/copy/851f9c3fd4f4151c09367daac148ad31](https://x.thunkable.com/copy/851f9c3fd4f4151c09367daac148ad31)

Self Edit: After testing, the set score is out of 16, but even if i get every correct answer the store is always 10? Not sure what thats about 😅

---

<div class="post-metadata">

**Author:** ![ymaheswari52625y](https://avatars.discourse-cdn.com/v4/letter/y/a87d85/32.png) [@ymaheswari52625y](https://community.thunkable.com/u/ymaheswari52625y)\
**Post date:** [March 26, 2024, 6:52am UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/2 "2024-03-26T06:52:25Z")

</div>

![Screenshot (13)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/d/ddfca18f5baaec1bea44a0df82a769313fbda196.png)  
 ![Screenshot (14)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/7/c7fbae608277ad918cf660ba961f021144b5010b.png)  
 ![Screenshot (15)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/7/97f0093460fd9920dae41910b921d07e3006eee5.png)  
 ![Screenshot (16)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/0/201d925a6b08d8fb8727f98619f1fc6303c424b6.png)  
Copy project:-  
[https://x.thunkable.com/copy/d9c52e97f8cf9f641924d9304fc4e31f](https://x.thunkable.com/copy/d9c52e97f8cf9f641924d9304fc4e31f)  
Change Data in Your Spreadsheet and  
Test it

---

<div class="post-metadata">

**Author:** ![ymaheswari52625y](https://avatars.discourse-cdn.com/v4/letter/y/a87d85/32.png) [@ymaheswari52625y](https://community.thunkable.com/u/ymaheswari52625y)\
**Post date:** [March 26, 2024, 6:55am UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/3 "2024-03-26T06:55:38Z")

</div>

Add 10 more question in your spreadsheet

---

<div class="post-metadata">

**Author:** ![30176229rbm](https://avatars.discourse-cdn.com/v4/letter/3/f9ae1b/32.png) [@30176229rbm](https://community.thunkable.com/u/30176229rbm)\
**Post date:** [March 26, 2024, 10:26am UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/4 "2024-03-26T10:26:12Z")

</div>

Thanks for the help,

What you changed will fix the counting problem? Ive noticed also there is a huge delay sometimes when pulling from the spreadsheet. It will just not update the question or answers, or just not at all so i cant even complete it to see the score!

How would I go about the storing of user name and score and displaying on an end page? I completely forgot to even add the leaderboard screen at the end, but ive done that now.

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [March 26, 2024, 10:45am UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/5 "2024-03-26T10:45:05Z")

</div>

If you just use a real database intended for this kind of ordering, you could easily do this. Heck, even airtable is better than trying to use google sheets for this.

You can use the api blocks to easily grab data and in the same step tell the server to return the data ordered and to limit to the top 10 results.

---

<div class="post-metadata">

**Author:** ![30176229rbm](https://avatars.discourse-cdn.com/v4/letter/3/f9ae1b/32.png) [@30176229rbm](https://community.thunkable.com/u/30176229rbm)\
**Post date:** [March 26, 2024, 4:16pm UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/6 "2024-03-26T16:16:32Z")

</div>

Ah okay, Id rather use google sheets since im using that already. People were taking about using variables or just using fire something or other externally. I was only going to do the top 3 scores, its not a massive project and should probably be simpler than it already is but im commited.

Do you have a step by step on how to do this? as well as the block code Ill need. Im super struggling here haha

I appreciate the reply!

---

<div class="post-metadata">

**Author:** ![ymaheswari52625y](https://avatars.discourse-cdn.com/v4/letter/y/a87d85/32.png) [@ymaheswari52625y](https://community.thunkable.com/u/ymaheswari52625y)\
**Post date:** [March 26, 2024, 4:50pm UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/7 "2024-03-26T16:50:34Z")

</div>

In function, you have given number like 1 ,2 , etc and  
I have replaced them by answerbtn’s text

---

<div class="post-metadata">

**Author:** ![30176229rbm](https://avatars.discourse-cdn.com/v4/letter/3/f9ae1b/32.png) [@30176229rbm](https://community.thunkable.com/u/30176229rbm)\
**Post date:** [March 26, 2024, 9:24pm UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/8 "2024-03-26T21:24:09Z")

</div>

What do you mean? The numbers were there to represent the collums of the spreadsheet. 1-4 for each button, then with a if statement if that button is pressed then add to score?

Im not sure what you mean by what you said.

---

<div class="post-metadata">

**Author:** ![ymaheswari52625y](https://avatars.discourse-cdn.com/v4/letter/y/a87d85/32.png) [@ymaheswari52625y](https://community.thunkable.com/u/ymaheswari52625y)\
**Post date:** [March 27, 2024, 2:51pm UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/9 "2024-03-27T14:51:26Z")

</div>

[Project link](https://x.thunkable.com/copy/83edd4a1279475f6f8b951a09919c05b)  
See the project.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [June 25, 2024, 2:51pm UTC](https://community.thunkable.com/t/creating-a-local-leaderboard-using-user-input-names-score/2914302/10 "2024-06-25T14:51:33Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
