# How do you use air table to target a particular cell

**URL:** <https://community.thunkable.com/t/how-do-you-use-air-table-to-target-a-particular-cell/63450>\
**Category:** Questions about Thunkable X\
**Created:** [January 6, 2019, 7:16am UTC](https://community.thunkable.com/t/how-do-you-use-air-table-to-target-a-particular-cell/63450 "2019-01-06T07:16:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Loh\_Jordan](https://avatars.discourse-cdn.com/v4/letter/l/b19c9b/32.png) [@Loh\_Jordan](https://community.thunkable.com/u/Loh_Jordan)\
**Post date:** [January 6, 2019, 7:16am UTC](https://community.thunkable.com/t/how-do-you-use-air-table-to-target-a-particular-cell/63450/1 "2019-01-06T07:16:55Z")

</div>

I have an air table that have user name and email.  
I am going to search the user name by the email.  
How can i do it?  
I am new here and appreciate your help on this thanks.

 ![27%20PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/9/e96568a39fffd45f4a0941665a8e7b5cd44ddb6d.png)

---

<div class="post-metadata">

**Author:** ![Michael\_Rogulla](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@Michael\_Rogulla](https://community.thunkable.com/u/Michael_Rogulla)\
**Post date:** [January 6, 2019, 6:10pm UTC](https://community.thunkable.com/t/how-do-you-use-air-table-to-target-a-particular-cell/63450/2 "2019-01-06T18:10:56Z")

</div>

Hi @Loh_Jordan, here is how I do the trick:

- first get a whole column from Airtable and put the result into a list.
- then perform with the build-in-function a search onto the list. As a result you get index = “0” that means item is not in the list or you get an index \> 0
- second get the row from Airtable with the index from step one. From the row you can access the item by name, see my example (I looked for the column with name “URL”).

Here is a screenshot, I tested it some minutes ago (you should of course check for “index \> 0?” before calling airtable.getRow)…

 ![GetData2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/2/6222fbcf3e5284930541baa584ab140f18d866d7.png)

---

<div class="post-metadata">

**Author:** ![Loh\_Jordan](https://avatars.discourse-cdn.com/v4/letter/l/b19c9b/32.png) [@Loh\_Jordan](https://community.thunkable.com/u/Loh_Jordan)\
**Post date:** [January 8, 2019, 12:45am UTC](https://community.thunkable.com/t/how-do-you-use-air-table-to-target-a-particular-cell/63450/3 "2019-01-08T00:45:31Z")

</div>

Thank it help me a lot.

---

<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:16pm UTC](https://community.thunkable.com/t/how-do-you-use-air-table-to-target-a-particular-cell/63450/4 "2024-11-08T12:16:31Z")

</div>