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.


  • Profile Image

    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.

     

     

    hello total score right how
  • Profile Image
    JotForm Support

    Answered by david on September 26, 2016 at 06:46 PM

    If you would like for your options to have values, you can assign them calculation values:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Those values or any other numerical values in the form, can be totaled up in a calculation field:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

  • Profile Image

    Answered by eaga on September 26, 2016 at 07:46 PM
    But I don't understand what it is saying.
    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on September 26, 2016 at 11:28 PM

    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?

    Here's a demo that you can check out and clone to your accounthttps://form.jotform.com/62698847110968. Please note the demo only calculates the total of the first row in the matrix (Berna Garcia).

    Please let us know if you need further assistance.
    Regards.

  • Profile Image

    Answered by eaga on September 27, 2016 at 10:46 AM
    Thank you for the information but how to I put the total into a new column next to the last column?

    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on September 27, 2016 at 12:15 PM

    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.