Greater than or Equal to

  • DreamCalisthenics
    Asked on June 7, 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

  • BJoanna
    Replied on June 7, 2017 at 3: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. 

    Greater than or Equal to Image 1 Screenshot 20

    Let us know if you need further assistance. 

  • DreamCalisthenics
    Replied on June 8, 2017 at 2:21 AM

    Hi. Thanks for that.

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

  • BJoanna
    Replied on June 8, 2017 at 4: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.

    Greater than or Equal to Image 1 Screenshot 40

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

    Greater than or Equal to Image 2 Screenshot 51

    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. 

    Greater than or Equal to Image 3 Screenshot 62

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