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.
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.