# \[Solved\] Query a field on Airtable

**URL:** https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687
**Category:** Questions about Thunkable X
**Tags:** solved
**Created:** [June 28, 2020, 9:05am UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687 "2020-06-28T09:05:30Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![aiasp](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@aiasp](https://community.thunkable.com/u/aiasp)
#### Post date: [June 28, 2020, 9:05am UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/1 "2020-06-28T09:05:30Z")

</div>

Hello,

i use Airtable for my sport club,

i need to do something like this: “Select DOB where SURNAME is (variable) from Athlets”

and save this value (name) into a variable.

How can i select only one field ?

Thanks !!!  
Guido

---

<div class="post-metadata">

### Author: ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)
#### Post date: [June 28, 2020, 10:50am UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/2 "2020-06-28T10:50:56Z")

</div>

Hi, @aiasp! 👋

> [@aiasp](#):
>
> “Select DOB where SURNAME is (variable) from Athlets”

What does _ **Athlets** _ mean here? Is it the Table Name?

* * *

We can achieve this through a loop-check. More clearly, looping through all rows, and checking if _ **SURNAME = something** _.

Thanks!

---

<div class="post-metadata">

### Author: ![aiasp](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@aiasp](https://community.thunkable.com/u/aiasp)
#### Post date: [June 28, 2020, 12:31pm UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/3 "2020-06-28T12:31:24Z")

</div>

yes, athlets is the table name

---

<div class="post-metadata">

### Author: ![aiasp](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@aiasp](https://community.thunkable.com/u/aiasp)
#### Post date: [June 28, 2020, 1:08pm UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/4 "2020-06-28T13:08:21Z")

</div>

![Schermata 2020-06-28 alle 15.06.12](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/d/4dacff5be6106f970cc785aea248ae7f8ec54534.png)

I don’t know if i do right.

GetRow is used on DB “Airtable1” and not on the Table AThlets i want to query. ??

---

<div class="post-metadata">

### Author: ![aiasp](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@aiasp](https://community.thunkable.com/u/aiasp)
#### Post date: [June 30, 2020, 10:00am UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/5 "2020-06-30T10:00:06Z")

</div>

Hi, i’m not able to do it… can u help me ? i pay…☹

---

<div class="post-metadata">

### Author: ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)
#### Post date: [June 30, 2020, 12:41pm UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/6 "2020-06-30T12:41:45Z")

</div>

Hi, @aiasp! 👋  
Sorry for late reply, I was busy here 😐

I think this should work for you :

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/a/0a960f043af522921a193f390a2e00e8b64d6ecb.png)

* * *

> [@aiasp](#):
>
> GetRow is used on DB “Airtable1” and not on the Table AThlets i want to query. ??

Since you’ve set the TableName in Designer properties of Airtable component, it will do all the tasks on that specific Table only.

I hope I helped you 😺

---

<div class="post-metadata">

### Author: ![aiasp](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@aiasp](https://community.thunkable.com/u/aiasp)
#### Post date: [June 30, 2020, 12:44pm UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/7 "2020-06-30T12:44:03Z")

</div>

ah ok Thanks ! But it works only on one table ? if i need to query on other one in another screen ?

---

<div class="post-metadata">

### Author: ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)
#### Post date: [June 30, 2020, 12:45pm UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/8 "2020-06-30T12:45:02Z")

</div>

If so, best procedure would be grabbing another Airtable Component, and setting it to a different Table Name.

Thanks! 😺

---

<div class="post-metadata">

### Author: ![aiasp](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@aiasp](https://community.thunkable.com/u/aiasp)
#### Post date: [June 30, 2020, 12:46pm UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/9 "2020-06-30T12:46:48Z")

</div>

ah ok ! more Airtables on the table ! Love it i try

---

<div class="post-metadata">

### Author: ![benoitdeguffroy](https://avatars.discourse-cdn.com/v4/letter/b/f08c70/32.png) [@benoitdeguffroy](https://community.thunkable.com/u/benoitdeguffroy)
#### Post date: [April 9, 2021, 6:43pm UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/10 "2021-04-09T18:43:04Z")

</div>

intresting

---

<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:25am UTC](https://community.thunkable.com/t/solved-query-a-field-on-airtable/641687/11 "2024-11-08T11:25:16Z")

</div>


