Best answer

Changing text to number value

  • 4 January 2022
  • 6 replies
  • 140 views

Userlevel 1

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!

icon

Best answer by Troy Tessalone 4 January 2022, 18:28

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.

6 replies

Userlevel 7
Badge +14

Hi @zapfan1 

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

Userlevel 1

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

 

 

 

Userlevel 7
Badge +14

@zapfan1 

How many different sizes are there?

Userlevel 1

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

Userlevel 7
Badge +14

@zapfan1

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

Userlevel 1

That worked, thank you!