# Using Airtable to update a users "score"

**URL:** https://community.thunkable.com/t/using-airtable-to-update-a-users-score/561988
**Category:** Questions about Thunkable X
**Created:** [April 7, 2020, 8:36pm UTC](https://community.thunkable.com/t/using-airtable-to-update-a-users-score/561988 "2020-04-07T20:36:04Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![ryguyandkbockt](https://avatars.discourse-cdn.com/v4/letter/r/848f3c/32.png) [@ryguyandkbockt](https://community.thunkable.com/u/ryguyandkbockt)
#### Post date: [April 7, 2020, 8:36pm UTC](https://community.thunkable.com/t/using-airtable-to-update-a-users-score/561988/1 "2020-04-07T20:36:04Z")

</div>

Hi  
Im trying to use airtable to track and update users scores (just a number starting at 1). I am having trouble extracting and updating data based on the users email. For example, airtable requires that I update data using the row number, but I need to do it using the users email that sits within that row.

---

<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: [April 7, 2020, 8:53pm UTC](https://community.thunkable.com/t/using-airtable-to-update-a-users-score/561988/2 "2020-04-07T20:53:51Z")

</div>

Hey @ryguyandkbockt, check out this post by @domhnallohanlon

> [@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…

and one by me  
[![Screen Shot 2020-04-07 at 4.38.14 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/b/9b86bbcf732253fedf3fa4d6e769f0c8c743ef76.png)](http://jaredgibb.xyz/index.php/2020/03/29/sample-apps/)

---

<div class="post-metadata">

### Author: ![ryguyandkbockt](https://avatars.discourse-cdn.com/v4/letter/r/848f3c/32.png) [@ryguyandkbockt](https://community.thunkable.com/u/ryguyandkbockt)
#### Post date: [April 10, 2020, 3:23am UTC](https://community.thunkable.com/t/using-airtable-to-update-a-users-score/561988/3 "2020-04-10T03:23:52Z")

</div>

Doesnt the local database get wiped everytime the app closes and reopens?

---

<div class="post-metadata">

### 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:39am UTC](https://community.thunkable.com/t/using-airtable-to-update-a-users-score/561988/4 "2024-11-08T11:39:14Z")

</div>


