@ldyer Hi Luke, I am using the following:
In Adalo:
Input field Search1 for the search:
A List with based on external collection 
with following filter:
Note the LOWER in the formula as the Search function in Airtable is case sensitive.
In Airtable
In table Appointments I am using a formula field Search to collect a columns I want to search on:
