# \[Solved\] Get names from Airtable list

**URL:** <https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960>\
**Category:** Questions about Thunkable X\
**Tags:** solved\
**Created:** [February 4, 2021, 11:49pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960 "2021-02-04T23:49:23Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![pbuydidm](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@pbuydidm](https://community.thunkable.com/u/pbuydidm)\
**Post date:** [February 4, 2021, 11:49pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/1 "2021-02-04T23:49:23Z")

</div>

Hi!  
Iḿ trying a simple task, but all the tutorials are using blocks I can’t find in my panel.

I’ll explain myself.  
there is a table in Airtable with 2 columns: ID and Name. I have already linked the table to my app.  
When the user insert the number of ID in a Text Input, the name related to that ID is shown in the text label.

 ![IMG_20210204_204449](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/1/519d5a05aad230f9023d242f1cde135f66da522a.jpeg)

I’ve been reading this: [Airtable - ✕ Docs](https://docs.thunkable.com/spreadsheet#getting-uploading-updating-and-deleting-data-in-a-spreadsheet) but as I said, some blocks aren’t present.  
Thanks in advance!  
Pablo

---

<div class="post-metadata">

**Author:** ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)\
**Post date:** [February 5, 2021, 3:48am UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/2 "2021-02-05T03:48:35Z")

</div>

Are you using the legacy UI or drag and drop?

---

<div class="post-metadata">

**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:** [February 5, 2021, 7:17am UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/3 "2021-02-05T07:17:33Z")

</div>

With Airtable there is no easy way to do a lookup unless you use API or you use the old method of looping through the records and comparing values till you get the required one.

In the other hand I would recommend to use a column name other than ID such as UserID because ID is a hidden name in all Airtable tables.

---

<div class="post-metadata">

**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:** [February 5, 2021, 10:31am UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/4 "2021-02-05T10:31:31Z")

</div>

> [@pbuydidm](#):
>
> When the user insert the number of ID in a Text Input, the name related to that ID is shown in the text label.

How are you doing this @pbuydidm ?

I’m assuming your IDs are unique, right?

---

<div class="post-metadata">

**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:** [February 5, 2021, 4:28pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/5 "2021-02-05T16:28:53Z")

</div>

@pbuydidm  
See this code. This is working for me. I search for phone numbers but of course you can change the code to your needs.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/2/42b11a986042674bd36a48fc95b6c7924a368d61.png)

---

<div class="post-metadata">

**Author:** ![pbuydidm](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@pbuydidm](https://community.thunkable.com/u/pbuydidm)\
**Post date:** [February 5, 2021, 8:45pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/6 "2021-02-05T20:45:07Z")

</div>

Thanks a lot!  
I just changed the things according to my project and it worked perfect!!!

Thanks! 🙂

---

<div class="post-metadata">

**Author:** ![pbuydidm](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@pbuydidm](https://community.thunkable.com/u/pbuydidm)\
**Post date:** [February 6, 2021, 12:08pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/7 "2021-02-06T12:08:09Z")

</div>

Legacy.  
But I made a mistake when asked. Some blocks were not present because I forgot dragging the airtable component to the app. Sorry 🤦🏻‍♂️

---

<div class="post-metadata">

**Author:** ![pbuydidm](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@pbuydidm](https://community.thunkable.com/u/pbuydidm)\
**Post date:** [February 6, 2021, 12:09pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/8 "2021-02-06T12:09:22Z")

</div>

Thanks @muneer  
But your suggestion worked for me.

---

<div class="post-metadata">

**Author:** ![pbuydidm](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@pbuydidm](https://community.thunkable.com/u/pbuydidm)\
**Post date:** [February 6, 2021, 12:13pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/9 "2021-02-06T12:13:08Z")

</div>

Hi @domhnallohanlon  
Yes! I loaded the info about my airtable.  
I was wrong with the blocks I couldn’t find: they were there. I just forgot dragging the airtable component to the app 🤦🏻‍♂️

And @muneer gave excellent guidelines. The project is working

---

<div class="post-metadata">

**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\
**Post date:** [February 6, 2021, 3:06pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/10 "2021-02-06T15:06:38Z")

</div>

Its not working for me I can’t see the problem tried with airable and A GOOGLE SHEET

Screenshot 2021-02-06 at 19.21.57

---

<div class="post-metadata">

**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:** [February 6, 2021, 3:09pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/11 "2021-02-06T15:09:42Z")

</div>

Can you explain more?  
Can you give a copy of your blocks?

---

<div class="post-metadata">

**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\
**Post date:** [February 7, 2021, 3:44am UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/12 "2021-02-07T03:44:43Z")

</div>

Hi Muneer  
thanks for the response sorry I had uploaded the blocks but must have timed out. see below. I have tried several ways including loading to a list the results and to a database, nothing seems to work. I know there is an issue with some data types saving to airtable as I have another app that was having issues and it’s now logged as an issue so wondering if it’s something similar? I have spent several hours trying different solutions

 ![Screenshot 2021-02-06 at 19.21.57](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/e/bee6b82b687f309aa0b60863c543a8c9d6facb4f.png)

---

<div class="post-metadata">

**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:** [February 7, 2021, 7:05am UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/13 "2021-02-07T07:05:34Z")

</div>

@Tina_Fountain  
Yes this will not work. There is a restriction / limitation in the way the Airtable data is accessed. We can only get the data from the table if we supply the unique row ID generated by Airtable.

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/0/70653523996e3c03f2bca370f6ce46ce61dc90fd.png)  
In your block you are retrieving the list of “Grp” which cannot be used as row ID.

Your work is all good but you need to change “Grp” in `list of values` block and instead use “ID”. If you do this change all will work in the expected way.

Happy Thunking

---

<div class="post-metadata">

**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\
**Post date:** [February 8, 2021, 12:47am UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/14 "2021-02-08T00:47:36Z")

</div>

Brilliant, I had actually tried that, but I think I must have messed up somewhere else on that occasion it’s working now. Thanks so much

---

<div class="post-metadata">

**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:29pm UTC](https://community.thunkable.com/t/solved-get-names-from-airtable-list/1082960/15 "2024-11-08T13:29:34Z")

</div>


