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.
Can I use a calculation on a matrix?Asked by AdvanceMD on August 22, 2014 at 02:12 PM
I want to put a menopause self assessment on my web site. I created a form using JotForm that contains a matrix with radio buttons. My columns (options) are:
I would like to be able to assign each option a value (0 - 3) and calculate the total (this would give an indication of severity of symptoms).
Is this possible to do with JotForm?
Unfortunately you cannot use the Matrix table field for calculations because it lacks the Calculation Values property that other fields have that is needed for calculation.
What you can try using instead is he regular Radio buttons(found in Form Tools) as it has the Calculation Values property.
Here is a test form http://www.jotform.me/form/42336401771449 you can try.
In the test form I have setup the Calculation Widget with calculation formula like this.
So every time an option is selected on each of the Radio items, the grand Total is calculated
Check also this related user guide
Hope this help. Inform us if you need more assistance.
I have moved your question to a different thread so you may follow updates on your post there.
Here is the link to the new thread: http://www.jotform.com/answers/579967