Hello! I am using external database to load data from AirTable. I found out that it’s possible to filter things with formulas but is it possible to create search input field for the list? Normal database with relationships it’s easy to create input field but this seems to be more complex.

Hi @roope257 , This post may help here! [image] Search external collections External Collections, Custom Actions & Collections Hi @sweekark , Add a input component on the screen and try filtering your Airtable List like this. I tried with this formula but w…

Perfect, thanks! :slight_smile:

Hi, As a TIP already for the great answer given by @Dilon , you can also use “FIND” for this. The “SEARCH” will give empty if no results will be found, the “FIND” will return “0” if no results will be found. Choose your flavour :slight_smile:

Thanks for this information :slight_smile:

Is it possible to create button for sort a newest to oldest items?

Hi, Yes, you can use for this the sort from Airtable. I did something similar in the past. I used: Input text field (Where it will be triggered by the button) 2 buttons. One I choose newest to oldest, other I choose oldest to newest In the Airtable List, you will need to add a couple more thing…

Thanks! I will try that out later today.

Didn’t work out. :thinking: It doesn’t show anything when I use those filters. EDIT: Not sure what’s happening but the search input field which I created earlier stopped working and is messed up too. Will try tomorrow again.

Addition to the great reply by @JL_LJ ! This 2 posts may help here you too! : Dropdown custom sort filter - #4 by dilon_perera , Filtering Alphabetically with Airtable (not sorting) - #2 by dilon_perera Adalo Docs : https://help.adalo.com/integrations/external-collections-with-apis/airtable/working…

AirTable database filtering

Get Help

Dilon June 19, 2022, 5:14pm 2

Hi @roope257,

This post may help here!

Thank you

Topic		Replies	Views
Filter (text search bar) data from custom database Get Help	12	1253	April 30, 2021
Search external collections External Collections, Custom Actions & Collections	1	955	February 17, 2022
Filtering External Collection (Airtable) by Input Box / search totally stopped working Get Help	6	1378	April 2, 2021
Filter (airtable populated) list by search term? Get Help	21	5121	July 23, 2020
Filtering Alphabetically with Airtable (not sorting) External Collections, Custom Actions & Collections	2	1087	April 2, 2022

AirTable database filtering

Related topics