# Airtable and List **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [October 21, 2020, 5:06am UTC](https://community.thunkable.com/t/airtable-and-list/918499 "2020-10-21T05:06:54Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 5:06am UTC](https://community.thunkable.com/t/airtable-and-list/918499/1 "2020-10-21T05:06:54Z")
Sorry if this sounds rather simple, but I just can’t seem to figure out how this is not working… I’m trying to access a list of values from my Airtable database, I thought something like this would do the trick, but just can’t seem to get it to work… Is the below the correct way to use “list of values”? I’ve also tried the List Insert function… What is really the best way to access Airtable values? ![Airtable List](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/7/677659208ff81449ad546e7f2739e0c3cd00238f.jpeg) Thanks! ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 21, 2020, 5:47am UTC](https://community.thunkable.com/t/airtable-and-list/918499/2 "2020-10-21T05:47:08Z")
You’ll want to use the Get Row or Get All Rows blocks. @darren has a good tutorial video here: [https://www.youtube.com/watch?v=V61Oo6TCwnw](https://www.youtube.com/watch?v=V61Oo6TCwnw). ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 5:01pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/3 "2020-10-21T17:01:21Z")
Hi @tatiang! That was actually very helpful! I was using Airtable as a DataSource, and that didn’t come with any of the options (Get Row, Get All Rows)… Do you have time for another question? I went through the tutorial to add Airtable. However, I’m still having issues with accessing values by using GetAllRows… It looks like I can connect to the AirTable API (able to retrieve table name and other properties). However, accessing the individual rows on the table still seems to be the challenge… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/0/3045fb3e61f768a03bdce5c243ce85c8423b97f5.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/a/6aa9ac63949542c295fa8a8faf65e29e514b306a.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/3/e3f3428fe218d68da80127e14e044de1eb7fbce4.png) Thanks in advance for your help! ---
**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:** [October 21, 2020, 5:43pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/4 "2020-10-21T17:43:04Z")
[https://x.thunkable.com/copy/5d0985de18ddb9446d7413544e5e0bd6](https://x.thunkable.com/copy/5d0985de18ddb9446d7413544e5e0bd6) This may help ---
**Author:** ![drted](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/drted/32/92694_2.png) [@drted](https://community.thunkable.com/u/drted)\ **Post date:** [October 21, 2020, 5:49pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/5 "2020-10-21T17:49:52Z")
I found this solution much faster for Google Sheet, but I haven’t tried it on AirTable. For AirTable, substitute the Get Column block for the List of Values block in the example. > [@Data Source Performance Workaround FOUND!](http://community.thunkable.com/t/data-source-performance-workaround-found/756227): > > Anyone who has tried to use the data source GET VALUE block to retrieve an entire row from a google sheet data source will have noticed the abismal performance. I’ve developed a work-around with resonable performance, albiet block intensive. The basic process is: For each column in the data source, manually use the LIST OF VALUES block to copy the entire column into a local list Use the LENGTH of one of the created lists for a COUNT WITH block and build a JSON object using the CREATE OBJECT a… ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 6:43pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/6 "2020-10-21T18:43:53Z")
@jared Unfortunately I looked at all the connection settings to AirTable, and everything matches what the example is doing… The one thing I saw different from the example was that the example assigned a list variable to the current row in AirTable, and then access the element based on that list variable. I tried that as well (instead of just accessing the row variable directly), but still not working… Something is funky with the GetAllRows API call to the AirTable, and I don’t know what it is… Ugh… ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 6:45pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/7 "2020-10-21T18:45:06Z")
@drted Thanks! Though I don’t even think I’m that far yet to worry about performance issues… I can’t seem to get passed the GetAllRows API call to return data… ---
**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:** [October 21, 2020, 6:49pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/8 "2020-10-21T18:49:03Z")
do you get any result from 'getallrows"? ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 6:55pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/9 "2020-10-21T18:55:40Z")
@jared Nope, not at all… I created a list variable called addrList and assigned basic values of “1, 2, 3”. I then called GetAllRows to get Address\_Street values and add each value to the list. So I would expect “1, 2, 3, xxxx, xxxx, xxxx”. As you can see in the screenshot, the variable still just returns “1, 2, 3” after I looped through GetAllRows… So nothing is coming back from GetAllRows… (showing AirTable has at least one row) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/9/290eab3ed23548544432520485e0e20b8f2f71d5.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/d/3db59b3bd9518621d142380df74d79cfd71c6bb3.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/7/67fc56523c01d519a5c61465ce55baa47c13a34b.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 21, 2020, 7:02pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/10 "2020-10-21T19:02:06Z")
Put the “from mqDistance set Text” block inside the GetAllRows block. Otherwise, it’s going to run before your loop finishes. If you move it inside (below the loop block), I would expect to see the value of the last address\_street in your AirTable sheet. ---
**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:** [October 21, 2020, 7:09pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/11 "2020-10-21T19:09:42Z")
yes! the label should be set after the loop, not after the purple airtable block. connect the label set block to the bottom of the loop block, (not inside the loop). make sure all of those are in the ‘then do’ section of the airtable block. ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 7:35pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/12 "2020-10-21T19:35:34Z")
@tatiang @jared Still not working… I moved the set label block inside the GetAllRows block. Also added a “in\_loop” string to make sure the loop is happening, which seems to be the case. However, still no values coming out from Address\_Street… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/7/67afb195303c7bb3bdd2436c9a51942cc601a08c.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/5/d52b9ea4ebf20d34ac2b353960811c535b0bc941.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:** [October 21, 2020, 7:57pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/13 "2020-10-21T19:57:20Z")
Have you checked your error block? ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 8:02pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/14 "2020-10-21T20:02:45Z")
@jared No errors showing… Tried inserting error message to list instead of rows… No luck… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/3/0369abe6566b6be6edbcc0bc27f9c1225dcee14c.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/0/504f163652fb57667a7dd5209cb48af177f97cca.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:** [October 21, 2020, 8:07pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/15 "2020-10-21T20:07:10Z")
I mean. Can you try to print the error block directly to the label. ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 8:10pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/16 "2020-10-21T20:10:31Z")
@jared Tried that earlier as well… Showing “null”… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/e/eef44c3e1eb6348e94a95e66b79b7bff828ee530.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/b/eb82bb2295bf00171fb7ff9ce10ebebfebe34aca.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:** [October 21, 2020, 8:16pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/17 "2020-10-21T20:16:59Z")
Can you take a picture of the settings for your air table in the design screen and not the block screen. Did you make sure to set the view to Gridview? Are you sure that your API key and bass IDR correct? What happens if you print out the all rose block to a label does anything happen then? ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 8:49pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/18 "2020-10-21T20:49:25Z")
@jared I’ve gone over the API keys and Base ID multiple times… They are copied exactly from AirTable… I’m going crazy… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/6/c61a7edf68aaf4cb41f338b5ae677c66a0d50773.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/b/0b7b961ab08edd3003f2da9cd6b2177d2d4158dd.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 21, 2020, 9:08pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/19 "2020-10-21T21:08:26Z")
Does it work with the “Name” property/column instead of “Address\_City”? Try this set of blocks: ![Screen Shot 2020-10-21 at 2.11.53 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/8/58c0d4b7a320ad6e24c3c6ba3ed820af8776cefb.png) ---
**Author:** ![advantecsolutionsllc](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@advantecsolutionsllc](https://community.thunkable.com/u/advantecsolutionsllc)\ **Post date:** [October 21, 2020, 9:24pm UTC](https://community.thunkable.com/t/airtable-and-list/918499/20 "2020-10-21T21:24:35Z")
@tatiang … undefined… 😔 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/2/028d6a61ae41174ce4626b677f69cec97b542f26.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/8/885aedfe098056a081cc9a00b101ec68d8ec9447.png) [Next page](https://community.thunkable.com/t/airtable-and-list/918499.md?page=2)