# Airtable in my game **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [December 7, 2019, 6:44pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603 "2019-12-07T18:44:41Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![abedo](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/abedo/32/6468_2.png) [@abedo](https://community.thunkable.com/u/abedo)\ **Post date:** [December 7, 2019, 6:44pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/1 "2019-12-07T18:44:41Z")
Hi i will talk about what i am trying to do and please tell me if it is possible to be done with Airtable Every player will have a unique username, this one i can do 🤣 Every row will have (Player Username) and (Score) Now, i want 1. When the player finishes the game, i want his score to be updated _**according to his/her (Username)**_ 2. I want to display list where every item consists of (Username) and his/her (Score) Is it possible ? and how ? ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [December 7, 2019, 7:42pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/2 "2019-12-07T19:42:37Z")
Hi, It is possible, but what causes you questions? If the name is unique, then there is no problem finding them and updating score. If the name is not unique, then this is also no problem if you use a unique key for each record. ---
**Author:** ![abedo](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/abedo/32/6468_2.png) [@abedo](https://community.thunkable.com/u/abedo)\ **Post date:** [December 7, 2019, 7:58pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/3 "2019-12-07T19:58:36Z")
How to find them by the unique username ? i really don’t now I appreciate your reply @actech ---
**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\ **Post date:** [December 7, 2019, 11:33pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/4 "2019-12-07T23:33:11Z")
This sounds like a Vlookup to me @abedo, Perhaps you can adapt this tutorial (or perhaps, start with this tutorial and the add in online storage in version 2?) > [@Performing a VLOOKUP in LocalDB](http://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057): > > One of the most powerful features in Thunkable is the new [LocalDB](https://docs.thunkable.com/thunkable-cross-platform/create/components/data/local-db) component, which allows you to insert a mini-spreadsheet directly into your app. This might be the first of a larger series of tutorials mimicking features found in other spreadsheets, but for now let’s get started with VLOOKUP. question What is VLOOKUP? A [VLOOKUP](https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1), or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row art Design Let’s start… Let me know whether or not that works for you! ---
**Author:** ![abedo](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/abedo/32/6468_2.png) [@abedo](https://community.thunkable.com/u/abedo)\ **Post date:** [December 13, 2019, 9:59am UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/5 "2019-12-13T09:59:02Z")
I appreciate your help @domhnallohanlon but unfortunately i don’t know how to apply this to the Airtable in my game especially in replacing the score of the player according to his/her username and how to make the following list (1: Username1 : Score1) (2: Username2 : Score2) . . (100: Username100 : Score100) ---
**Author:** ![DevilLooper](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/devillooper/32/53854_2.png) [@DevilLooper](https://community.thunkable.com/u/DevilLooper)\ **Post date:** [December 13, 2019, 12:49pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/6 "2019-12-13T12:49:27Z")
You can do it even not in the blocking part because airtable have a **SORT** features and **filter** it was good to use when user updates scores…im using it for almost a months, and not having a problem in leaderboard, and setting users scores that save in local storage but manage by airtable sorting features. ---
**Author:** ![abedo](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/abedo/32/6468_2.png) [@abedo](https://community.thunkable.com/u/abedo)\ **Post date:** [December 13, 2019, 12:52pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/7 "2019-12-13T12:52:36Z")
yes @DevilLooper actually i want to use airtable because i found that it will sort the table by itself. now only those two points remaining ---
**Author:** ![DevilLooper](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/devillooper/32/53854_2.png) [@DevilLooper](https://community.thunkable.com/u/DevilLooper)\ **Post date:** [December 13, 2019, 12:56pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/8 "2019-12-13T12:56:27Z")
is the **username** and **Score** are in the same table? ---
**Author:** ![abedo](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/abedo/32/6468_2.png) [@abedo](https://community.thunkable.com/u/abedo)\ **Post date:** [December 13, 2019, 12:58pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/9 "2019-12-13T12:58:14Z")
yes and the username is unique, so i want that when the user finishes game, his/her score to be updated ---
**Author:** ![DevilLooper](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/devillooper/32/53854_2.png) [@DevilLooper](https://community.thunkable.com/u/DevilLooper)\ **Post date:** [December 13, 2019, 1:02pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/10 "2019-12-13T13:02:10Z")
use the **SET Cell** of airtable blocks, to update it, you must have to use user row id you can call it when the before game start and set it to be updated when its done ---
**Author:** ![abedo](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/abedo/32/6468_2.png) [@abedo](https://community.thunkable.com/u/abedo)\ **Post date:** [December 13, 2019, 1:05pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/11 "2019-12-13T13:05:20Z")
What if during the game, other player got higher score and the order of the users have changed ? ---
**Author:** ![DevilLooper](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/devillooper/32/53854_2.png) [@DevilLooper](https://community.thunkable.com/u/DevilLooper)\ **Post date:** [December 13, 2019, 1:07pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/12 "2019-12-13T13:07:22Z")
thats the not the nice thing of airtable compare to firebase, will in that case you cant save it after the game, call the user rowID and use a loading component and say _“please waiting, im saving your score” and when u get the row ID then save it…_ ---
**Author:** ![DevilLooper](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/devillooper/32/53854_2.png) [@DevilLooper](https://community.thunkable.com/u/DevilLooper)\ **Post date:** [December 13, 2019, 1:07pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/13 "2019-12-13T13:07:59Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/4/84a6f7c785c7b280df66d9f018c32972a6c55863.png) somthing like this, but you can play with it ---
**Author:** ![DevilLooper](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/devillooper/32/53854_2.png) [@DevilLooper](https://community.thunkable.com/u/DevilLooper)\ **Post date:** [December 13, 2019, 1:13pm UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/14 "2019-12-13T13:13:08Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/e/fe905bfec143032ff30c575503e9e761420ec0e0.png) ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 11:46am UTC](https://community.thunkable.com/t/airtable-in-my-game/355603/15 "2024-11-08T11:46:23Z")