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.
Calculating results in matrix field.Asked by eaga on September 26, 2016 at 04:13 PM
Hello. For my form called:
Judging Form - Most Inspiring - Sculptured Cake Artist
How to i calculate the total for each category into one column on the far right.
I want to calculate the total score given for each person.
If you would like for your options to have values, you can assign them calculation values:
Those values or any other numerical values in the form, can be totaled up in a calculation field:
But I don't understand what it is saying.
It looks like you are using a Matrix field for your "Judging Form - Most Inspiring - Sculptured Cake Artist" form. If I understand correctly, you want to calculate the total for each row in the matrix into a new column?
You will need to use a Form Calculation widget for each of the rows that you want to calculate. To do so, please follow this guide: How to Perform Form Calculation in the Matrix Field?
Please let us know if you need further assistance.
Thank you for the information but how to I put the total into a new column next to the last column?
If you want the add a new column on your Matrix field that computes the total for each row, unfortunately, Matrix Field is not capable of doing calculations per row. As a workaround, you can try to use the Spreadsheet widget instead of using the Matrix field.
You can check this demo form so you can see how the Spreadsheet widget works: https://form.jotform.com/61441655557965.