# \[Solved\] Getting the Row number of a particular name in Name Column of Airtable
**URL:** https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257
**Category:** Questions about Thunkable X
**Tags:** solved, lists, airtable
**Created:** [June 14, 2019, 1:49pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257 "2019-06-14T13:49:55Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@kartik\_old](https://community.thunkable.com/u/kartik_old)
#### Post date: [June 14, 2019, 1:49pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/1 "2019-06-14T13:49:55Z")
Hello,
I want to get the **Row Number** of a Particular Name in the **Name** column…
More clearly, searching every item in column named **Name** , and if item = User’s Name (variable), then get it’s row number and store it in a variable…
Thanks😄
---
### Author:  [@jane](https://community.thunkable.com/u/jane)
#### Post date: [June 14, 2019, 3:56pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/2 "2019-06-14T15:56:31Z")
Hi there,
If you use the **Get Column** block to get a Column from AirTable, you can use the following block to get the location of a given item in the list:
Where the sample list is your Column.
If the name you’re searching for isn’t on the list, it will return 0.
Are your users guaranteed to have different user names?
---
### Author:  [@kartik\_old](https://community.thunkable.com/u/kartik_old)
#### Post date: [June 14, 2019, 3:57pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/3 "2019-06-14T15:57:13Z")
Yes.
If repeated, I may prefer using ID column…
---
### Author:  [@jane](https://community.thunkable.com/u/jane)
#### Post date: [June 14, 2019, 4:00pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/4 "2019-06-14T16:00:06Z")
Great! As long as each user has a unique name or ID, this block should work for you. 🙂
---
### Author:  [@kartik\_old](https://community.thunkable.com/u/kartik_old)
#### Post date: [June 14, 2019, 4:00pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/5 "2019-06-14T16:00:53Z")
Thanks again!
---
### Author:  [@eoinparkinson](https://community.thunkable.com/u/eoinparkinson)
#### Post date: [May 30, 2020, 10:47pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/6 "2020-05-30T22:47:02Z")
Hi,
> [@jane](#):
>
> If you use the **Get Column** block to get a Column from AirTable, you can use the following block to get the location of a given item in the list:
> 
>
> Where the sample list is your Column.
### This was always my go to method and worked flawlessly, but since today it does not appear to be working as it should.
### This should return my Surname, “Parkinson”. Instead it displays a blank white screen, which crashes the app, both native and web.
–
Now changing the **rowNum** to an actual number, in this case my Forename is present in #3 of the list, it returns my second name perfectly.
I’ve tried using math blocks to add zero to it to force it to be an integer but I’ve had no luck. I wanted to just double check here before I go to GitHub.
### Thanks.
# (edit)
It appears changing **maxNumRows** in the GetColumn block to a large number (bigger than the length of the column) shows it working. **I’ve never had this problem before**. I’ve had no issues using the _infinity_ block either with this.
Curious to know was this changed?
---
### Author:  [@ozel1978](https://community.thunkable.com/u/ozel1978)
#### Post date: [November 3, 2020, 4:31am UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/7 "2020-11-03T04:31:55Z")
eoin,
surname is one of value in column forename?
---
### Author:  [@eoinparkinson](https://community.thunkable.com/u/eoinparkinson)
#### Post date: [November 3, 2020, 7:41am UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/8 "2020-11-03T07:41:13Z")
Hi, yes I had this set wrong too however there was still something weird happening with Airtable at the time. I’ve had no trouble since with this component.
Thanks!
---
### Author:  [@ozel1978](https://community.thunkable.com/u/ozel1978)
#### Post date: [November 3, 2020, 3:49pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/9 "2020-11-03T15:49:40Z")
thanks a lot. i am looking something like this but let me try if it was what i imagined.
---
### Author:  [@ozel1978](https://community.thunkable.com/u/ozel1978)
#### Post date: [November 7, 2020, 2:47am UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/10 "2020-11-07T02:47:30Z")
eoin,
i try to get something similiar but my block does not seem right.
i want get list of number (column) base on other status (column) which is contain “Register” and want to list it at listviewer.
here is my block.
---
### Author:  [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)
#### Post date: [November 8, 2020, 12:37pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/11 "2020-11-08T12:37:43Z")
What if i they dont?
I need to get different values from a column where the same name might be shown.
---
### Author:  [@nppvice](https://community.thunkable.com/u/nppvice)
#### Post date: [December 25, 2020, 7:10pm UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/12 "2020-12-25T19:10:30Z")
Any improvement with this? I just rann into same problem. Cells not updating. see attached image of blocks.
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:28am UTC](https://community.thunkable.com/t/solved-getting-the-row-number-of-a-particular-name-in-name-column-of-airtable/106257/13 "2024-11-08T11:28:53Z")