# How to get all Airtable Multiple Select items to show up in Thunkable?

**URL:** <https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732>\
**Category:** Web API's\
**Tags:** beginner, airtable\
**Created:** [May 31, 2022, 8:41pm UTC](https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732 "2022-05-31T20:41:00Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![aliadubright5cx7x1](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@aliadubright5cx7x1](https://community.thunkable.com/u/aliadubright5cx7x1)\
**Post date:** [May 31, 2022, 8:41pm UTC](https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732/1 "2022-05-31T20:41:00Z")

</div>

When using a Multiple Select Field Type in Airtable, only the first selection shows up in Thunkable table.  
Here is the Multiple Select column in Airtable and the multiple selections made for each of the records:  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/0/d02a9eafa0845e912ab44322f440621b8df74530.png)

And here is the data in Thunkable, where it only includes the first choice:  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/1/c143e19a96bc2a0a5ea064b6932d4bcac248f3b0.png)

Even in blocks when told to display information from that column, only the first selections from each record appear. So how do I get Thunkable to include **all** selections in Airtable’s Multiple Select field type?

---

<div class="post-metadata">

**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:** [May 31, 2022, 10:43pm UTC](https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732/2 "2022-05-31T22:43:15Z")

</div>

To get those values, I think you’ll need to use Airtable API’s filterByFormula.

There are a few topics related to that, such as this:

> [@Filter data spreadsheet/ local table](https://community.thunkable.com/t/filter-data-spreadsheet-local-table/1883156/2):
>
> I’ve used Airtable for this because you can [filterByFormula](https://support.airtable.com/hc/en-us/articles/223247187-How-do-I-sort-filter-or-retrieve-ordered-records-in-the-API-) and get the results from the Airtable API. That doesn’t modify the data at all so many users can filter the same data in different ways without affecting each other. You can see a discussion of that here: And here:

---

<div class="post-metadata">

**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:** [June 1, 2022, 7:44am UTC](https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732/3 "2022-06-01T07:44:38Z")

</div>

This post and the ones that follow it suggest this is possible:

> **[filterByFormula - multiple select](https://community.airtable.com/t/filterbyformula-multiple-select/2075/12)**
>
> I managed using OR (FIND (" linked\_record\_id ", Column)\> 0) I believe this is less performative, as it is a string comparator on the server. Only when I have many records will I be able to know the impact of this. I was surprised to learn that...

---

<div class="post-metadata">

**Author:** ![aliadubright5cx7x1](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@aliadubright5cx7x1](https://community.thunkable.com/u/aliadubright5cx7x1)\
**Post date:** [June 6, 2022, 4:03am UTC](https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732/4 "2022-06-06T04:03:05Z")

</div>

I don’t understand how to use these tools/codes, I’m a beginner at both Thunkable and Airtable. So far all I’ve done is make a small spreadsheet in Airtable and linked & displayed it in Thunkable.

---

<div class="post-metadata">

**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:** [June 6, 2022, 4:27am UTC](https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732/5 "2022-06-06T04:27:14Z")

</div>

What I suggested is pretty advanced use of Thunkable.

So I recommend you instead try to convert the multiple item column into a single item/string in Airtable.

---

<div class="post-metadata">

**Author:** ![aliadubright5cx7x1](https://avatars.discourse-cdn.com/v4/letter/a/4af34b/32.png) [@aliadubright5cx7x1](https://community.thunkable.com/u/aliadubright5cx7x1)\
**Post date:** [June 6, 2022, 6:34pm UTC](https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732/6 "2022-06-06T18:34:48Z")

</div>

Okay thank you, I’m marking your filterByFormula answer as the solution since it is the answer even if it’s not an answer I can use right now

---

<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:13pm UTC](https://community.thunkable.com/t/how-to-get-all-airtable-multiple-select-items-to-show-up-in-thunkable/1904732/7 "2024-11-08T13:13:15Z")

</div>


