# Fillter when a column is null/empty

**URL:** <https://forum.adalo.com/t/fillter-when-a-column-is-null-empty/143>\
**Category:** Get Help\
**Created:** [January 22, 2020, 5:22am UTC](https://forum.adalo.com/t/fillter-when-a-column-is-null-empty/143 "2020-01-22T05:22:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![PWE](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@PWE](https://forum.adalo.com/u/PWE)\
**Post date:** [January 22, 2020, 5:22am UTC](https://forum.adalo.com/t/fillter-when-a-column-is-null-empty/143/1 "2020-01-22T05:22:02Z")

</div>

Any one know how I can place a filter when a particular column is null/empty and when a particular column has value?

Alternatively, is there a wild card character when doing searches?

---

<div class="post-metadata">

**Author:** ![PWE](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@PWE](https://forum.adalo.com/u/PWE)\
**Post date:** [January 22, 2020, 5:45am UTC](https://forum.adalo.com/t/fillter-when-a-column-is-null-empty/143/2 "2020-01-22T05:45:31Z")

</div>

Figured it out.

No wild card needed, just just need to leave the filter literally empty and change the “is equal to” / “is not equal to” only.

And you need to show the actual column on the form list if you want to use said column as filters.

---

<div class="post-metadata">

**Author:** ![Rodrigo\_Serpa](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@Rodrigo\_Serpa](https://forum.adalo.com/u/Rodrigo_Serpa)\
**Post date:** [September 5, 2020, 4:27pm UTC](https://forum.adalo.com/t/fillter-when-a-column-is-null-empty/143/3 "2020-09-05T16:27:49Z")

</div>

Yes @PWE, I had the same doubt but it´s worked well like that 🙂