Calculation Widget: I can’t ignore one field. I want the calculation to consider the value of either question 2 or question 3.

  • InboundVisa
    Asked on July 26, 2024 at 2:51 PM
    in the form that has the calculation widget, I can’t ignore one field. I want the calculation to consider the value of either question 2 or question 3 (not both) depending on the conditions that I added, but it’s not working. Could you assist?
  • Jerlan JotForm Support
    Replied on July 26, 2024 at 3:29 PM

    Hi Rodrigo, 

    I didn’t fully understand what you were trying to calculate. Can you explain a bit more about the issue, so I can get a better idea of what's happening? Do you want to show different calculations for questions 2 and 3?

    Once we hear back from you, we'll be able to help you with this.

  • InboundVisa
    Replied on July 26, 2024 at 4:25 PM
    Yes, exactly!
    The form skips question 2 if the answer to question 1 is USA and it skips
    question 3 if the answer is Brazil.
    However, for the calculation, it's considering the value of both questions.
    I want the final result to consider only the value in 2 if answer to
    question 1 is USA and the value in 3 if question to 1 is Brazil.
    Makes sense?
    ...
  • Jerlan JotForm Support
    Replied on July 26, 2024 at 4:44 PM

    Hi Rodrigo, 

    I understand what you’d like to do, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

  • Jerlan JotForm Support
    Replied on July 26, 2024 at 5:27 PM

    Hi Rodrigo, 

    Currently, you only have 1 calculation widget. You must add another form calculation widget to designate each calculation for the USA & Brazil and then add a Show/Hide field condition. Let me show you how:

    1. Open your form in Form Builder and click the calculation widget field.
    2. Click on the Wand Icon or Widget settings.
    3. Under the form calculation widget, remove the question 3.

    Calculation Widget:  I can’t ignore one field Screenshot 110

    Now let's add a new calculation widget

    1. In the form builder, click on the Add form element.

    Calculation Widget:  I can’t ignore one field Screenshot 121

    2. Go to the widget tab and add form calculation.

    Calculation Widget:  I can’t ignore one field Screenshot 132

    3. Set up the form calculation. Take a look at the screenshot below:

    Calculation Widget:  I can’t ignore one field Screenshot 143

    4. Click on the gear icon or properties.

    5. Under Advanced, click on Hide Field to enable.

    Calculation Widget:  I can’t ignore one field Screenshot 154Let's set up the conditions which Form calculation widget to show:

    1. In the orange navigation bar at the top of the screen, click on Settings.

    2. On the left panel, click on Conditions.

    3. Then click on Add new condition.Calculation Widget:  I can’t ignore one field Screenshot 165

    4. Click on Show/Hide field.

    Calculation Widget:  I can’t ignore one field Screenshot 176

    5. Then set up the conditions as shown in the screenshots below:

    Calculation Widget:  I can’t ignore one field Screenshot 187

    Calculation Widget:  I can’t ignore one field Screenshot 198

    Check out the screencast below to see my results:

    Calculation Widget:  I can’t ignore one field Screenshot 209


    Give it a try and let us know if you need any help.

  • InboundVisa
    Replied on July 27, 2024 at 8:55 AM
    Thanks, but now when I hit submit I get the error message below.
    I don't want to show questions 7 and 8 and I want to have the thank you
    page, which, in turn, will show the result.
    Besides, I want to change the ("Submit form") button to show "Calculate".
    Can I
    Calculation Widget:  I can’t ignore one field Screenshot 20
    ...
  • Jerlan JotForm Support
    Replied on July 27, 2024 at 9:37 AM

    Hi Rodrigo,

    It seems the screenshot wasn't attached properly. Can you send it to us again? This guide will show you how to do that.

    Once we hear back from you, we'll be able to help you with this.

  • InboundVisa
    Replied on July 27, 2024 at 10:00 AM
    See attached again
    Calculation Widget:  I can’t ignore one field Screenshot 20
    ...
  • Sheena JotForm Support
    Replied on July 27, 2024 at 10:02 AM

    Hello InboundVisa,

    Unfortunately, we are unable to receive email attachments within this ticket. As such, could you kindly open this ticket, then click on the image icon to upload your screenshot again?

    1656419882 62baf62af2591  Screenshot 10

    Once we heard back from you, we will proceed with the next steps.



  • InboundVisa
    Replied on July 27, 2024 at 10:22 AM

    See attached,Calculation Widget:  I can’t ignore one field Screenshot 20

  • InboundVisa
    Replied on July 27, 2024 at 10:25 AM
    Just did it.
    ...
  • James Adalem JotForm Support
    Replied on July 27, 2024 at 10:46 AM

    Hi Rodrigo,

    I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

    We appreciate your patience while we work on a solution.

  • James Adalem JotForm Support
    Replied on July 27, 2024 at 11:44 AM

    Hi Rodrigo,

    I cloned your form and tested it to see if I could replicate the issue, and I ran into the same issue. When I looked at your form, I saw that your conditional logic wasn't configured correctly. Let me show you how to fix it:

    1. In Form Builder, click on Settings in the orange navigation bar.
    2. Go to Conditions, hover over your mouse on the first condition, and click on the Gear icon.
    3. Click on Disable.
      Calculation Widget:  I can’t ignore one field Screenshot 60
    4. Next, we edit your condition when Estados Unidos is selected, copy the screenshot below and click Save.
      Calculation Widget:  I can’t ignore one field Screenshot 71
    5. Lastly, we add an Enable/Require/Mask Field condition that will set question 3 unrequired when we skip it. Copy the screenshot below and click Save.
      Calculation Widget:  I can’t ignore one field Screenshot 82

    Result screencast:

    When Estados Unidos is selected
    Calculation Widget:  I can’t ignore one field Screenshot 93
    When Brasil is selected
    Calculation Widget:  I can’t ignore one field Screenshot 104

    Feel free to clone my form. Here is a guide on How to Clone an Existing Form From a URL.

    Give it a try and let us know if you need any help.

Your Answer