# How to Display Rows that have a Specific Value in a Column
**URL:** https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417
**Category:** Questions about Thunkable X
**Created:** [June 24, 2020, 11:24pm UTC](https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417 "2020-06-24T23:24:10Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@megnelaz](https://community.thunkable.com/u/megnelaz)
#### Post date: [June 24, 2020, 11:24pm UTC](https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417/1 "2020-06-24T23:24:10Z")
I have an Air Table by the same name as both a **Data Source** and an **Invisible Component**. The same data is in both the Data Source Air Table and the Invisible Component Air Table. I want to use a **Data Viewer List** to display the rows that have a certain item in a column, but I don’t know how to do this. The coding blocks I have say to either GetSelectedRows with a “startingRowNumber” and “numRows” or GetRow with a “rowNum.” Do you have any suggestions for me? I could not find a block that enabled me to search for rows that have a specific value in a column.
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [June 25, 2020, 7:40am UTC](https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417/2 "2020-06-25T07:40:46Z")
Hey @megnelaz 👋
I think what you want to do here is get the column from Airtable, then search through the column for your required value, then pass those values to the Dataviewer (maybe using local storage?)
---
### Author:  [@megnelaz](https://community.thunkable.com/u/megnelaz)
#### Post date: [June 26, 2020, 1:50am UTC](https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417/3 "2020-06-26T01:50:44Z")
Hi, I decided to not use the Data Viewer List anymore and instead display my values in a **List Viewer**. I also found two other discussion threads that helped me answer my question, and I will provide them in two posts below if anyone wants to access them. 😀
---
### Author:  [@megnelaz](https://community.thunkable.com/u/megnelaz)
#### Post date: [June 26, 2020, 1:51am UTC](https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417/4 "2020-06-26T01:51:35Z")
This code in this article enabled me to search for values in a column and display them in a List Viewer:
> [@Search for value in colum (Airtable Spreadsheet)](http://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949):
>
> Hello again, I’m trying to retrieve a value from a colum “Date\_value” in an Airtable Spreadsheet, the colum contains either 1 or 2, if number 1 is found all values from colum “Kombiniert” should be visible an the List viewer. And once again I can’t find a solution… Here’s my attempt: [Capture] Anyone?
---
### Author:  [@megnelaz](https://community.thunkable.com/u/megnelaz)
#### Post date: [June 26, 2020, 1:53am UTC](https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417/5 "2020-06-26T01:53:29Z")
Another issue I had was ensuring the lists that contained specific values from a column did not repeat values. I found the code circled in green in this article helpful:
> [@\[Solved\] How can I delete one if there are two identical names in the list?](http://community.thunkable.com/t/solved-how-can-i-delete-one-if-there-are-two-identical-names-in-the-list/416244):
>
> I made a list and I get unwanted copying. So if there are two identical names in the list I want to delete one. What is the best way to do this?
---
### Author:  [@megnelaz](https://community.thunkable.com/u/megnelaz)
#### Post date: [June 26, 2020, 7:14pm UTC](https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417/6 "2020-06-26T19:14:46Z")
Hello @domhnallohanlon
Although I decided not to use a Data Viewer List for the specific part of my app mentioned above, I am using a Data Viewer List for another part of my app and am considering using the local storage idea you suggested in your reply to my discussion post.
Could you tell me how to set up local storage? I would like the storage to be specific to each user on the app.
Thank you!
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:25am UTC](https://community.thunkable.com/t/how-to-display-rows-that-have-a-specific-value-in-a-column/635417/7 "2024-11-08T11:25:26Z")