# \[Solved\] Need guide with ListViewer using Airtable
**URL:** https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150
**Category:** Questions about Thunkable X
**Tags:** solved, listviewer, airtable
**Created:** [May 29, 2019, 7:16am UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150 "2019-05-29T07:16:24Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@sysads](https://community.thunkable.com/u/sysads)
#### Post date: [May 29, 2019, 7:16am UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/1 "2019-05-29T07:16:24Z")
Hi, I am still working my way with thunkable and need help or guide on how I can display datas from a spreadsheet column using listview.
- Basically my spreadsheet has 3 columns & 70 rows
- I have 2 screens
- When screen\_1 loads, it should display all 70 data from column\_1 in the listview
- When you click on one of the lists, it should load screen\_2 with corresponding data from columns 2 and 3
Because I am keen to learn, pls provide me with steps to achieve this or links to videos that explains this.
Thanks
---
### Author:  [@kartik\_old](https://community.thunkable.com/u/kartik_old)
#### Post date: [May 29, 2019, 10:02am UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/2 "2019-05-29T10:02:30Z")
Hi @sysads,
You may use this block (for Scrn1 i.e column1) :
And I can’t understand your point :
> [@sysads](#):
>
> When you click on one of the lists, it should load screen\_2 with corresponding data from columns 2 and 3
Kartik
---
### Author:  [@sysads](https://community.thunkable.com/u/sysads)
#### Post date: [May 29, 2019, 10:08am UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/3 "2019-05-29T10:08:39Z")
Hi and thanks for the reply. I will try out your steps now but can you figure out why my own step below keeps reloading the app when I try to navigate to the screen
**Update**
**Ah my bad, I did not select the correct spreadsheet hence why it did not load. Now its loading with my setup above**
Also what I mean by this “When you click on one of the lists, it should load screen\_2 with corresponding data from columns 2 and 3” is
When I click each list row, it should load another screen with values corresponding to it’s row
---
### Author:  [@kartik\_old](https://community.thunkable.com/u/kartik_old)
#### Post date: [May 29, 2019, 10:17am UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/4 "2019-05-29T10:17:18Z")
You should do like :
for each item **j** in column,
do : add items to list --list name here-- item : **j**
outside the for loop :
set list.items to variable list
You can see my above block **screen initialize**
Kartik
---
### Author:  [@sysads](https://community.thunkable.com/u/sysads)
#### Post date: [May 29, 2019, 10:19am UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/5 "2019-05-29T10:19:04Z")
sorry i just made an update above. my setup works just as yours. i forgot to select the correct spreadsheet ☹
So just left with when I click each item, it should load a second screen with its corresponding row data
---
### Author:  [@jane](https://community.thunkable.com/u/jane)
#### Post date: [May 29, 2019, 11:09am UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/6 "2019-05-29T11:09:19Z")
Hi there,
These blocks can help you display the information from column2 and column3 whose row number matches the item from column1 your user clicked.
Once you’ve displayed column1 in a List Viewer:
The index (row number) of the item selected is saved, the next Screen is opened.
When the next Screen opens:
You can use this row number to retrieve the information that was saved to the same row in column2 and column3.
Hope that helps!
---
### Author:  [@kartik\_old](https://community.thunkable.com/u/kartik_old)
#### Post date: [May 29, 2019, 2:01pm UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/7 "2019-05-29T14:01:35Z")
@sysads,
Please close this topic by marking as a solution.
😄
and,
> [@heart Saying Thanks in the Community!](http://community.thunkable.com/t/saying-thanks-in-the-community/74080):
>
> So, you’ve taken the time to carefully craft a new topic title and filled it with details about the current question that’s on your mind. Suddenly, out of seven billion people on the planet, one of them has taken a few moments out of their day to respond to you. How should you react? heart Like, totally! The easiest way to show your appreciation is by simply clicking the “like” button to show you like what you’re hearing. Perhaps someone has pointed you to another topic, a video or a doc t…
---
### Author:  [@sysads](https://community.thunkable.com/u/sysads)
#### Post date: [May 29, 2019, 2:28pm UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/8 "2019-05-29T14:28:49Z")
Mama mia, you are a super star. Thanks
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 12:13pm UTC](https://community.thunkable.com/t/solved-need-guide-with-listviewer-using-airtable/77150/9 "2024-11-08T12:13:36Z")