How do you use air table to target a particular cell

Questions about Thunkable
1

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
27%20PM894×582 38.2 KB

2

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
GetData2896×681 56.6 KB

1 Like
3

Thank it help me a lot.