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

    Adding text to calculations

    Asked by airdat on March 15, 2016 at 06:19 AM

    Hi,

     

    I need to add some text the calculation field on a form so that is shows the user what they have scored for each section out of a possible max. However when I add the "out of" text it seems to corrupt the final calculation. I have an example of what I mean here

    https://form.jotform.com/60743030588960

    On loading the form the Total already has 300 out of 300 but no fields have been selected. Selecting fields just corrupts the totl further.

     

    Many thanks

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

    calculations adding text adding JotForm selected section thanks
  • Profile Image
    JotForm Support

    Answered by Boris on March 15, 2016 at 09:29 AM

    If you add text into one calculation field, that calculation field cannot be used in other form calculation fields anymore - or it will cause the conflicts of the type you have experienced. There are two workarounds to achieve what you are after, you can choose any one of them you may prefer.

    1. The easiest method is that you do not add text into section calculations. If you want to indicate out of how many possible points the section total was calculated, you may want to:

    a) either put it into the label of the section calculation field:

    or b) hide the calculation field and use a regular Text field that will display the calculated amount instead:

    In the above image, {section15} is the name tag of the section 1 calculation field. You can see the correct name tag to use within your custom message by following this guide:

    http://www.jotform.com/help/146-How-to-find-Field-IDs-Names

    By using a Text field to display the message, you even have some nice styling options available, such as making the text bold, or coloring the actual total that the user scored in this section:

    The above would be the recommended way to set up the section scores.

    2. If you still want to add text directly into your section calculations, then you should set up your total calculation not to calculate from the section calculations, but from the fields within the sections themselves.

    In other words, if calculation for section 1 calculates as A1 + B1, and section 2 calculation calculates as A2 + B2, you would use total calculation such as this one:

    (A1 + B1) + (A2 + B2)

    Currently, your total calculation is set to calculate the section calculations that have text, which is causing the conflict because in practice it results in this:

    (A1 + B1 out of 300) + (A2 + B2 out of 300)

    So in case you want to have text directly within the section calculations, for the total calculation, you would be using only the fields marked in green in the following screenshot:

    If you need any further assistance, please let us know.

  • Profile Image

    Answered by airdat on March 15, 2016 at 09:39 AM

    I see the issue now and will go with one of your solutions. Many thanks for the speedy response Boris. 

  • Profile Image
    JotForm Support

    Answered by Kiran on March 15, 2016 at 10:42 AM

    Great! Glad to see that you have identified the issue on the form. Please do not hesitate to get in touch with us if you need any further assistance. We will be happy to help. 

    Thank you for using JotForm!!