# Airtable: Get a Column Name from a value (multiple tables)

**URL:** https://community.thunkable.com/t/airtable-get-a-column-name-from-a-value-multiple-tables/951908
**Category:** Questions about Thunkable X
**Created:** [November 4, 2020, 2:54pm UTC](https://community.thunkable.com/t/airtable-get-a-column-name-from-a-value-multiple-tables/951908 "2020-11-04T14:54:42Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)
#### Post date: [November 4, 2020, 2:54pm UTC](https://community.thunkable.com/t/airtable-get-a-column-name-from-a-value-multiple-tables/951908/1 "2020-11-04T14:54:42Z")

</div>

Hi everybody.  
I’m really struggling with this: i am using a searching bar as i read all of the posts on the topic here, it works efficently.

Now i’m doing another one but there’s one problem. The app is a Cocktail recipes app and, in this case, I have 3 different Airtables for each category (Contemporary Classics, The Unforgettables, New Era).  
Every ColumnName is the name of the cocktail itself and on the rows beneath there are few fields about recipe, total views, ecc…

I need this:  
when an user types into the searching bar, the app gives the name of all the cocktails that contain that part of the word, wither if they are contained in Contemporary,Unforgettables or New Era.  
Also, how can I get the Column name? There’s no such a way to use the “GetRows” from “ID” as they are the Column Name. How can i get all the names of those columns, so i can put them into a list and be searched and be looked to with the use of the search bar?  
Sorry I know it sounded complicated, hope this image helps.

![](https://i.postimg.cc/d0yZmL0M/aiuto-Thunkable.png)

Thank you

---

<div class="post-metadata">

### 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: [November 9, 2020, 11:20am UTC](https://community.thunkable.com/t/airtable-get-a-column-name-from-a-value-multiple-tables/951908/2 "2020-11-09T11:20:10Z")

</div>

[maurizio.polverini89](http://community.thunkable.com/u/maurizio.polverini89),

Using the drinks as column names is going to cause you some trouble. You might consider pivoting your data so you have 2 (or more columns). Something like this

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

If you REALLY want to have a column for each drink, you can use the GetSelectedRows block and get the first row of the AirTable. You can then use the resulting JSON object to determine all of the column names.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/8/28931069f6acb9b0a6c9f96c1f7a33a46aa5c56e.png)  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/9/a926bbdeb494b422a87deda454a079d4f57ee9bd.png)

Happy Thunking!

---

<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, 12:21pm UTC](https://community.thunkable.com/t/airtable-get-a-column-name-from-a-value-multiple-tables/951908/3 "2024-11-08T12:21:45Z")

</div>



---

<div class="post-metadata">

### Author: ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)
#### Post date: [December 19, 2024, 5:01pm UTC](https://community.thunkable.com/t/airtable-get-a-column-name-from-a-value-multiple-tables/951908/4 "2024-12-19T17:01:09Z")

</div>