Skip to main content
Best answer

Changing text to number value

  • 4 January 2022
  • 6 replies
  • 232 views

Hi,

I am trying to check if a value that I receive from a YouCanBookMe me field is larger than 1. The field in YCBM is a text (since it is an input on their form) and it comes in as a fraction (i.e. 1/2).  I am trying to find a way to convert this string to a number and then compare to see if it is larger than 1. 

I’ve tried using Formatter Numbers but it does not seem to work.  Any ideas?

Thanks!

That worked, thank you!

@zapfan1

You could create a Lookup Table to do the translation: https://zapier.com/help/create/format/create-lookup-tables-in-zaps

Technically infinite, but it really is the following:
¼, ½, ¾, 1, 1¼, 1 ½, 1 ¾, 2

@zapfan1 

How many different sizes are there?

@Troy Tessalone thanks for the reply.  Here is the data example and what I was trying to do:

 

 

 

Hi @zapfan1 

Can you post screenshots of a few examples with how the data comes in on the Zap trigger from YCBM?

Terms & Conditions