# (SOLVED) I need help with Airtable (searching through rows) **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [March 4, 2020, 4:06am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051 "2020-03-04T04:06:09Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 4, 2020, 4:06am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/1 "2020-03-04T04:06:09Z")
I’m trying to create a way to comment on a user-made text. My idea is to create an Airtable with two columns, the question where the comment is directed toward, and the comment. How would I search through the rows to extract only the rows based on the question, and how do I add that into the data viewer? Thank you! ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 4, 2020, 4:08am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/2 "2020-03-04T04:08:31Z")
you could search a column for the question when you find the index, that is your row number, get the cell in column two using the index of the row from column 1 ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 4, 2020, 1:34pm UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/3 "2020-03-04T13:34:37Z")
How would i search for the question? And how could I repeat the search to look through the entire list of comments? ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [March 4, 2020, 5:26pm UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/4 "2020-03-04T17:26:16Z")
![изображение](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/4/3493e7d8ca37a324a266c838b56bdd88787b4ed2.png) ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 8, 2020, 1:15am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/5 "2020-03-08T01:15:30Z")
I’ve read those but none cover how to convert an airtable into a local storage spreadsheet so i can connect it to list viewer. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 8, 2020, 1:31am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/6 "2020-03-08T01:31:40Z")
Why do you _ **need** _ to put your airtable into the localdb? Why not work with the data directly? You can absolutely connect to an airtable Base, get all rows/or a single column and pull the information you need via looping so it can be presented in a listviewer ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 8, 2020, 1:34am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/7 "2020-03-08T01:34:49Z")
The airtable has two columns, “question” and “comment”. Whenever someone submits a comment, it creates a row with the question and the comment. I then need to send it to localdb so I can filter and remove all of the comments for unrelated questions, and then send the remaining data (comments related to the question) to the data viewer ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 8, 2020, 1:48am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/8 "2020-03-08T01:48:41Z")
check this out. This is a generic example I made for your situation [https://x.thunkable.com/copy/7aa7b57343f022223c12d93cf61a33dd](https://x.thunkable.com/copy/7aa7b57343f022223c12d93cf61a33dd) ![Screen Shot 2020-03-07 at 8.32.46 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/e/0ea6d0aa41a9bfbfd05ce4a6a48060bbfa3005ee.png) Here is an example I use in my main project ![Screen Shot 2020-03-07 at 8.33.52 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/0/c0415f72b58ced78632258d3e9edef8811c2b5a2.png) you can see I filter for multiple things and then grab multiple pieces of info from the table. 3 lists are created in total from this query if this works for you, please mark this as a solution so others can reference this fix ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 8, 2020, 2:03am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/9 "2020-03-08T02:03:11Z")
Your code looks correct so I’m assuming its something on my part, but the list viewer comes out blank. (“comment-question” is just the question the comment is towards, “comment” is the comment) ![dffadasf](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/9/79c2e884ffd150ec0062a198e897b73114b70a23.png) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 8, 2020, 2:19am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/10 "2020-03-08T02:19:52Z")
if you could share a screenshot of your airable, that would be helpful to help troubleshoot. test this out with this table ![Screen Shot 2020-03-07 at 9.05.27 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/5/4541eba270175a00b60fe9bc401a79ffb45caebe.png) the code i sent works with this perfectly. then work your way back to your app and figure out where the issue lies ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 8, 2020, 2:23am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/11 "2020-03-08T02:23:09Z")
![fdssaffafs](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c235049c087645bfb5f2ac461f3ed3cbfd94d139.png) I’m trying to filter out each comment by the question (comment-question is just the question that was commented on) Also thanks for helping! ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 8, 2020, 2:37am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/12 "2020-03-08T02:37:32Z")
I tried to clean this up some. Here is revised code. I’d try this ![Screen Shot 2020-03-07 at 9.22.54 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/c/1c65aff905c92e5563af9984569bd9e5be602163.png) ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 8, 2020, 3:37am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/13 "2020-03-08T03:37:22Z")
When the screen opens, I already have the question and the answer and their index in a separate table. I’m trying to filter through a second table called “comments” and then create a list view out of the ones based off of the first column in the comments table, which is the question its responding to. So basically I have a text value (the question) in the separate question table (that i already have) and the question column in the comments table Then, Im trying to create a new list with all of the comments from the comment table using the indexes from the comparison If this didn’t make sense please let me know, it sounds kinda complicated because of all the bad names i chose for variables and such ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 8, 2020, 3:41am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/14 "2020-03-08T03:41:08Z")
if you are returning nothing, you are filtering out all of the data? when you send out for “all rows” does it return anything? then, if it does reutnr all the data, try filtering using a text block where you copy and paste text from your question column in your airtable into the blocks section instead of filtering based on what appears in variable transferred from the other screen. then if that works, try with the variable again. somewhere, the process is breaking down. What i posted is how to query desired data. Make sure property(column) names are correct including capitalization. ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 8, 2020, 3:58am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/15 "2020-03-08T03:58:31Z")
I put the GetAllRows value (by turning list into text) into a lable and multiple [object, Object] came out, ![3ccc](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/e/decf3487296f59ae3e780c41f85ef27a6910bcb8.png) ![2cccc](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/5/e51f495beee4267bc45b085193b5962559f4d276.png) ![1ccc](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/4/94d8af62a44f9c45b81db09898489a60516912e2.png) The data is there but nothing seems to show, probably has something to do with the [object, Object] ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 8, 2020, 4:06am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/16 "2020-03-08T04:06:37Z")
try this. only do 'getAllRows" on screen open. include the filtering and populating the listviewer. just this part ![Screen Shot 2020-03-07 at 10.51.21 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/7/779cd149954218a7a00a3bb181ad1f47d7315b6a.png) instead of using the variable “stored question”, i’d like you to copy and paste the qeuestion from the airtable itself to ensure you are using the exact wording/letter spacing/ punctuation etc. then do the following stuff as a note, in the blocks shown above, the listviewer is being populated before the variable has stuff put into it. put the blocks to fill the list viewer here ![Screen Shot 2020-03-07 at 10.50.10 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/4/e4b816df2c74ee1ee2dd6094b5582cd23e521d33.png) just after, (not inside) the loop. you need the variable to get filled up with data from the filtering that takes place before you try to fill the list viewer. ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 8, 2020, 4:15am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/17 "2020-03-08T04:15:20Z")
This works on the in-browser ios emulator but I’m downloading it to my phone right now to see if it 100% works! I think the “insert list” was the problem Thank you so much I’ve been working on it for the entire afternoon ![ccc22](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/d/5da4f0f350d41386ef64e9b2c76fb51cd2cedf00.png) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 8, 2020, 4:16am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/18 "2020-03-08T04:16:41Z")
Sweet! I hope it helps! Reach back out and let me know! ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 8, 2020, 4:47am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/19 "2020-03-08T04:47:21Z")
It works! One minor problem but I can look at it later in development as it isn’t vital to the backend [https://www.dropbox.com/s/bbuckn00tm1bepo/Video%20Mar%2007%2C%2011%2031%2000%20PM.mp4?dl=0](https://www.dropbox.com/s/bbuckn00tm1bepo/Video%20Mar%2007%2C%2011%2031%2000%20PM.mp4?dl=0) ---
**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:40am UTC](https://community.thunkable.com/t/solved-i-need-help-with-airtable-searching-through-rows/497051/20 "2024-11-08T11:40:32Z")