AirTable filters not working correctly

Hello!

I have list which is loaded from AirTable database. I made basic drop down filtering which is working but I also need search input filter as option. Every time when I add the search input filter, it breaks the whole list and nothing is showing. If I delete the input filter, everything works again. :thinking:

Hi,
I think those wrong placed quotes are doing that for you!

image.

You also have parenthesis misplaced.

Search(LOWER(‘Input4’),LOWER({Response docs kunta}))

2 Likes

This forum is amazing. :smiley: I used many hours to see what’s wrong but didn’t see that… Now it works! Thanks!

1 Like

So now you have more time to some more Adaloing :smiley: .

1 Like

Yep! Sorry for bothering but in other list I have another filterByFormula so now when I added the search input it breaks the earlier added filterbyformula.

Is there way to put 2 filters in one? I mean use one filterbyformula and add the first one and search input in same?

In this case you use and AND(logic 1, logic 2) also the “OR”, depends on your case, you don’t use twice “filterByFormula”.

1 Like

EDIT: Got it work now! :slight_smile:

1 Like

:smiley: , You got tricked again by the parenthesis :stuck_out_tongue:

image

Haha yep! :smiley: Had to test many times before I got it work. I hate this kind of “coding”.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.