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([field 1)), NOT(ISBLANK([field 2]))) but that doesn’t give me the correct result.
I’d appreciate any pointers!
Best answer by SamB
Hi
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?
+11Hi
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?
Hi
+11Glad to hear it,
Happy Zapping! 😄⚡🎉
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
