Best answer

Check if a field is a number

  • 1 September 2020
  • 2 replies
  • 198 views

Userlevel 1

Dear All,

In my first step we receive info on a field that should be a number but sometimes we receave a text on this field.

How could i check this in order to send the info to my output field (number)?

Is there any formula that checks this? something like

  • IF isnumber(step1.inputField) then step2.outFieldNumber = step1.inputField else step2.outFieldNumber = 0

 

Regards

icon

Best answer by Danvers 3 September 2020, 12:54

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.

2 replies

Userlevel 7
Badge +12

You can use the Formatter action ‘Spreadsheet style formula’ (It’s under Numbers) to create a formula like that. This Community post has some examples of how folks have used Spreadsheet style formulas to create if statements: 

 

The bit that I’m not sure of is how to check whether or not a field is a number, so I hope that this piece of the puzzle helps!

Can you share what you figured out? I have this exact situation and curious to what the formula was?