# Unable to get All rows data from air table **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [April 25, 2021, 12:17pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622 "2021-04-25T12:17:25Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [April 25, 2021, 12:17pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/1 "2021-04-25T12:17:26Z")
Hi , I’m trying to get all rows data but unable to get on app and I have approx 15 column in my table and now approx 30 Row is there so here is my block. ![IMG_20210425_173742](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/f/6fce2545fb4ea80ff4c409af809bd403caa19f1b.jpeg) But I can able to view my air table column data from below block ![IMG_20210425_173645](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/1/c13cdd8aebd8b2bea98878989e9a997dcbfb1796.jpeg) Where am doing mistake in get all rows can anyone help ? Thanks ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [April 25, 2021, 12:28pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/2 "2021-04-25T12:28:29Z")
Is it possible your listviewer just isn’t scrolling so that you can see the rest of the items? ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [April 25, 2021, 12:43pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/3 "2021-04-25T12:43:03Z")
@catsarisky thanks for revert. I’m getting error while clicking on get button …“Something wrong with your block” And it’s auto closing the app . ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [April 25, 2021, 12:48pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/4 "2021-04-25T12:48:46Z")
Oh, I see it. Thanks for clarifying. You can set a list viewer’s text items to a _list_, like in the second example. But in the first example, you’re setting it to an object (rows), not a list. ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [April 25, 2021, 12:54pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/5 "2021-04-25T12:54:49Z")
@catsarisky thanks for support. I will update my block an revert. ---
**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:** [April 25, 2021, 1:02pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/6 "2021-04-25T13:02:29Z")
You could throw the all rows block into a loop and use the get object property block inserting that property into a list and then use that list in the list viewer but that’s not the most efficient way to do that. If you just want a single column of data than you should use the get column block What you were doing is the way to call data when you want to present complex data in cards, for example, but that’s not what the simple listviewer is made for. I have done that to get data from airtable to construct charts but have moved away from airtable completely. ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [April 25, 2021, 1:30pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/7 "2021-04-25T13:30:19Z")
Hi @catsarisky that solution is not worked out . and @jared if am using get property block in that property name and Object what should be ? if you can share example block pls share . thanks for your support. ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [April 25, 2021, 4:14pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/8 "2021-04-25T16:14:48Z")
Hi @jared i have used get property block and its resolved . Thanks @jared and @catsarisky for support 🙂 ---
**Author:** ![ali744046s](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ali744046s](https://community.thunkable.com/u/ali744046s)\ **Post date:** [April 25, 2021, 7:50pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/9 "2021-04-25T19:50:45Z")
Hello . Sorry for bothering you. Can you explain how I can show the index number for an item in the table in the first column and then show the rest of the rows of other columns. I want to see the blocks and another problem. I have a different problem. When I subscribe, the rest of the attachments will appear because the attachments are very few ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [April 26, 2021, 2:33am UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/10 "2021-04-26T02:33:59Z")
@ali744046s In list viwer you will get data in list formats not like spreadsheet you have to segregate the columan data by special character. Rowwise data can be show in list viewer . ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [April 30, 2021, 2:50pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/11 "2021-04-30T14:50:51Z")
Hi @jared Can we get data like table format with index and column name ? If anyone have idea on that pls help. ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [April 30, 2021, 3:01pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/12 "2021-04-30T15:01:00Z")
Vikkun, you certainly can format your data that way. I’d encourage you to look at the Data Viewer List with a custom layout making the columns, not Listviewer. ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [April 30, 2021, 4:47pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/13 "2021-04-30T16:47:49Z")
@catsarisky thanks for the Idea, I have tried but not succeed . If you don’t mind can you share few sample blocks . Thanks ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [April 30, 2021, 5:30pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/14 "2021-04-30T17:30:11Z")
Sure. Here ya go. [https://x.thunkable.com/copy/9a1343f7574304b452e36c216b5ab110](https://x.thunkable.com/copy/9a1343f7574304b452e36c216b5ab110) It uses local DB instead of Airtable because API keys wouldn’t copy correctly, but you can totally switch it to airtable - just click the DVL and choose a different data source. The second screen, that I used to create the custom dataviewer, is included in the project, so that you can see what it looked like before I made it a custom dataviewer. ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [May 1, 2021, 8:32am UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/15 "2021-05-01T08:32:56Z")
Hi @catsarisky Thanks for the sharing project page. I have created and its working with air table also now am getting data in single row and i can scroll that row also . But i have a multiple column approx 16 so it now showing congested look like only one line there is no separation between columns. can we create table view for that ? And still in this also we are not getting column name . Now output like this ![Screenshot_2021_0501_145039](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/8/c8f77ee16bee4b8ff4323b34ff9046e89fa99db4.png) It’s look like brick wall 😂 If anything please help. Thanks a lot. Rgards, Vikku ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [May 1, 2021, 10:53am UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/16 "2021-05-01T10:53:29Z")
That’s NOT how it should look, clearly. I’m surprised. If I get a chance later today I’ll try adding some more columns to see if I get the same jammed up mess. How do you want to deal with your 16 columns? You could use a data card approach (with some information on a second row). Or maybe you show just a few columns but then when the user clicks they see the full information for that row? I’m having a hard time imagining 16 columns working well on a phone screen. You can add headers above the DVL. DVL doesn’t have a header row function, but your rows in airtable probably aren’t changing headers, are they? ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [May 1, 2021, 1:06pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/17 "2021-05-01T13:06:46Z")
@catsarisky Thanks for revert I understand all 16 column will dot display in single screen it should scrollable from left to right. Actually i am developing a service call logging tool and trying to show all table data to user. or can we show like you told if i will show only single column data like first column (Customer name) then if i click on that it will show row data so for that i can use same screen which is using for data inserting and there i can put button for Next &Previous. . Thank You for support Regards, Vikku ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [May 3, 2021, 4:38pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/18 "2021-05-03T16:38:04Z")
Hi Anyone have idea on how can get data from Airtable in table format please share. Thanks. ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [May 3, 2021, 4:54pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/19 "2021-05-03T16:54:29Z")
Sorry, I thought I had replied to you earlier. Here’s a DVL that produces output in columns: [Thunkable](https://x.thunkable.com/copy/d16074ec4ecea06b82937980863cd6a2) . I’m not sure what that isn’t happening for you above based on your screenshot. What it does /not/ do is scroll horizontally. That’s tricky, and maybe not 100% cross-platform. You could search the forums for horizontal scrolling - there are several solutions posted. Alternately, you could choose to show a few columns (like in the linked project) and then let the user retrieve the rest by clicking the line they’re interested in, which I think is what you described above. ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [May 3, 2021, 5:02pm UTC](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622/20 "2021-05-03T17:02:18Z")
Hi @catsarisky , Thanks for your prompt reply i will try that and update you the result . Thanks a lot 🙂 [Next page](https://community.thunkable.com/t/unable-to-get-all-rows-data-from-air-table/1244622.md?page=2)