# How to search in airtable? **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [May 3, 2019, 6:12pm UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760 "2019-05-03T18:12:03Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Julia\_Milan](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@Julia\_Milan](https://community.thunkable.com/u/Julia_Milan)\ **Post date:** [May 3, 2019, 6:12pm UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/1 "2019-05-03T18:12:03Z")
Hello, I have a one column spreadsheet with ID values and what I would like to do is: 1 - Make sure the text (from text input1) is equal to one of the IDs in the spreadsheet 2 - Then, save this number in local storage The problem is, I don’t know how to fill the row number in the “GetCell” Block (or if I’m doing this right) Can someone help me, please? ![aaaaaaa](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/7/176059626f73603b9ae9c380f04d7215ea09cd3b.png) ---
**Author:** ![Tabet\_Mohammed](https://avatars.discourse-cdn.com/v4/letter/t/8dc957/32.png) [@Tabet\_Mohammed](https://community.thunkable.com/u/Tabet_Mohammed)\ **Post date:** [May 3, 2019, 8:58pm UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/2 "2019-05-03T20:58:26Z")
Hi Try to copy the column data in a list. then you can compare your input with the list values. good luck ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [May 4, 2019, 7:24am UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/3 "2019-05-04T07:24:31Z")
Hello, an example of searching and filtering data from AirTable can be found on the scrAirTable screen in the project [https://x.thunkable.com/projects/5cc9570f7e2a78259a8c0a78/project/properties/designer/](https://x.thunkable.com/projects/5cc9570f7e2a78259a8c0a78/project/properties/designer/) ---
**Author:** ![Julia\_Milan](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@Julia\_Milan](https://community.thunkable.com/u/Julia_Milan)\ **Post date:** [May 5, 2019, 12:53am UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/4 "2019-05-05T00:53:57Z")
I tried this way, but still doesn’t work ☹ ![Imagem1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/9/893c2921864b5eb6d27e8699260cec1933768348.png) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [May 5, 2019, 8:36am UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/5 "2019-05-05T08:36:33Z")
You want to say that my example does not work at all and does not find anything in the list? Let’s figure it out together. You opened my project (no need to click remix!) on your device and went to the AirTable screen. Do you see the data in the list? ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/c/dcdc11c01a7e04276520c9def46befc53e898f7e.png) If you see this data, then you click on the button and do not get the screens below? ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/d/7d0cf04c1a395d730152e4ac22518a46277712e0.png) or ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/5/9539334c0f40348c45fa5775a9b97998217f6347.png) ---
**Author:** ![Julia\_Milan](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@Julia\_Milan](https://community.thunkable.com/u/Julia_Milan)\ **Post date:** [May 5, 2019, 3:49pm UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/6 "2019-05-05T15:49:29Z")
Now I understand, it worked I follow your example and put the blocks in a similar way, so if the text typed in TextInput is equal to a value in spreadsheet the app navigate to another screen, Thank you very much 😊 Here’s what it looks like: ![656565656](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/f/2f183fc7ed8c341b643db3c0242929df8f510ca6.jpeg) ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 20, 2020, 5:23am UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/7 "2020-10-20T05:23:54Z")
Julia, if i can ask. 1)what is CPF? it refer to column name at airtable? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7e1ccc01eb0ac502a81dcb6e96365dd0b5c8301d.png) 2)when you navigate to CPF2 screen. how screen block look like?if you can share that would be appreciated. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 20, 2020, 2:09pm UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/8 "2020-10-20T14:09:02Z")
Yes, the property of the row object (“CPF”) would be the column name. ---
**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:13pm UTC](https://community.thunkable.com/t/how-to-search-in-airtable/75760/9 "2024-11-08T12:13:50Z")