About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Setting a value value if a field is great than 0

  • 22 May 2023
  • 5 replies
  • 338 views
Z
Userlevel 1

Hey all, I am guessing this is a pretty easy question but I am stuck.  I have a Google form with a check list.  When there is a submission in the form I have Zapier check if certain items were selected from the checklist. For that I am using Formatter and using the Find function checking if the text of the checkbox is included in the input which gives -1 if it is not and otherwise the first position of the value in the text.


So far so good.  However, I am now trying to send an email that if a certain value is included then I put a Yes for that field.

For example, lets say my form includes apples and oranges.  I check to see if either was selected and then send an email saying: “Do you want Apple: Yes/No”.  However, I cannot figure out how to check if the output of the Find is >=0 and then use that result to put a “Yes” in the email.


Thanks!

icon

Best answer by Danvers 25 May 2023, 12:20

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.

5 replies

christina.d
Userlevel 7
Badge +9

Hey there,  @zapfan1! Thanks for reaching out in community - we’re excited to have you. 🙂

I wonder if we could use Paths by Zapier here? We might be able to use this to handle the comparison piece. Since we’re looking for a specific value we may need to set the rule as “only continue if  ‘greater than -2’ and ‘less than 0’ for Path A

Path B could be “only continue if ‘greater than -1’”

From there we could set a Path depending on the results to send a different email depending on the result - one sending a “Yes” email and another a “No” email. 

Do you think that could work? Let us know!

Z
Userlevel 1

@christina.d Thanks for the reply.  The issue is that we want to continue regardless of whether the value if >=0 or below a 0.  And since we have three possible options in the checklist we would have to create a ton of paths and then the steps after the step would need to be replicated. I thought there has to be an easy way to check if a value is >=0 and then set a variable…. any thoughts?

Danvers
Userlevel 7
Badge +12

Hi @zapfan1!

I think the best way to do this would be using the ‘Spreadsheet style formula’ action in Formatter by Zapier. 

You can find the Spreadsheet style formula action in Formatter under ‘Numbers’. It allows you to use the kind of formula you would use in an app like Google Sheets or Excel. In this case, we can create a formula that says if the input is 0 equal to or less than zero, output “yes” and if not, output no. The formula you’d need would be this:

 if([value]<=0, "yes", "no")

Unlike Google or excel, you don’t need to add an equals sign ahead of the formula. Where I’ve written [value] add the relevant information from Google Form. The Formatter step will then output the word yes or no, and you can add that output into the email. 

That will definitely convert a number into a yes or no value based on the number, does that line up with what you’re looking for in this case (for this Zap)?

​Let us know if you have any questions!

Z
Userlevel 1

@Danvers you rock! That worked

Danvers
Userlevel 7
Badge +12

Awesome! Happy to help 😃

Terms & Conditions