Check Whether Field Has Data

Question

How can I check whether a particular field contains data or not, using a formula?

I’m processing form submissions from Google Forms in my Zap. I need to check whether one of two fields has any data and set a checkbox in a Notion page in a later step, based on the result.

I’ve tried adding a Formatter step with a text input and a formula OR(NOT(ISBLANK(Afield 1)), NOT(ISBLANK(Afield 2]))) but that doesn’t give me the correct result.

I’d appreciate any pointers!

SamB · Accepted Answer

Hi@alexs, great question! 🙂You’re super close on this, it just looks like you need to wrap the selected Google Forms fields in quote(“”). Here’s an example of what I mean:Then it should return the value of false if either of those fields are blank, and true if either has a value.Can you try adding those quotes and let us know if that sorts it?

alexs · Answer

Hi @SamBthanks for this, I’ll need to do a bit more testing to be sure but it looks like that works🙌

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded