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

    Help - Form Not Following All Conditions

    Asked by political on August 22, 2014 at 12:22 PM

    Example: http://form.jotform.us/form/42319202042137

    when you apply 1100 you get a total... when you enter 2200 for second condition... it does not result in total... Condition is

    [WORKS] IF Voter Households Greater Than "0"
    AND IF
    Voter Households Less Than "1251"
    Insert (({Voter Households}0.499)0.0825)+{Voter Households}0.499 into Total Cost (plus tax)
     
     
    [DOES NOT WORK] IF Voter Households Greater Than "1250"
    AND IF
    Voter Households Less Than "2501"
    Insert (({Voter Households}0.449)0.0825)+{Voter Households}0.449 into Total Cost (plus tax)
     
    I can't find problem
     
    I've tried something else... thanks
    Page URL:
    http://form.jotform.us/form/42319202042137

  • Profile Image
    JotForm Support

    Answered by Welvin on August 22, 2014 at 02:58 PM

    Hi,

    It's a conflict to the conditional logic list. I would suggest removing the AND IF LESS THAN rules and add IF GREATER THAN into a series. For example:

    If Voter Households Greater Than 0

    If Voter Households Greater Than 1251

    If Voter Households Greater Than 1500

    So looking into this way, the calculation works based on the value provided. IF the Voters Household is 1250, it calculations condition based on the entry for "Greater Than 0". The same if Voters Household is 1499, it calculates the condition based on the entry for "Greater Than 1251" and son on..

    Thank you!