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

    Unable to insert a value based on a calculation using conditions

    Asked by hostcompliance on November 02, 2016 at 04:45 AM

    Hi,

     

    I have created a form (https://www.jotform.com//?formID=63059395578168) that contains a number of calculated field. For some weird reason I however can't get one of the fields to calculate correctly. Specifically, i would like the field named "Late payment penalty and interest due" to be populated with a specific value whenever the value of the prior field named "# of months delinquent on taxes for this specific quarter (round up to nearest whole month)" has the value 1. Despite spending hours on it, I can't figure it out. Can you please help? 

    Page URL:
    https://www.jotform.com//?formID=63059395578168

    JotForm problem www in
  • Profile Image
    JotForm Support

    Answered by Charlie on November 02, 2016 at 05:27 AM

    Hi,

    Could you please elaborate what exactly the rules or conditions you want to execute for the field "Late payment penalty and interest due"?

    I cloned your form and checked it on my end, this is how it looks like:

     

    If I understood your conditions correctly, this is how it should be:

    Condition #1:

    IF "# of months delinquent on taxes for this specific..." is equal to "1"

    THEN

    INSERT "yes" to "Late payment penalty and interest due"

     

    Condition #2:

    IF "# of months delinquent on taxes for this specific..." is equal to "0"

    THEN

    INSERT "$0" to "Late payment penalty and interest due"

     

    The problem is that your field type for "Late payment penalty and interest due" is a "Number" field, is this correct? One way to easily identify this is the options above when you select it:

    Noticed the options "Max Size", "Min Value" and "Max Value", these options are only applicable to numbers. 

    You cannot insert non-numeric characters like "yes" or "$0" using conditions on that field because they are not absolute numbers. If you wish to insert a combination of alphanumeric characters, then you will need to use the "Text Box" instead, you can find the text box field under the "Basic Fields" section.

    Let us know if that helps resolve the problem.