Automate

 View Only
  • 1.  Evolve Form Field property question

    Posted 02-27-2023 02:04

    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



    ------------------------------
    Jana Kuschmierz
    Rigips AG
    ------------------------------


  • 2.  RE: Evolve Form Field property question

    Employee
    Posted 02-27-2023 16:39

    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



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: Evolve Form Field property question

    Posted 03-03-2023 10:55

    Thank you



    ------------------------------
    Jana Kuschmierz
    Rigips AG
    ------------------------------