Search external collections

[sweekark]

Hi Team,

We would need any pointers to any doc on searching external collections,
i see there is already an topic open on this
any help on this regard will be really appreciated

Search list based on external Airtable collection?

How can I use the search feature on a list based on Airtable? I have seen the guidance provided for the internal Search List screen. However, once I an external collection (Airtable), the configuration for the search filer changes changed, and doesn’t provide search features. We need it! Any pointers?

[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