# Help with accessing airtable spreadsheet in thunkable app **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [June 3, 2019, 1:08pm UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041 "2019-06-03T13:08:51Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![b-rabbit](https://avatars.discourse-cdn.com/v4/letter/b/4bbf92/32.png) [@b-rabbit](https://community.thunkable.com/u/b-rabbit)\ **Post date:** [June 3, 2019, 1:08pm UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/1 "2019-06-03T13:08:51Z")
Hi all, Wondering if someone can help me please. I am very new to thunkable. I have set up an airtable spreadsheet and can successfully send data (i.e. create rows) from my app. I can also access all of the rows from a particular colum using the GetColum method and display in the list viewer. I am stuck at the GetAllRows method. in my mind, this should display the entire airtable spreadsheet (i.e. all 3 colums that I have and the 5 rows) in my list viewer? or am i mistaken? I have attached my attempt at this. I can’t seem to find an answer to this in the tutorials or other reference pages. Thanks in advance. ![Untitled](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/2/f226c015c8c2c4af62920f155caa44427dd63a43.png) ---
**Author:** ![Tanmay\_Kulkarni\_15](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanmay_kulkarni_15/32/69214_2.png) [@Tanmay\_Kulkarni\_15](https://community.thunkable.com/u/Tanmay_Kulkarni_15)\ **Post date:** [June 3, 2019, 1:26pm UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/2 "2019-06-03T13:26:47Z")
Can you send me a screenshot of your spreadsheet? ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [June 3, 2019, 3:00pm UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/3 "2019-06-03T15:00:01Z")
Hi, @b-rabbit, You are doing a small-looking big mistake 😅 You should replace **rows** in the **insert in list** block with for each item **j**. What you were doing is, adding a list in a list as an element. (since output **rows** of get all rows gives list of rows) This won’t work. You want to add item in a list, but you were adding a whole list as an element. Hope this helps! 😉 (If helps, then close this topic and mark this post as Solution.) Kartik ---
**Author:** ![CBVG](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/cbvg/32/32401_2.png) [@CBVG](https://community.thunkable.com/u/CBVG)\ **Post date:** [June 3, 2019, 4:10pm UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/4 "2019-06-03T16:10:51Z")
@kartik_old Correct. But to make a point, perhaps the insert element into a list block is not optimally worded, with “as” which is more indicative of a format of some sort. Maybe it would help clarify things if that was replaced by “item” or something like that. ---
**Author:** ![b-rabbit](https://avatars.discourse-cdn.com/v4/letter/b/4bbf92/32.png) [@b-rabbit](https://community.thunkable.com/u/b-rabbit)\ **Post date:** [June 4, 2019, 7:32am UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/5 "2019-06-04T07:32:20Z")
Hi @Tanmay_Kulkarni_15, see attached screenshot of the table. Thanks @kartik_old and for the advice, unfortunately I am still not getting any data displayed when I open the screen, see updated screenshot of what I have changed in my block. ![airtable](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/9/9924373d1d3833561cddbf72018e65287e7854ae.png) ![getallrows](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/1/d1cde1d55113c2955d2946864c42dfcd0510bc2b.png) Thanks in advance. ---
**Author:** ![Mark](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mark/32/18133_2.png) [@Mark](https://community.thunkable.com/u/Mark)\ **Post date:** [June 4, 2019, 4:34pm UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/6 "2019-06-04T16:34:00Z")
> [@b-rabbit](#): > > in my mind, this should display the entire airtable spreadsheet (i.e. all 3 colums that I have and the 5 rows) in my list viewer? or am i mistaken? @b-rabbit, You’re a little bit mistaken 😉 The `'text items'` property of the list viewer needs to be a list of text values. However, each row `'j'` of the Airtable spreadsheet will be an object representing that row. That object will contain a `'name'` property and `'tank'` property and a '`BCD'` property. You’ll want to combine those properties into a single text value, formatted as how you would like it to appear in the list viewer. You might want to take a look at the [Objects](https://docs.thunkable.com/objects) and [Text](https://docs.thunkable.com/text) documentation for more info. -Mark ---
**Author:** ![Tanmay\_Kulkarni\_15](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanmay_kulkarni_15/32/69214_2.png) [@Tanmay\_Kulkarni\_15](https://community.thunkable.com/u/Tanmay_Kulkarni_15)\ **Post date:** [June 5, 2019, 4:25am UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/7 "2019-06-05T04:25:41Z")
Right @Mark , but it can also be used if the variable initialization block is “Initialize global Applist to (create empty list)”, then the listview might show the items ---
**Author:** ![Mark](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mark/32/18133_2.png) [@Mark](https://community.thunkable.com/u/Mark)\ **Post date:** [June 5, 2019, 5:45pm UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/8 "2019-06-05T17:45:32Z")
> [@Tanmay\_Kulkarni\_15](#): > > Right @Mark , but it can also be used if the variable initialization block is “Initialize global Applist to (create empty list)”, then the listview might show the items Tanmay, I’m not sure what you mean by your comment. Could you elaborate? -Mark ---
**Author:** ![Tanmay\_Kulkarni\_15](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tanmay_kulkarni_15/32/69214_2.png) [@Tanmay\_Kulkarni\_15](https://community.thunkable.com/u/Tanmay_Kulkarni_15)\ **Post date:** [June 7, 2019, 7:58am UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/9 "2019-06-07T07:58:02Z")
I mean this ![IMG_20190607_132720](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/1/41174189109668b6f517d5f629e715d6554f3e47.jpeg) ---
**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\ **Post date:** [June 7, 2019, 9:51am UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/10 "2019-06-07T09:51:03Z")
@Tanmay_Kulkarni_15 - those look like Classic blocks to me. In Thunkable X you can initialise an empty list with blocks like this: ![54](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/3/33a13041ddbf8a35b62ade226f127c2a80b63262.png) Once you have the `app myList` variable you can use it to store responses from Airtable, and if you want to delete the contents of the variable, simply set to back to an empty list again. Hope that helps! ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 12:13pm UTC](https://community.thunkable.com/t/help-with-accessing-airtable-spreadsheet-in-thunkable-app/87041/11 "2024-11-08T12:13:34Z")