# External Database — Not All Fields Available

**URL:** <https://forum.adalo.com/t/external-database-not-all-fields-available/23214>\
**Category:** Database\
**Created:** [February 9, 2022, 10:04pm UTC](https://forum.adalo.com/t/external-database-not-all-fields-available/23214 "2022-02-09T22:04:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![insoos](https://avatars.discourse-cdn.com/v4/letter/i/9e8a1a/32.png) [@insoos](https://forum.adalo.com/u/insoos)\
**Post date:** [February 9, 2022, 10:04pm UTC](https://forum.adalo.com/t/external-database-not-all-fields-available/23214/1 "2022-02-09T22:04:01Z")

</div>

Hey, I’m new here !

I figured out how to use the Adalo API to connect with my Airtable database.  
However, even though everything is connected, when I am using the magic text for a component, not all fields of my database are available, only 2 pops up instead of 10.

I already disconnected & reconnected and verified I have all fields available on my database.

Thanks for the help

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [February 11, 2022, 8:07am UTC](https://forum.adalo.com/t/external-database-not-all-fields-available/23214/2 "2022-02-11T08:07:00Z")

</div>

Hi @insoos,

Welcome to the forum!

When you’re connecting your Airtable DB as an external collection, please be sure that in Airtable base, in the 1st row all fields have some values.

Explanation: when Adalo creates new External Collection, it needs to understand which fields should be included. As I understand it forms the structure based on the 1st row of the reply. Airtable, in turn, does not return the field if it is empty. As a consequence Adalo doesn’t include it in the collection - it simply doesn’t know about it.

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![JL\_LJ](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@JL\_LJ](https://forum.adalo.com/u/JL_LJ)\
**Post date:** [February 11, 2022, 6:49pm UTC](https://forum.adalo.com/t/external-database-not-all-fields-available/23214/3 "2022-02-11T18:49:37Z")

</div>

Couldn’t have said it better than @Victor and as a small tip, if you add or remove fields from Airtable, remember you need to refresh the API again.