JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How to display value based on a range?Asked by tonyberber on November 09, 2016 at 02:33 PM
I have a field that sums up values from lots of previous fields. This sum ranges from 0 to 400. I'd like to have a further field that displays a particular message based on the value of that sum. For instance:
-if sum = 400, then display 'L4'
-if sum < 400 and >=320, then display L3
-if sum < 320 and >=240, then display L2
-if sum < 240 and >=160, then display L1
-else display = LNC
Is that possible?
Hello Tony, thank you for contacting our Support.
You should be able to achieve that with conditions and number field. What I mean is, you will have to store the sum into a number field:
And then by using conditions state 'less than' and 'greater than' you can create a range that you need and show appropriate fields.
For <= and >= just create an additional condition that will have 'equal to' state as well.
Let us know if this could work for you.
thank you, I'll try that!