I’m trying to connect my airtable to my project. Just a table with test stuff to see if Adalo can match with my needs and go further. It passes the connection test but some fields are missing in the external collection.
For example I have a field named Telephone. In my airtable, some rows have this field empty and some fill. For testing, I tried to put stuff in this field for every row and it worked then in Adalo. But I can’t keep fake wrong values in my table if I go further with Adalo and if I rollback my datas to the right ones, it remove the field.
When you set up the connection to Airtable, Adalo needs to know which fields does this table have. The only way for it to “make a guess” is to send the request to Airtable, get first few result rows, parse them and create the field structure.
As I remember in some cases Airtable tends to “skip” returning the fields which are empty in a row. E.g. if you have 3 rows: Name, Surname, Age, and if the Age row is empty, Airtable may not return the key “Age” at all. As a result, Adalo won’t be able to know about the existence of such field and will not add it to the structure.
So the rule of thumb is to fill in all fields with values in the first row in Airtable table, before setting up connection to External Collection in Adalo. With this, Airtable will return all fields with keys&values, and Adalo will be able to recognize the structure properly.
