How to prepopulate calculation field only after input from another fields

  • Profile Image
    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?


  • Profile Image
    Answered 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.

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

    Let us know if this helps. Thank you.

  • Profile Image
    Answered on May 26, 2015 at 01:04 PM

    Awesome! That works!

    Thank you!