Best answer

Check Whether Field Has Data

  • 29 March 2023
  • 3 replies
  • 267 views

Userlevel 1

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!

icon

Best answer by SamB 29 March 2023, 15:42

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +11

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:
3625118127dcf6ca097daaf425a02072.png
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?

Userlevel 1

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

Userlevel 7
Badge +11

Glad to hear it, @alexs! I’m so pleased that seems to have done the trick.

Happy Zapping! 😄⚡🎉