# Listview and Spreadsheet for Search and Item Click - Airtable **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [November 1, 2018, 6:42pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650 "2018-11-01T18:42:14Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![doctorsof](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/doctorsof/32/30099_2.png) [@doctorsof](https://community.thunkable.com/u/doctorsof)\ **Post date:** [November 1, 2018, 6:42pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/1 "2018-11-01T18:42:14Z")
When i click list view item not going next colum’s row from Airtable (I have 3 columns) ![1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/9/a91872f5139e5e8fad893f3eb26fb7a67172aa5a.png) ![2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/6/c64ea8506ea43f20001496bba381cdf07849b403.png) When i was a writing text not seeing our listview (search textinput) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [November 1, 2018, 6:50pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/2 "2018-11-01T18:50:31Z")
Sorry, but I did not understand what you are doing. Can you tell us more about what you need to do? Do you have AirTable and you need to find something in it or get the value of some field? ---
**Author:** ![doctorsof](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/doctorsof/32/30099_2.png) [@doctorsof](https://community.thunkable.com/u/doctorsof)\ **Post date:** [November 1, 2018, 7:06pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/3 "2018-11-01T19:06:06Z")
I have Airtable. I need to find something in it and get the value of some field. ![3](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/9/d9d9109493d66c6766d512b5769dbcce898641e6.png) This blocks have two mission. Firstly i want to search name’s colon after than user click searched value go to notes column and click again info column. (same row you know) For example: When i writing “ew” listview will see Name’s colon row number 7 after than i will click that item \> notes column row 7 seeing “ttt” \> i click again this ttt value seeing info column row 7 that “rrr” ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [November 1, 2018, 7:18pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/4 "2018-11-01T19:18:29Z")
I correctly understood what needs to be done like this: on the screen you have one input field and one empty ListViewer. In the input field you enter “ew” and one item should appear in the ListViewer - “ewrwer”. After that, you click “ecrwer” and one list “ttt” should appear in the ListViewer. After that you press “ttt” and in the ListViewer should appear one element “rrr”? ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [November 1, 2018, 7:31pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/5 "2018-11-01T19:31:35Z")
One solution: 1. First you load the entire AirTable to the list 2. After that, in the loop for this list, search for the desired row - it will be an object with all the necessary fields. You have an object, which means that you can get any value of any of its fields, which can then be displayed in the ListViewer. ---
**Author:** ![doctorsof](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/doctorsof/32/30099_2.png) [@doctorsof](https://community.thunkable.com/u/doctorsof)\ **Post date:** [November 1, 2018, 7:51pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/6 "2018-11-01T19:51:07Z")
I don’t know how can do that for Blocks? ---
**Author:** ![doctorsof](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/doctorsof/32/30099_2.png) [@doctorsof](https://community.thunkable.com/u/doctorsof)\ **Post date:** [November 2, 2018, 5:55pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/7 "2018-11-02T17:55:12Z")
![stars](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/a/6a16629c5377e487311a5371df480db842c8756b.png) I added when stars seein listview. But i click listview not going on. When i was search after than click thats ok. ---
**Author:** ![ariefakmal2605i4w](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@ariefakmal2605i4w](https://community.thunkable.com/u/ariefakmal2605i4w)\ **Post date:** [December 16, 2019, 3:34pm UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/8 "2019-12-16T15:34:22Z")
may i know that u solve this/…coz i want to learn this type of block ---
**Author:** ![doctorsof](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/doctorsof/32/30099_2.png) [@doctorsof](https://community.thunkable.com/u/doctorsof)\ **Post date:** [December 19, 2019, 11:27am UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/9 "2019-12-19T11:27:37Z")
i solved but it is little complicated. You can create number column and add numbers into this column. Your mark will be this number. This solution is working hard i have no idea basic solution. ---
**Author:** ![ariefakmal2605i4w](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@ariefakmal2605i4w](https://community.thunkable.com/u/ariefakmal2605i4w)\ **Post date:** [December 20, 2019, 12:20am UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/10 "2019-12-20T00:20:12Z")
Owhh…so if i got 300 column…i need 300 block right? ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [December 20, 2019, 8:27am UTC](https://community.thunkable.com/t/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/11 "2019-12-20T08:27:12Z")
I think that you yourself can answer this question. If the database has 300,000 columns, do you need to create 300,000 blocks? ---
**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/listview-and-spreadsheet-for-search-and-item-click-airtable/54650/12 "2024-11-08T11:46:16Z")