How does Calculate/Update field conditional logic work?

  • Profile Image
    adunbar2
    Asked on April 13, 2018 at 03:58 PM

    How does Update/Calculate field conditional logic work?

  • Profile Image
    TREVON
    Answered on April 13, 2018 at 04:34 PM

    You can use the update form field/calculation condition to copy a field value to another field. Basically you can perform calculation functions as well as updating another field based on condition.

    Below is a guide: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

    Kindly do let us know if you need further assistance.

  • Profile Image
    adunbar2
    Answered on April 14, 2018 at 03:35 PM

    Still having problem understanding, on my nursing cap documentation submission form, Part B requirements tab, I want to be able to add how many categories user is completing. I want to count (Prepare/Present education to benefit staff/patients/families + Nurse sensitive indicators; CONE; Quality Projects + Research Activities) for example. If 1 of these are filled it counts as 1 point and then if all three are filled or completed by user then it counts as 2 points.

    How can I do this? Currently the above fields are not numeric or not a calculation value.

  • Profile Image
    TREVON
    Answered on April 14, 2018 at 04:35 PM

    For this you will use conditional statement and check if f one field is filled or if all fields are filled and the update another field we will create that will either have 1 or 2.

    So the condition will ideally be the same only that you will be checking on one condition if all fields have been field and on another if any field has been filled.

    https://www.jotform.com/help/414-Calculate-Values-in-the-Input-Table-Through-Condition

    Below is the conditional statement.

    One field has been filled

    1523737866Screen Shot 2018-04-14 at 23.2

    All fields have been filled

    1523737885Screen Shot 2018-04-14 at 23.2

    Below is a clone of your form with the above implemented. (I have created a field called "Calculated Based on fields filled" on the last page of the form where these details are updated.

    https://www.jotform.com/build/81035905568966

    Kindly feel free to clone and use the form.




  • Profile Image
    adunbar2
    Answered on April 14, 2018 at 09:57 PM

    Thanks. I clicked on your updated form but it took me to my forms? I was not able to see your updated form? Question, if the scenario is 2 categories are completed I would like the count to be 2 how can I do this?

  • Profile Image
    liyam
    Answered on April 15, 2018 at 03:07 AM

    Hello adunbar2,

    You will need to copy the link and use the link for cloning a form to your account. Here is the link to Trevon's live form and you can use it to clone the form to your account: https://www.jotform.com/81035905568966

    If you need assistance, please let us know.