Automate

Hello

I have a problem with the following issue:
I have 2 fields in my form (Evolve):

1. field: Reported stock 
2. field: highest stock

User have to insert a number in these fields.
When it is a number field (property = number) and I insert the value "1.5" it changes automatically into "15" because it don't realize the point. In Switzerland we use point instead of comma.
For that reason I changed the field into a textfield (property = textbox), than I add a validation rule: if field does not pattern ("^[0-9]*$") than error.
This works perfect BUT

I add also the following rule to compare both fields 
"reported stock is not allowed to be higher than highest stock"

If I insert the value "10" in the field "highest stock" and the value "2" in the field reported stock it shows an error because the field is not a number field and the form thinks that "2" is higher than "10".

How can I solve this problem.

I need to have numbers field to compare but just numbers without decimal.

Thanks for your help.

Best regards 
Jana

Hi Jana

I would use helper fields in the same group to set numeric values using the number function, like:

number($form.getValue('/my:myFields/my:MM01_CreateMaterial/my:Input/my:Repeating_Content/my:Net_Weight_cr'))

On the original field I would trigger the above rule to set the numeric version of the field.

Then you can use an IF statement with numeric values for each.

HTH,

Sigrid

Thank you