How to prepopulate calculation field only after input from another fields

  • coigis
    Asked on May 26, 2015 at 12:04 PM

    I hope I can describe my situation in a clear way, here it goes.

    When my form loads, the Status field (blue box) shows Invalid. It is based on the condition of other fields. If OCPDVal1 is >= OCPDVal2 (blue box), then it's Ok. Otherwise, Invalid.

    OCPDVal2 is the result of summation of Main OCPD and PVocpdVal (red box). PVocpdVal is actually the value user selects from the drop down box above it. OCPDVal2 will always have a value, even though user hasn't selected any value yet, which takes the first value of the drop down option in PV OCPD.

    Is there anyway to prevent OCPDVal2 from being prepopulated, so that Status won't show anything until user actually enters something?

    How to prepopulate calculation field only after input from another fields Image 1 Screenshot 20

     

  • Mike_G JotForm Support
    Replied on May 26, 2015 at 12:55 PM

    Here's what you can do.

    Open your form in Edit mode.

    Then select the OCPDVal2 field and click the Wizard icon to open the Calculation Wizard window.

    How to prepopulate calculation field only after input from another fields Image 1 Screenshot 30

    Then click Show Advanced Option as shown in the image above. Then, follow the instructions on the image below.

    How to prepopulate calculation field only after input from another fields Image 2 Screenshot 41

    Let us know if this helps. Thank you.

  • coigis
    Replied on May 26, 2015 at 1:04 PM

    Awesome! That works!

    Thank you!