Can I have a numerical formula define a minimum or maixmum value for a numerical input field?

  • Profile Image
    Asked on April 22, 2015 at 06:40 AM

    We need to create a sales order form.

    This form needs to take in numerical dimensions for the product.

    Some of the dimensions are dependent upon other dimensions.  All the dimensions have minimums and maxium values.  Can I use a formula to define a minimum or maximum value where this formula is dependent upon an input in another numerical field?




    Dimension 1 = 1000 (min = 500, Max = 1440)

    Dimension 2 = 500 (min = 500, Max = Dimension 1 / 2)



  • Profile Image
    Answered on April 22, 2015 at 11:00 AM

    I created a test form, where I added numeric fields, under Quick Tools menu, and then added Text field messages warning that the values must be lower than or higher than:

    I then created conditions that if dimension1 value is higher/lower than max/min to show the correspondent error message:

    On the condition I added the min and max fields name. You can see here how to find a field's name: 

    You can test and clone the demo form: 

    Let us know if we can assist you further.