Best answer

Filter for "not null"


Userlevel 2

I am building a zap to enter fields into a form.    I only want it to trigger if the student name is not null.   Seems like  a simple question! 

I thought it would be the “exists” filter, but that is coming back as true even when the student name is null.    Which criteria should I use?

icon

Best answer by Jonathan Santos 16 September 2020, 17:12

View original

10 replies

Userlevel 7
Badge +10

Hi @kenser 

When you check Zapier history, is that field coming through blank or with the world ‘null’?

Unless that field is entirely blank exist=true.

Userlevel 2

It is empty --- completely blank.

However “exists” filter is returning true.

Userlevel 7
Badge +10

Ok @kenser 

I'm going to flag this post for the Zapier Community Team. They should have more insight on this and can escalate to the support team if needed.

Sit tight, and someone will contact you soon.

Userlevel 7
Badge +8

Hi @kenser - thank you for your patience.

I’ve escalated your issue to the investigation team here at Zapier with the information you have provided.

Userlevel 7
Badge +11

Hi @kenser!

I'm checking in with you here, since I don’t see a response to the message that our Support team had sent you. Have you managed to resolve things or did you still need help here? Please let us know :)

Userlevel 1

Hi, I’m using Default Value transform to put a random text in my blank field.

After that, I use filter step based on this random text that it will only be applied when this variable was empty.

Userlevel 7
Badge +8

Thanks for sharing @Jonathan Santos !

Userlevel 1

This is really dumb. I went through a similar issue today, and couldn’t do something as simple as “only continue if field X is not empty”, I had to find a workaround for such a pretty basic use case.

Userlevel 7
Badge +12

Hi @Unly!

Usually the filter conditions ‘Exists’ and ‘Does not exist’ work for filtering based on whether or not there is data in a field. It sounds like you had a frustrating time with data that didn’t work with those conditions. I’m sorry that the filter didn’t work as you needed it to, but I’m glad that you were able to find a workaround here!

Hi @Unly!

Usually the filter conditions ‘Exists’ and ‘Does not exist’ work for filtering based on whether or not there is data in a field. It sounds like you had a frustrating time with data that didn’t work with those conditions. I’m sorry that the filter didn’t work as you needed it to, but I’m glad that you were able to find a workaround here!

 I agree with Unly. What’s the point of the exists condition if it doesn’t check for if something exists or not?
why do we need two more steps to use an exists condition?

Reply