Conditions not dynamic enough - Need more 'state' options and OR/AND logic!

  • evo_forms
    Asked on July 9, 2019 at 5:07 PM

    It would be great if the conditions were a bit more dynamic. For instance, we sell camps through JotForm and a certain camp session is limited to children ages 5 and under. I would like to easily say "if field 'participant's age' is greater than 5 AND the 'camp session' selected is (certain camp date) SHOW text field 'Warning:...'" however, the only options for field state in regards to amount is 'equal to' or 'not equal to'. It would be great if there were field states for 'greater than' 'less than' or 'greater than or equal to' and 'less than or equal to' as well. 

    Additionally, I was attempting to work around that restriction by making a statement for each age 1-5 - so saying 'participants age' is not equal to '1' OR '2' OR '3'. However I would have to use both OR and a AND statement such as "if participants age is not equal to '4' OR Participants age is not equal to '5' AND the 'camp session' selected is (certain camp date) SHOW text field 'Warning:...'." however, JotForm doesn't currently allow for OR and AND logic in the same condition you can only select between ANY or ALL for your entire statement.

    Please JotForm, update your conditional logic to be more dynamic! 

  • jonathan
    Replied on July 9, 2019 at 6:47 PM

    It would be great if there were field states for 'greater than' 'less than' or 'greater than or equal to' and 'less than or equal to' as well. 

    I understand what you were referring to. But actually this is possible already.

    The field states '<>='  is available for numeric field types.

    It so happen that the field on your form was the Short Entry (text type) field the reason the condition state was not available.

    Example, I used the Number field instead of the Textbox(short entry field).

    1562712070zzz 2019 07 10 06 Screenshot 10


    in the Conditions those mentioned state values becomes available.

    1562712110zzz 2019 07 10 06 Screenshot 21


    ---

     However I would have to use both OR and a AND statement such as "if participants age is not equal to '4' OR Participants age is not equal to '5' AND the 'camp session' selected is (certain camp date) SHOW text field 'Warning:...'." however, JotForm doesn't currently allow for OR and AND logic in the same condition you can only select between ANY or ALL for your entire statement.


    This is also possible. You just need to create multiple conditional statements for the different values.

    You can use multiple IF rules on one condition statement and then create multiple conditional statement as well.

    Example:

    1562712450zzz 2019 07 10 06 Screenshot 32



    I hope this help. Let us know if you need further assistance.