Search external collections

[dilon_perera]

Hi @sweekark,

Add a input component on the screen and try filtering your Airtable List like this.

Filter (airtable populated) list by search term?

@ldyer Hi Luke, I am using the following: In Adalo: Input field Search1 for the search: [image] [image] A List with based on external collection [image] with following filter: [image] 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: [image]

I tried with this formula but when I type simple a in the search box I get the items that has simple a but I don’t get the items start with capital A. And when I type capital A I get the items that start with capital A only.

And I tried with the formula that Karimo posted and when I type simple a I’m getting the items that has simple a and items that start with capital A. And when I type capital A I get the items that have simple a and start with capital A.

Hope I’m correct!

Thank you