# \[Solved\] How to display rows from a table in thunkable x **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** solved, howto\ **Created:** [March 1, 2020, 11:52pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845 "2020-03-01T23:52:38Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![sharathnagendravjp](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sharathnagendravjp](https://community.thunkable.com/u/sharathnagendravjp)\ **Post date:** [March 1, 2020, 11:52pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/1 "2020-03-01T23:52:38Z")
I have searched and read through a lot of threads but still not able to find an way of iterating through a table and displaying rows. I am able to GetColumn and display all rows for a single column but looking for a way to get access to all columns in the row in a table. I dont want the getcolumn duplicated for each column. I am using GetAllRows and get the rows which is an object and when I display, it displays as just Object. I have defined a few columns within a row, tried listviewer, etc. How do I get fields from the object (rows) so I can access each column and display it or use it to do something? Appreciate any ideas, direction. thanks, Sharath ---
**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 2, 2020, 12:06am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/2 "2020-03-02T00:06:55Z")
Do you want to display the actual table? ---
**Author:** ![sharathnagendravjp](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sharathnagendravjp](https://community.thunkable.com/u/sharathnagendravjp)\ **Post date:** [March 2, 2020, 12:20am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/3 "2020-03-02T00:20:09Z")
Yes, I was to be able to get each column and display them. I have a couple use cases. One is just display 3 columns in the table as a table in the screen. Other one is as below: For example, here is how the row with columns can look: name | description | URL | icon , etc I need to be able to get access to each and create a view to display name as a header, then image and description and then show a link for the URL column. ---
**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 2, 2020, 12:30am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/4 "2020-03-02T00:30:28Z")
@sharathnagendravjp Awesome! What kind of app are you building? If you share a little more about what you’ve done via screenshots or a share link I can be more helpful. For starters though, check the links in [this post](http://community.thunkable.com/t/help-i-want-do-like-this-in-list-viewer/365759/19) ---
**Author:** ![sharathnagendravjp](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sharathnagendravjp](https://community.thunkable.com/u/sharathnagendravjp)\ **Post date:** [March 2, 2020, 12:55am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/5 "2020-03-02T00:55:42Z")
Thanks for the response and the link to that post, looks like a lot of good information. I will review it and hope to find what I am looking for. I am fairly new to thunkable, so struggling a little bit on how things work. One screen is a glossary of terms with definitions. The information is in airtable and was trying to retrieve the rows and display the columns. I was able to connect to airtable and display data from one column usinig GetColumn, but GetAllRows was not intuitive as it comes as an object and no easy/obvious way to get columns. Once I get this working, will get to the next screen which has more information. Not much to show yet, simple, but here is design, blocks and what is being displayed: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/e/5e9525f1ba946571cb7f1cdcd65db802e105773b.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/1/f1d2985272f78987595bbc935fae8519b47f4454.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/4/94f6ac1dd6ed7b1b3e38445f88168d8a7ed6a46a.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 2, 2020, 2:14am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/6 "2020-03-02T02:14:55Z")
k. looks like you need a list viewer. and to throw all rows though a loop. see my screenshot below. first i put all rows into a variable. i send that variable to be filtered. i flter based on certain properties. think about a property as a column position in a given row. when you put ‘all rows’ into the loop, the loop looks at the entire thing 1 row at a time. then when you say look at property X, you are really talking about column X in the current row that the loop is looking at, starting with the first. then at the bottom, i take out the particular ‘properties’ of object (row) j. and store them into a variable as a list. i then can display that list into a list vieweer. ![Screen Shot 2020-03-01 at 8.57.50 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/3/a3de88590a415ba40e0080d3eb688a0d7bf773f0.png) ---
**Author:** ![sharathnagendravjp](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sharathnagendravjp](https://community.thunkable.com/u/sharathnagendravjp)\ **Post date:** [March 2, 2020, 2:18am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/7 "2020-03-02T02:18:43Z")
Thanks for your quick response and a solution. I had used a listviewer and that did not give me more than what I was seeing, so had removed it. I was having trouble with taking the rows and using it. Thanks for your example, will try what you have suggested. Are you using a function? fetch\_chart\_1? ---
**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 2, 2020, 2:24am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/8 "2020-03-02T02:24:20Z")
> [@sharathnagendravjp](#): > > trouble with taking the rows and using it. Thanks for your example, will try what you have suggested. Yes. let me show you my sequence. my blocks here end up producing line charts, as a note. but all the info would easily display in a list viewer. the chart opens and gets the data from airtable ![Screen Shot 2020-03-01 at 9.17.55 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/f/bf52db54af35900b6f913bdcd5ebeeb82353ac9c.png) I Make sure all my variables are clear and setup to be lists ![Screen Shot 2020-03-01 at 9.18.01 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/6/36b2e50253a29679ea84b1270646d004b1171b9c.png) then i begin to set my chart up ![Screen Shot 2020-03-01 at 9.18.12 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/4/e4510fb3dfd5bedfda9bb2a32fc8deeed9d2cf08.png) but waitup, i need chart vairbales, so i filter my data from airtable now ![Screen Shot 2020-03-01 at 9.18.23 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/e/1eb67fa415c0046b04e01b319171561a59f5aec4.png) i need the bxname ![Screen Shot 2020-03-01 at 9.19.10 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/5/c57074c67e1db0aad4080cce57a48f7ce0bb89f2.png) and bxformat ![Screen Shot 2020-03-01 at 9.19.14 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/2/72ee2a692c17b2009c9cc38a3d15c95e96189052.png) at this point,i send the my chart setup to my api so it reutnrs a URL to use as a src for an image. when i get it back, i pass the response through this function to parse the response and to clean it up for use. ![Screen Shot 2020-03-01 at 9.19.41 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/d/eddc6c2b9b6732abd47334995a72169657fa7832.png) then i save the shortened URL’s to airtable in the last recorded row. the URL is then sent to another person via Integromat so the chart can be saved forever by the end user ![Screen Shot 2020-03-01 at 9.19.49 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/c/5c3e0d661dd2d255af44304bb029be5223134902.png) ---
**Author:** ![sharathnagendravjp](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sharathnagendravjp](https://community.thunkable.com/u/sharathnagendravjp)\ **Post date:** [March 2, 2020, 2:59am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/9 "2020-03-02T02:59:03Z")
@jared, really appreciate you taking time to share and explain in detail. Thanks a lot! I was able to get two columns displayed, but it showed only the last row from the table. In my layout, I had a row and had two columns and displayed the values in each column, but just one row, the last one from the table. How would I show all rows? If I have a listviewer, I dont know how to have more than one column displayed. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/0/60101dca74c7e0ed3787fa38f1c033aee6e5e867.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/3/034004dbd737891912e65cc916dfb626bddf4254.png) I had listviewer for a single column that works, but did not know how to put multiple columns in it. ---
**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 2, 2020, 3:02am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/10 "2020-03-02T03:02:39Z")
If that solved your problem, would you mind marking this as as solved or if you need more help, let us know! 🙂 happy to help! ---
**Author:** ![sharathnagendravjp](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@sharathnagendravjp](https://community.thunkable.com/u/sharathnagendravjp)\ **Post date:** [March 2, 2020, 3:14am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/11 "2020-03-02T03:14:51Z")
Sorry, I had just edited my previous response with some screenshots and question. Hope you can answer that. ---
**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 2, 2020, 4:49am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/12 "2020-03-02T04:49:28Z")
> [@sharathnagendravjp](#): > > ngle column that works, but did not know how to put multiple colu ![Screen Shot 2020-03-01 at 11.27.03 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/b/1b56c2baf39510a3685372b5f2d6d09ea8480e43.png) yep. instead of putting these things into a label. make that a variable. then, try to make the listvieweer show the variable. check this out, for example. i made this for your case. ![Screen Shot 2020-03-01 at 11.35.37 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/3/f37c21859ae120829a1fb1560b9b65029d8b9dc5.png) ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [March 2, 2020, 5:21am UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/13 "2020-03-02T05:21:09Z")
Hi, @sharathnagendravjp! 👋 I have used this kind of idea in my previous apps, where I wanted to display three-four columns’ data in one line, i.e. in one item of listviewer. I have used these kind of blocks - ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/3/93d51b422e95d536904359b3803dbc31cc9841bb.png) Hope I helped you! 😊 Thanks! 😊 ---
**Author:** ![alfopietro](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@alfopietro](https://community.thunkable.com/u/alfopietro)\ **Post date:** [March 2, 2020, 1:40pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/14 "2020-03-02T13:40:42Z")
Brillant! But I don’t know why in this way the list displayed is in a undefined order… no sort by name or date or order of inserted data… I can’t understand which is the logic behind. Do you have any advise ?? ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [March 2, 2020, 1:51pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/15 "2020-03-02T13:51:53Z")
Hi, @alfopietro! 👋 The list is displayed just like your airtable data. But if you still want it to be alphabetically, you can try these blocks - ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/a/3aa4508ec2ffc55e424bba3ee75b7a9b6bdd94f5.png) Hope I helped you! 😺 Thanks! 😊 ---
**Author:** ![alfopietro](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@alfopietro](https://community.thunkable.com/u/alfopietro)\ **Post date:** [March 2, 2020, 2:00pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/16 "2020-03-02T14:00:29Z")
I would it was displayed as it is in my AirTable… but unfurtunatelly it isn’t. I don’t know if I’m in the middle of a bug but there is (apparently) no logic on which order they are displayed! I see the 7th row as 1st, then, the last as 2nd and so on…sort of random ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [March 2, 2020, 2:04pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/17 "2020-03-02T14:04:07Z")
Ok; Just a quick question, how many rows do you have? Thanks! 😊 ---
**Author:** ![alfopietro](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@alfopietro](https://community.thunkable.com/u/alfopietro)\ **Post date:** [March 2, 2020, 2:10pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/18 "2020-03-02T14:10:35Z")
16 very few (at the moment!) 🙂 ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [March 2, 2020, 2:19pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/19 "2020-03-02T14:19:41Z")
Nice. How do you want to sort them? (like alphabetically, etc.) Thanks! 😊 ---
**Author:** ![alfopietro](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@alfopietro](https://community.thunkable.com/u/alfopietro)\ **Post date:** [March 2, 2020, 2:28pm UTC](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845/20 "2020-03-02T14:28:30Z")
The best probably would be to sort by reverse order of insert. I mean, I would see the last data inserted first. Thanks! [Next page](https://community.thunkable.com/t/solved-how-to-display-rows-from-a-table-in-thunkable-x/492845.md?page=2)