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😄

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: [firstoccurence] 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 g…

Yes. If repeated, I may prefer using ID column…

Great! As long as each user has a unique name or ID, this block should work for you. :slight_smile:

Hi, [image] 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: [firstoccurence] Where the sample list is your Column. This was always my go to method and worked flawlessly, but since today it…

eoin, surname is one of value in column forename?

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!

thanks a lot. i am looking something like this but let me try if it was what i imagined.

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. [image] [image]

What if i they dont? I need to get different values from a column where the same name might be shown.

Any improvement with this? I just rann into same problem. Cells not updating. see attached image of blocks. [Screenshot_113]

[Solved] Getting the Row number of a particular name in Name Column of Airtable

Questions about Thunkable

kartik_old June 14, 2019, 4:00pm 5

Thanks again!

3 Likes

Topic		Replies	Views
Airtable Find row number based on text input Questions about Thunkable	5	1292	November 8, 2024
[Solved] Help with the Airtable Questions about Thunkable solved	5	510	November 8, 2024
[Solved] Get names from Airtable list Questions about Thunkable solved	14	793	November 8, 2024
After recent changes in airtable I can't find row number anymore Questions about Thunkable	22	1223	November 8, 2024
[Solved] How do I get row number from Airtable? Questions about Thunkable solved	14	5527	November 8, 2024

[Solved] Getting the Row number of a particular name in Name Column of Airtable

Related topics