Skip to main content

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!

Hi @zapfan1 

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


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

 

 

 


@zapfan1 

How many different sizes are there?


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


@zapfan1

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


That worked, thank you!