# Call row in airtable

**URL:** <https://community.thunkable.com/t/call-row-in-airtable/2331304>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [March 18, 2023, 3:48pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304 "2023-03-18T15:48:31Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [March 18, 2023, 3:48pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/1 "2023-03-18T15:48:31Z")

</div>

Hi All,

How to call whole row in airtable base on specific id? for example email address.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [March 18, 2023, 3:52pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/2 "2023-03-18T15:52:57Z")

</div>

Use filterByFormula with the Airtable API. You can Google it or search here on the forums for it.

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [March 18, 2023, 4:26pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/3 "2023-03-18T16:26:47Z")

</div>

is there any simple way rather than API? because my app is very easy.

1. user will login using firebase authentication. after successfully login will route to profile page
2. in profile page it call row from airtable that match unique id as my case using email address.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [March 18, 2023, 7:34pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/4 "2023-03-18T19:34:46Z")

</div>

Sure. The API is just the most flexible, powerful, and fast way to get Airtable data. But if you want to keep things simple, you can use the Get Row Object block shown at [Data Sources - Thunkable Docs](https://docs.thunkable.com/data-sources#read). Then use `Get Property of Object` blocks to get specific column data.

But I wouldn’t do it that way. I would get a _column_ and search it for the ID value you want. Can you say a little more about what you’re wanting to do? The approach I’d take depends on whether or not you have duplicate ID values in a column and if you just want the first/only occurrence or every occurrence of that ID value.

---

<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:** [March 20, 2023, 1:54pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/5 "2023-03-20T13:54:04Z")

</div>

Hello @ozel1978

In order to connect Airtable data with a user, you will need to store the Row id that you get when you create a new row on Airtable.

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

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

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7e22c9eb63baea4c0a09947be3098e8452d922b3.png)

Let us know if you have any other questions going forward!

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [March 20, 2023, 2:15pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/6 "2023-03-20T14:15:45Z")

</div>

this is all in one page?

---

<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:** [March 20, 2023, 2:23pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/7 "2023-03-20T14:23:16Z")

</div>

this depends on your app, on my app I have sign in and sign up on the same page and in another page the third screenshot

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [March 20, 2023, 2:33pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/8 "2023-03-20T14:33:07Z")

</div>

this is my login page and for unique id, i create as variable so when it move to next page that variable will search in airtable for certain column and display whole row that belong to variable.

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/c/dcb97c8d52a1b0af07838352077dd6fe07f4c8d6.png)

if my design fit with your block?

---

<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:** [March 20, 2023, 4:48pm UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/9 "2023-03-20T16:48:45Z")

</div>

@ozel1978 I understand your concern.  
In order to update the rows on AirTable, you need to save the row id into one field when you create these rows.  
Then you can update them using this block  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7e22c9eb63baea4c0a09947be3098e8452d922b3.png)

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [March 25, 2023, 4:35am UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/10 "2023-03-25T04:35:02Z")

</div>

ioannis

thank you for your help. i will try to implement this block to my page.

---

<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 23, 2023, 4:35am UTC](https://community.thunkable.com/t/call-row-in-airtable/2331304/11 "2023-06-23T04:35:54Z")

</div>

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