- enetknowhowAsked on February 02, 2016 at 03:59 AM
- JotForm SupportBJoannaAnswered on February 02, 2016 at 04:25 AM
You can use Matrix table field and Form Calculation widget.
Inside of this guide you can find out how to perform form calculation in the Matrix field:
You can also use Spreadsheet widget.
Here is my demo form: https://form.jotform.com/60321568424957
Feel free to clone it.
Hope this will help. Let us know if you need further assistance.
- enetknowhowAnswered on February 03, 2016 at 12:44 AM
Hello, I know that tool bud you answer is not helpfil. Give me a real sample formula for: y>x and y<z then set a = 1. You can make a sreenshot for me please. Thanks!
- JotForm SupportEltonCrisAnswered on February 03, 2016 at 04:03 AM
Our calculation tool doesn't support constant values where it takes the result from a certain calculation table.
What you need to do to achieve this is to define all the calculation formula on the conditions wizard to get the desired output. You can achieve this when you create a calculate field condition.
Example, base on your initial post.
If height is equal to 2
If weight is equal to b
Output "s2" on value1 field.
Hope this helps!
- enetknowhowAnswered on February 03, 2016 at 04:29 AM
Sorry, bud I dont know why you not answer my question.
Importend is ">"= "bigger as" and "<"= is "smaller as" !! not "is equal"
I think mathematical operators in us is same germany= international ??!
so one more:
y>x and y< z then set fild a = 1
y "bigger as" x and y "smaller as" z then set fild a = 1
You can make a sreenshot for me please.
- JotForm SupportEltonCrisAnswered on February 03, 2016 at 09:18 AM
I was basing from your initial statement, that's why I came up with that example.
Anyway, "Greater Than" (>) and "Less Than" (<) are also available in the calculation conditions if you are using numbers or a form calculation widget.
So when you create a condition statement, you can use less than and greater than operators.
- JotForm SupportEltonCrisAnswered on February 03, 2016 at 09:23 AM
I have updated the sample form https://form.jotform.com/60331447445957 base on your last equation.
- enetknowhowAnswered on February 03, 2016 at 08:08 PM
Thank you very much!! Now understad :)
- JotForm SupportEltonCrisAnswered on February 03, 2016 at 11:38 PM
Great. Cheers! :)