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?
Best answer by Troy TessaloneView original
Can you post screenshots of a few examples with how the data comes in on the Zap trigger from YCBM?
How many different sizes are there?
Technically infinite, but it really is the following:
¼, ½, ¾, 1, 1¼, 1 ½, 1 ¾, 2
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!