# AirTable filters not working correctly

**URL:** <https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490>\
**Category:** Get Help\
**Created:** [June 20, 2022, 3:23pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490 "2022-06-20T15:23:32Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![roope257](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@roope257](https://forum.adalo.com/u/roope257)\
**Post date:** [June 20, 2022, 3:23pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/1 "2022-06-20T15:23:33Z")

</div>

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. 🤔

 ![ss1](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/e/b/ebd6a6d035ff8fe37edc5182b87efec23cafbade.png)

---

<div class="post-metadata">

**Author:** ![JL\_LJ](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@JL\_LJ](https://forum.adalo.com/u/JL_LJ)\
**Post date:** [June 20, 2022, 3:31pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/2 "2022-06-20T15:31:06Z")

</div>

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

![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/0/0/0030acafed6933b5145721b41b4f09f9d4154076.png).

You also have parenthesis misplaced.

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

---

<div class="post-metadata">

**Author:** ![roope257](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@roope257](https://forum.adalo.com/u/roope257)\
**Post date:** [June 20, 2022, 3:36pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/3 "2022-06-20T15:36:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![JL\_LJ](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@JL\_LJ](https://forum.adalo.com/u/JL_LJ)\
**Post date:** [June 20, 2022, 3:39pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/4 "2022-06-20T15:39:26Z")

</div>

So now you have more time to some more Adaloing 😃 .

---

<div class="post-metadata">

**Author:** ![roope257](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@roope257](https://forum.adalo.com/u/roope257)\
**Post date:** [June 20, 2022, 3:41pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/5 "2022-06-20T15:41:32Z")

</div>

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?

 ![ss1](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/a/8/a8a018aa0e515dbff948a806bfc3954d2c85a7d3.png)

---

<div class="post-metadata">

**Author:** ![JL\_LJ](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@JL\_LJ](https://forum.adalo.com/u/JL_LJ)\
**Post date:** [June 20, 2022, 3:46pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/6 "2022-06-20T15:46:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![roope257](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@roope257](https://forum.adalo.com/u/roope257)\
**Post date:** [June 20, 2022, 4:01pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/7 "2022-06-20T16:01:47Z")

</div>

EDIT: Got it work now! 🙂

---

<div class="post-metadata">

**Author:** ![JL\_LJ](https://avatars.discourse-cdn.com/v4/letter/j/f08c70/32.png) [@JL\_LJ](https://forum.adalo.com/u/JL_LJ)\
**Post date:** [June 20, 2022, 4:10pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/8 "2022-06-20T16:10:00Z")

</div>

😃 , You got tricked again by the parenthesis 😛

![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/3/5/358bf7e850a92be5d4d800f1a9de3a8cfcd0155e.png)

---

<div class="post-metadata">

**Author:** ![roope257](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@roope257](https://forum.adalo.com/u/roope257)\
**Post date:** [June 20, 2022, 4:14pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/9 "2022-06-20T16:14:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [June 30, 2022, 4:14pm UTC](https://forum.adalo.com/t/airtable-filters-not-working-correctly/28490/10 "2022-06-30T16:14:59Z")

</div>

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