How to display a text on the form based on the calculated value?

  • MLandscaping
    Asked on May 3, 2017 at 12:18 PM
    Once I get it to add the numbers from multiple fields, is there a way to get the form to funnel those numbers into a range so the client doesn't see the exact number? Like if they choose a $10,000 patio, plus a $5000 fence, plus a $500 plant project, I want the form to show "Your project falls in the range of 10,000-20,000" instead of showing the $15,500.

    Thank you

  • Kiran Support Team Lead
    Replied on May 3, 2017 at 12:32 PM

    Yes. It is possible to display the text on the form based on the total. You can calculate the total of all the required fields to a calculation field along with a text field to display the text.

    How to display a text on the form based on the calculated value? Image 1 Screenshot 30

    You may setup a condition as shown below to display the text based on the total value as shown below:

    How to display a text on the form based on the calculated value? Image 2 Screenshot 41

    Please give it a try and let us know if you need any further assistance. We will be happy to assist. 

     

  • MLandscaping
    Replied on May 3, 2017 at 3:00 PM

    Fantastic! I'll try this out. Thank you!

  • MLandscaping
    Replied on May 18, 2017 at 12:01 PM

    Awesome! That worked.

     

    Next level:

    How do I ensure that all fields the customer selects/inputs are calculated? Do I have to manually input "this field plus this field plus this field" or is there an advanced calculation to add up the sum of all fields inputted?

  • KadeJM
    Replied on May 18, 2017 at 1:16 PM

    Glad to know that Kiran's suggestion helped you out.

    The above example is using conditions to display the text field as you asked but, if you want to allow multiple or if all you can just include those in the condition or calculation to combine them.

    It mainly depends on how many you want to show at once. Individually might be easier if only a handful otherwise duplicate them and set multiple in the same if you want to show more than one.

    Please see these guides below for more help:

    https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    https://www.jotform.com/help/268-Conditional-Logic-Inserts-Text-Calculation-Into-A-Field