Conditional Logic question - How do I do this?

  • Profile Image
    CNSTradingLtd
    Asked on March 23, 2017 at 02:54 PM

    For this Form:

    https://form.jotformeu.com/70813913898367

     

    How do I do this?

     

    IF Age Child 1 31/08/2016 GREATER THAN "11" INSERT 120 INTO Payment

    and 

    IF Age Child 2 31/08/2016 GREATER THAN "11" INSERT 175 INTO Payment

     

  • Profile Image
    david
    Answered on March 23, 2017 at 05:43 PM

    Create a conditions as follows:

    IF Age Child 1 GREATER THAN 11

    IF Age Child 2 LESS THAN 11

    IF All rules are matched

    INSERT  120

    IF Age Child 1 GREATER THAN 11

    IF Age Child 2 GREATER THAN 11

    IF All rules are matched

    INSERT  175

    You could create a third condition that would be similar to the first if the age for the second child could potentially be empty:

    IF Age Child 1 GREATER THAN 11

    IF Age Child 2 IS EMPTY

    IF All rules are matched

    INSERT  120