How to auto calculate form field using if/ then logic?

  • kappa_psi
    Asked on October 4, 2018 at 5:08 PM

    Example:

    1) How many members did you have in 2017?

    2) How many members did you have in 2018?


    Here is the logic I want to apply:

    If # of members in 2018 is greater or equal to 2017, answer = 100

    If # of members in 2018 is less than 2017, answer = 0

  • Mike
    Replied on October 4, 2018 at 7:14 PM

    You may try the following set up:

    - Add 3 Number fields. The default value of the calculation field is set to 0.

    How to auto calculate form field using if/ then logic? Image 1 Screenshot 40

    - Add an Update / Calculate Field condition.

    How to auto calculate form field using if/ then logic? Image 2 Screenshot 51

    How to auto calculate form field using if/ then logic? Image 3 Screenshot 62

    Test form:

    https://form.jotform.com/82767175841972

    This is how you can clone that form to check it in the editor:

    How to Clone an Existing Form from a URL