# Help to filter with airtable

**URL:** <https://forum.adalo.com/t/help-to-filter-with-airtable/4375>\
**Category:** Get Help\
**Created:** [September 25, 2020, 5:33pm UTC](https://forum.adalo.com/t/help-to-filter-with-airtable/4375 "2020-09-25T17:33:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wendell](https://avatars.discourse-cdn.com/v4/letter/w/e9bcb4/32.png) [@Wendell](https://forum.adalo.com/u/Wendell)\
**Post date:** [September 25, 2020, 5:33pm UTC](https://forum.adalo.com/t/help-to-filter-with-airtable/4375/1 "2020-09-25T17:33:32Z")

</div>

Hello I would like your help to try to solve a problem, I am making a filter in a list using a table in AirTable, however this filter is combined by AND and OR I read in Documents from the air airtable that it is necessary to create an IF to combine AND and OR, the problem is that when my search field is EMPTY (default of ADALO) the query goes crazy. Is that a bug?

![Captura de Tela 2020-09-25 às 14.29.41](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/c/c7e0d8a76f7e691888aeefc03aad492dbef45659.png)

---

<div class="post-metadata">

**Author:** ![Wendell](https://avatars.discourse-cdn.com/v4/letter/w/e9bcb4/32.png) [@Wendell](https://forum.adalo.com/u/Wendell)\
**Post date:** [September 25, 2020, 7:19pm UTC](https://forum.adalo.com/t/help-to-filter-with-airtable/4375/2 "2020-09-25T19:19:27Z")

</div>

I discovered the problem, every time the text entry is initialized as empty it deletes the content of the filterByFormula field

---

<div class="post-metadata">

**Author:** ![NoCodeJedi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/nocodejedi/32/414_2.png) [@NoCodeJedi](https://forum.adalo.com/u/NoCodeJedi)\
**Post date:** [September 25, 2020, 7:43pm UTC](https://forum.adalo.com/t/help-to-filter-with-airtable/4375/3 "2020-09-25T19:43:15Z")

</div>

Hi Wendell,

How did you fix it then? 🙂

Francisco

---

<div class="post-metadata">

**Author:** ![Wendell](https://avatars.discourse-cdn.com/v4/letter/w/e9bcb4/32.png) [@Wendell](https://forum.adalo.com/u/Wendell)\
**Post date:** [September 28, 2020, 2:27am UTC](https://forum.adalo.com/t/help-to-filter-with-airtable/4375/4 "2020-09-28T02:27:29Z")

</div>

1. I set the default of the search field with a blank space, this is different from empty

2. I used the trim function inside the search parameter, that is, there is always a blank space in the field but in the search it is removed .

---

<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:** [October 8, 2020, 2:27am UTC](https://forum.adalo.com/t/help-to-filter-with-airtable/4375/5 "2020-10-08T02:27:31Z")

</div>

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