# Airtable: Retrieving data from linked tables **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [August 11, 2021, 2:37pm UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061 "2021-08-11T14:37:16Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![WashboardSam](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/washboardsam/32/113229_2.png) [@WashboardSam](https://community.thunkable.com/u/WashboardSam)\ **Post date:** [August 11, 2021, 2:37pm UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061/1 "2021-08-11T14:37:16Z")
![Screenshot (649)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/9/e9bffa56b8e49a768655533e46c7cbce961f44e6.png) Hi! Can someone tell me where I am going wrong here? Retrieval for what I have highlighted in green here works fine, but the red highlight doesn’t. The green area shows everything as I want it - the contents of the particular cell. There’s just normal strings in these. The red area shows only the recordID. In the red area I am retrieving data from another table, in other words: What is stored in Orders-\>Bikes is referring to another table. I want to display what it links to, not the key to what it links to. I hope this makes sense, might have stared at all this for too long now to be able to solve it on my own. Also have next to no experience with databases, I might get some terminology wrong… thanks a lot! ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 11, 2021, 3:25pm UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061/2 "2021-08-11T15:25:16Z")
The record ID you are receiving from “Orders-\>Bikes” is actually the record ID in another table that you need to get the required info or description by using the same `get value` block but using the row ID as the one retrieved from the “Orders-\>Bikes” table. So, in short do another `get value` using `app variabe OrderBikes` in place of `app variable Ordersindex` Happy Thunking! ---
**Author:** ![WashboardSam](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/washboardsam/32/113229_2.png) [@WashboardSam](https://community.thunkable.com/u/WashboardSam)\ **Post date:** [August 12, 2021, 11:39am UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061/3 "2021-08-12T11:39:51Z")
Thanks a lot! I did suspect that. I now have the problem that some cells in the Airtable can hold multiple entries. What is the best way to display multiple entries simultaneously? I’ve tried a ListViewer but that onyl shows all rows of one column. Is there any way to use ListViewer to display the contents of one cell instead? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 12, 2021, 5:17pm UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061/4 "2021-08-12T17:17:55Z")
I’m not sure what your question is about the List Viewer. As it names clearly says, it is a viewer for the list that you build up in your code. It will display whatever list you assign it whether it has a single element or tens of elements. ---
**Author:** ![WashboardSam](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/washboardsam/32/113229_2.png) [@WashboardSam](https://community.thunkable.com/u/WashboardSam)\ **Post date:** [August 16, 2021, 1:59pm UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061/5 "2021-08-16T13:59:33Z")
Thanks for your reply, I had been off the net for a few days. To clarify: Here is what I want to display: ![Screenshot (652)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/9/39afd272660c8feda56e8da6f476e6d7b6b03fc5.png) Everything under Gear for one row. The cell holds multiple entries which refer to another database. I figured I should make a list and add every item in the cell to the list but this doesn’t do anything. Here are the blocks I have: ![Screenshot (651)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/0/4024887befb77862e515796147193e3588b10867.png) Here’s what happens when running it: ![Screenshot (650)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/f/7fc671ed7a3403ed272af3071c047e3be62c6567.png) ## Earlier I was just setting the Label Text to what the “get value from” from the Data Sources category, but weirdly, that approach just iterates through all entries in the cell char by char, to the effect that if a cell has the record YX-123 it would create a List Viewer with Y X 1 2 3 I am at a loss. How do I display every entry? I don’t care right now if it’s in a label or a list viewer. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 16, 2021, 5:19pm UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061/6 "2021-08-16T17:19:33Z")
The displayed results are the expected. You are passing a text field to the `for each item j in list` which is expecting a **list**. So the block treated the text as a list and made every character as an entry in the list. You need something like this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/2/8269806aedaf52dc2c32619dff10f3e1abb50661.png) NOTE: where I typed **Some Delimiter** , you need to see what is **SEPARATING** each code from the other and insert it here whether it is a **space** or a **New Line**. I must say that I feel you do not need the **loop**. Just use the list block as the input of the list viewer. ---
**Author:** ![WashboardSam](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/washboardsam/32/113229_2.png) [@WashboardSam](https://community.thunkable.com/u/WashboardSam)\ **Post date:** [August 17, 2021, 2:16pm UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061/7 "2021-08-17T14:16:31Z")
Thanks! Yes the loop was a second attempt. It makes perfect sense that the loop would just iterate the way it does. But I didn’t know. Coming from Python I guess I was hoping I could just do a “for j in list” and then get every entry in the list. I also suspected that I wouldn’t have to loop but my first attempt didn’t work either. ---
**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, 1:17pm UTC](https://community.thunkable.com/t/airtable-retrieving-data-from-linked-tables/1444061/8 "2024-11-08T13:17:27Z")