# Using Airtable or spreadsheets

**URL:** https://community.thunkable.com/t/using-airtable-or-spreadsheets/24252
**Category:** Questions about Thunkable X
**Created:** [April 29, 2018, 5:30am UTC](https://community.thunkable.com/t/using-airtable-or-spreadsheets/24252 "2018-04-29T05:30:25Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Stacy\_Elliott](https://avatars.discourse-cdn.com/v4/letter/s/22d042/32.png) [@Stacy\_Elliott](https://community.thunkable.com/u/Stacy_Elliott)
#### Post date: [April 29, 2018, 5:30am UTC](https://community.thunkable.com/t/using-airtable-or-spreadsheets/24252/1 "2018-04-29T05:30:25Z")

</div>

So I have created an Airtable and I can create a row with CreateRow with two columns “Name” and “Score” where each row will be created when someone logs in.

I will need the program to check to see if they are already on the spreadsheet, and Im not sure how to go about that.

And Even if I got that part done, I’m not sure how to find the row that they are saved in so I can then grab their score for use.

Everything I have read all refer to the RowObject or the Row. Ive tried to make a lable dispay the row during the creation of the row but it simply says object, Object. Nothing more.

In my Airtable I see the new rows being created when they login but Ill be damned if I can figure out how to determine the Row so I can use it to index the spreadsheet to read the correct column.

Any help would be appreciated

---

<div class="post-metadata">

### Author: ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)
#### Post date: [April 29, 2018, 7:05am UTC](https://community.thunkable.com/t/using-airtable-or-spreadsheets/24252/2 "2018-04-29T07:05:11Z")

</div>

Hi,

To determine the row in the table, the algorithm is as follows:

1. Using the Spreadsheet.getAllRows method, we get a list of objects.
2. Create a loop from this list and compare the value of the key field (Name) of the object with the new value. If these values ​​match, then the row is already in the table.

As a basis you can take this example.

 ![rowExists](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/4/b42a67a4f9e75aa741561655a052c845e4828fcf.png)

It’s easier to do this if you want to check one column at a time. If there are no matches, it will return 0.

 ![lib_findIndex](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/6/26a59be25a91e58b2aff323db527119f99dff4c3.png)

---

<div class="post-metadata">

### Author: ![suportenetweb](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@suportenetweb](https://community.thunkable.com/u/suportenetweb)
#### Post date: [July 22, 2019, 11:08pm UTC](https://community.thunkable.com/t/using-airtable-or-spreadsheets/24252/3 "2019-07-22T23:08:10Z")

</div>

> [@actech](#):
>
> It’s easier to do this if you want to check one column at a time. If there are no matches, it will return 0.

28/5000

Let me know the whole code?

---

<div class="post-metadata">

### Author: ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)
#### Post date: [July 23, 2019, 8:35am UTC](https://community.thunkable.com/t/using-airtable-or-spreadsheets/24252/4 "2019-07-23T08:35:59Z")

</div>

An example of working with AirTable on the scrAirTable screen

[https://x.thunkable.com/projects/5cd84f23e3097f3353fdad45/project/properties/designer/](https://x.thunkable.com/projects/5cd84f23e3097f3353fdad45/project/properties/designer/)

---

<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, 12:03pm UTC](https://community.thunkable.com/t/using-airtable-or-spreadsheets/24252/5 "2024-11-08T12:03:54Z")

</div>