Greater than or Equal to

  • Profile Image
    bmanfield
    Asked on June 07, 2017 at 12:58 AM

    Hi,

    I need an age field to be 'greater than or equal to' to permit people qualify. (ie to be 18 or older) I don't want their age to be greater than 17.999 because still isn't 18. Because I am doing calculations based upon DOB decimal places are a factor.

    How can this be done?

    Cheers

    Ben

  • Profile Image
    BJoanna
    Answered on June 07, 2017 at 03:00 AM

    I have inspected your form http://www.jotform.co/form/70456811693865 and I saw that you have already set calculation for age. 

    If you do not want to use greater than 17.999, then I would suggest you to use two if rules inside of your condition (if equal to 18 and if greater then 18), like this. 

    Let us know if you need further assistance. 

  • Profile Image
    bmanfield
    Answered on June 08, 2017 at 02:21 AM

    Hi. Thanks for that.

    How do you set age ranges? ie >= 17 but < 18

  • Profile Image
    BJoanna
    Answered on June 08, 2017 at 04:02 AM

    Do you want to set conditions for values that are Greater than or Equal to 17 and less then 18? 

    For this you will not be able to use Greater than, Equal and Less then option inside of same conditions. 

    For example if you set your condition like this, any age will trigger condition, because one of the if rules will be met.

    And if use use If ALL option, then condition will never be met. 

    For this you  will have to use Starts With conditional state. However this state is not available for Number field, so you will have to use text box field, to use this option. You can pass value from Age field to some text box field and set this condition. 

    Hope this will help. Let us know if you need further assistance.