# Research an empty field

**URL:** <https://integration.keap.com/t/research-an-empty-field/27874>\
**Category:** Max Classic\
**Created:** [January 19, 2018, 10:27am UTC](https://integration.keap.com/t/research-an-empty-field/27874 "2018-01-19T10:27:01Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thibaut\_Holl](https://avatars.discourse-cdn.com/v4/letter/t/73ab20/32.png) [@Thibaut\_Holl](https://integration.keap.com/u/Thibaut_Holl)\
**Post date:** [January 19, 2018, 10:27am UTC](https://integration.keap.com/t/research-an-empty-field/27874/1 "2018-01-19T10:27:01Z")

</div>

Hi there,

I have been trying to make identify contacts that have empty fields - for instance, contact with a missing city on their contact record. What would be my best bet?

---

<div class="post-metadata">

**Author:** ![Cheryl\_Hunt](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/cheryl_hunt/32/287_2.png) [@Cheryl\_Hunt](https://integration.keap.com/u/Cheryl_Hunt)\
**Post date:** [January 19, 2018, 1:51pm UTC](https://integration.keap.com/t/research-an-empty-field/27874/2 "2018-01-19T13:51:16Z")

</div>

The easiest way to search for contacts with empty fields is to go to Contacts \> Misc Criteria Tab \> Scroll down to “Data Exists” and there is an option to select from most of the standard fields and “Doesn’t have a value.” It doesn’t include custom fields, but you can go to the Custom Fields tab and choose a field and then select “Doesn’t include” and then in the field try an underscore " \_ " which is a wildcard.

You can also run Legacy action sets with rules - but the way above may be your easiest bet especially for something like city.

---

<div class="post-metadata">

**Author:** ![Thibaut\_Holl](https://avatars.discourse-cdn.com/v4/letter/t/73ab20/32.png) [@Thibaut\_Holl](https://integration.keap.com/u/Thibaut_Holl)\
**Post date:** [January 20, 2018, 1:04pm UTC](https://integration.keap.com/t/research-an-empty-field/27874/3 "2018-01-20T13:04:38Z")

</div>

Great - thanks for the answer Cheryl.

Now what I was really trying to do is classify my contact per mini geographical zones within a main city.

What I’ve done is create a campaign that apply a ‘zone tag’ to my contacts depending on their suburbs. I’ve broken down the city in 13 zones, each zones has about 10 suburbs. I’ve used a decision diamond to decide which tag to apply.

Now the issue come when the contact’s “city” field is left blank or if the suburb hasn’t been entered correctly (typo) - I was hoping to create a 14th sequence that catches all those mistakes or blank field.

Hope this makes sense? Any ideas?

---

<div class="post-metadata">

**Author:** ![Christoph\_Dill](https://avatars.discourse-cdn.com/v4/letter/c/ac91a4/32.png) [@Christoph\_Dill](https://integration.keap.com/u/Christoph_Dill)\
**Post date:** [April 18, 2018, 5:49pm UTC](https://integration.keap.com/t/research-an-empty-field/27874/4 "2018-04-18T17:49:28Z")

</div>

I was very glad that you highlighted that “Data Exists” option. Now I walked in today and just figured that they finally have enabled the check for empty / filled field directly on the field when searching. I might have been blind, but I think this is fairly new…

---

<div class="post-metadata">

**Author:** ![John\_Borelli](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/john_borelli/32/11880_2.png) [@John\_Borelli](https://integration.keap.com/u/John_Borelli)\
**Post date:** [April 18, 2018, 8:01pm UTC](https://integration.keap.com/t/research-an-empty-field/27874/5 "2018-04-18T20:01:38Z")

</div>

It’s been in place for a while but it’s seldom talked about 😜

---

<div class="post-metadata">

**Author:** ![Christoph\_Dill](https://avatars.discourse-cdn.com/v4/letter/c/ac91a4/32.png) [@Christoph\_Dill](https://integration.keap.com/u/Christoph_Dill)\
**Post date:** [April 19, 2018, 2:54pm UTC](https://integration.keap.com/t/research-an-empty-field/27874/6 "2018-04-19T14:54:00Z")

</div>

right, I rememberd, I was actually desperately looking for this option in a decision diamond, unfortunately still not there…
