# Get particular row information via particular text from airtable column
**URL:** https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [February 12, 2022, 3:12pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653 "2022-02-12T15:12:40Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 12, 2022, 3:12pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/1 "2022-02-12T15:12:40Z")
Hi,
I am trying to display row information of particular text in column . Ex: Column Named Skills has Garden Cleaning, Dusting, Fan Cleaning, Balcony Cleaning and so on…
I want the row details of Dusting alone. If I have 2 entries for Dusting means then I should see only those 2 row details getting displayed in the listviewer.
Sharing the blocks:
Also sharing the airtable snapshot:
Your input is highly appreciable…
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [February 12, 2022, 3:35pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/2 "2022-02-12T15:35:02Z")
You can use the Airtable API to filterByFormula and return only results where Skills=“Dusting”.
> [@The AirTable API (a more efficient way to integrate AirTable with Thunkable)](https://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167):
>
> I’ve had the pleasure of working on a few AirTable projects recently. One thing I’ve learned is doing stuff like this is inefficient once you start to get a lot of data. [image] You should try to limit how much data you call and the number of API calls. To update a record, you shouldn’t get all rows, loop through all rows until you find the row you need to update, then update that row. With the AirTable API you can use things like filterByFormula to query the data in one call to reduce the d…
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 12, 2022, 7:45pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/3 "2022-02-12T19:45:41Z")
The code you shared should not work. The green column block is actually a list. You will need to loop through this list and when you see the word “Dusting” then take the row number and use the `RetRow` block to view other info.
You used the list block **contain** which should return **True** or **False** which is not a row number.
Again, your are getting the row to read the value of column “Skills” which you already have from previous call of `GetColumn` block so why the extra steps.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [February 13, 2022, 3:49am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/4 "2022-02-13T03:49:22Z")
If you do want to try using the API, I’m currently trying to set up filtering and multi-sorting of Airtable data. It seems to be working pretty well. Here, I’m filtering by a specific value in the Homeroom column and then sorting by Last Name then First Name in ascending (“asc”) order:
Note that the Authorization field has the string "Bearer " with a space at the end.
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 13, 2022, 7:38am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/5 "2022-02-13T07:38:33Z")
It’s very Interesting. Thank you for highlighting this feature. It worked too but not all.
Row creation is a cake walk.
But displaying the row as per the condition is right but not right because I guess some correction to be done in the coding.
Sharing the blocks.
sharing airtable snapshot:
output as per the below screenshots:
What is missing in the code to display only Dusting row info?
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 13, 2022, 7:39am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/6 "2022-02-13T07:39:42Z")
Will try Muneer and update whether its a success or not.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [February 13, 2022, 7:49am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/7 "2022-02-13T07:49:03Z")
Your filterByFormula field is correct. But the “records” property is a list of records. It’s not a list of text strings which is what the List Viewer’s text items requires. Once you get the records lists, you have to then parse it for specific properties such as Name, Age, etc.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 13, 2022, 8:18am UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/8 "2022-02-13T08:18:20Z")
Try this demo project
[https://x.thunkable.com/projectPage/6182dddab8ae1a001142ac60](https://x.thunkable.com/projectPage/6182dddab8ae1a001142ac60)
It will help you to see the same issue resolved but from another angle.
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 13, 2022, 12:02pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/9 "2022-02-13T12:02:39Z")
Ok… I tried it.
Sharing my output:
Also my blocks
Wanted to know why just one entry is appearing? also how I can make listviewer to display as one whole text.
Kindly assist.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 13, 2022, 12:46pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/10 "2022-02-13T12:46:47Z")
> [@sasi.preethag3yh](#):
>
> how I can make listviewer to display as one whole text.
The `List Viewer` expects a list not a single string. The variable `app variable Name` is not a list.
For extracting data from the Airtable, let me explain with an example.
I have this table
I want to show all the User IDs in a list using API, this is how you do it.
You already know how to get the rows using the API so I will show you how to extract records from the `Response` green block.
These are variables that I use in my code. One is a list and another to hold the response of the API.
This is a sample output
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 13, 2022, 12:59pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/11 "2022-02-13T12:59:24Z")
There you go… Got it now. Thank you so much for your detailed explanations along with the sample data with blocks.
Sharing my corrected blocks.
Output as it displays as per the filter condition Dusting
Thank you so much.
I am trying the other one which you shared .
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 13, 2022, 1:06pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/12 "2022-02-13T13:06:10Z")
> [@sasi.preethag3yh](#):
>
> I am trying the other one which you shared .
Both would work but the other one requires that you connect to Airtable using the `Data Sources` method not the one you currently using (Airtable component).
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 13, 2022, 1:13pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/13 "2022-02-13T13:13:21Z")
The other one is where I am little stuck.
Know how to retrieve all data from Airtable.
Sharing the output:
Blocks:
As mentioned above I want only the particular text in the column. Ex: Dusting in Skills column.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 13, 2022, 1:17pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/14 "2022-02-13T13:17:56Z")
When using the DVL (Data Viewer List), you do not need to created any blocks to display table content.
First add a DVL component to your screen and then in the DVL properties, choose which table to connect to and in the table which columns to show. With DVL you can show multiple columns not only a single column.
Filtering comes as second step not the first.
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 13, 2022, 1:20pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/15 "2022-02-13T13:20:00Z")
Yes you are right. I realized later after spending some time in designing, sharing the designs. But I really want to adjust as per my designs that’s when I faced these challenges.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 13, 2022, 1:22pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/16 "2022-02-13T13:22:11Z")
> [@sasi.preethag3yh](#):
>
> spending some time in designing, sharing the designs
Do you know you can have the menu you just shared a dynamic one by using DVG (Data Viewer Grid). Just to expand your views further.
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 13, 2022, 1:24pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/17 "2022-02-13T13:24:27Z")
Yes , I know that too … Will customize.
With this designs the AirtableAPI really worked.
Thank you so much for your guidance as always. Much appreciated!
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [February 13, 2022, 4:35pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/18 "2022-02-13T16:35:33Z")
Now, what I am trying to get is … After listing the Skills as per the conditions i.e Skills = Dusting then list the number of entries related to Dusting in the listviewer.
After selecting the items in the Listviewer, I have to see the all the details of that selection.
Example: Dusting has 2 entries D1 & D2 after listing (AirtableApi via filterbyFormula) those in listviewer then I select D1, I would like to see the correct entries related to D1 like Phone Number & Age.
Seek your assistance.
---
### Author:  [@Dario\_Cappello](https://community.thunkable.com/u/Dario_Cappello)
#### Post date: [February 13, 2022, 6:43pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/19 "2022-02-13T18:43:39Z")
hi, is it possible to select records on airtable, using filterbyformula, by searching part of a column, for example a word from a description column?
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [February 13, 2022, 7:22pm UTC](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653/20 "2022-02-13T19:22:32Z")
Yes. There are several examples of that in this topic if you scroll up.
[Next page](https://community.thunkable.com/t/get-particular-row-information-via-particular-text-from-airtable-column/1730653.md?page=2)