What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to make calculation only when both conditions are true?

    Asked by wolfpaw69 on April 06, 2016 at 04:25 PM

    I'm trying to make a calculation condition that basically needs two conditions to be met before it calculates.  

    First - If Termite Inspection is Yes

    Second - and Location is "Varying Location"

    Then calculated Travel Cost based on the two conditions above.

     

    Right now if Termite Inspection is NO, then the location is calculated.  Which it shouldn't unless Termite Inspection is Yes.

    The screen shot is from the emailed Notifier

    Page URL:
    https://form.jotform.com/53127112452141

    uploads condition
  • Profile Image

    Answered by Ben on April 06, 2016 at 05:36 PM

    I took a look at your form, but could not find "Varying Location" field, so I checked by doing the following:

    Location (Town or City) = Payson

    Payson Sub areas = Whispering Pines

    Termite Inspection = No

    Now looking at it I see that 25.00 is added to it - but it is as per conditions on your form.

    This is the one:

    I do suggest checking it out on your form to disable it for the specific location that you do not wish that it is applied to, however if you wish that the condition matches each of the towns and that it is  0 if not termite selection, then you should add another condition that sets the field to 0 as long as termite selection is set to No and move it all the way up - above all other conditions.

    That way it should make sure that the field is 0 until needed otherwise.

    - My suggestion is to unhide the fields that you need to check and hide them only after everything is working right.

  • Profile Image

    Answered by wolfpaw69 on April 07, 2016 at 11:48 AM

    For starters, it seems like you understand what I'm trying to do.  Good job.  Some times its hard to describe the issues.  

    Next, I did try putting the condition listed below but it didn't work.  It is at the top, I think.  Actually, it shows it at the top, but I'm not sure if this is actually happening.

     

  • Profile Image
    JotForm Support

    Answered by Welvin on April 07, 2016 at 01:03 PM

    That is because the NO is selected by default. Preselecting the option won't trigger the condition so you need to keep it open/unselected.

  • Profile Image

    Answered by wolfpaw69 on May 01, 2016 at 08:11 PM

    Cool.  Thanks.  Looks like that worked.