# \[Solved\] Help with the Airtable

**URL:** https://community.thunkable.com/t/solved-help-with-the-airtable/340847
**Category:** Questions about Thunkable X
**Tags:** solved
**Created:** [November 27, 2019, 3:38pm UTC](https://community.thunkable.com/t/solved-help-with-the-airtable/340847 "2019-11-27T15:38:58Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![nickolas](https://avatars.discourse-cdn.com/v4/letter/n/5e9695/32.png) [@nickolas](https://community.thunkable.com/u/nickolas)
#### Post date: [November 27, 2019, 3:38pm UTC](https://community.thunkable.com/t/solved-help-with-the-airtable/340847/1 "2019-11-27T15:38:58Z")

</div>

Hello.

I’m having a problem with Airtable when I want to select a specifc row using a name which is already registered there. It does that but always brings the last register I think because of my counter. How can I get the row number which contains the exactly name wrote in the text\_field?

This is what I did:

 ![error](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/0/70b03ef3ff2a4107ac42fc2e3ce2d121af6a2ad2.png)

---

<div class="post-metadata">

### Author: ![Sofia](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sofia/32/50160_2.png) [@Sofia](https://community.thunkable.com/u/Sofia)
#### Post date: [November 27, 2019, 3:49pm UTC](https://community.thunkable.com/t/solved-help-with-the-airtable/340847/2 "2019-11-27T15:49:29Z")

</div>

Hey  
I believe the error is in your conditional block, what you’re doing is asking if the name of your student is in the list only.  
You might want to try to find the first item that is similar with the following block:

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

In that case I get the number 5 🙂 that’s my row.

I haven’t tried this on airtables but I hope it helps!

🙂

---

<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: [November 27, 2019, 4:20pm UTC](https://community.thunkable.com/t/solved-help-with-the-airtable/340847/3 "2019-11-27T16:20:55Z")

</div>

Hi, @nickolas! 👋

The find occurrence has a bug, it doesn’t return the row number which _exactly_ matches the query.  
Since you want to search the _exact name_, try this -

> **The bug**
>
> Suppose your list is `{a,b,ab}` and you want to find `ab`. it will return you 1, and that’s not the correct answer. when it finds the first letter of the item in the list (“ **a** b”), it returns it’s position, ignoring the next letters.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/9/09767cf0d4ce81f17b07ad1b266bee4ab2804a47.png)  
(In your case, the item can be anything you desire.)

I don’t know why, but the above blocks only return the row number which exactly contains the item from the list.

If my blocks solved your problem, please mark as Solution ✅  
Thanks! 😊

---

<div class="post-metadata">

### Author: ![nickolas](https://avatars.discourse-cdn.com/v4/letter/n/5e9695/32.png) [@nickolas](https://community.thunkable.com/u/nickolas)
#### Post date: [November 27, 2019, 5:54pm UTC](https://community.thunkable.com/t/solved-help-with-the-airtable/340847/4 "2019-11-27T17:54:12Z")

</div>

Thanks for the help but, what I needed was to find the:

> [@kartik14](#):
>
> row number which _exactly_ matches the query

And @sofia solved it for me, but many thanks neverless.

---

<div class="post-metadata">

### Author: ![nickolas](https://avatars.discourse-cdn.com/v4/letter/n/5e9695/32.png) [@nickolas](https://community.thunkable.com/u/nickolas)
#### Post date: [November 27, 2019, 5:55pm UTC](https://community.thunkable.com/t/solved-help-with-the-airtable/340847/5 "2019-11-27T17:55:21Z")

</div>

Thanks for the help, I owe you one.

---

<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:46am UTC](https://community.thunkable.com/t/solved-help-with-the-airtable/340847/6 "2024-11-08T11:46:35Z")

</div>


