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

    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:

    - Absent

    - Mild

    - Moderate

    - Severe 

    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?

    Thank you,

    Stephanie

    Screenshot
    JotForm radio buttons web site matrix calculation calculate table matrix table
  • Profile Image
    JotForm Support

    Answered by jonathan on August 22, 2014 at 03:56 PM

    Hi Stephanie,

    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

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    Hope this help. Inform us if you need more assistance.

    Thanks!

     

  • Profile Image

    Answered by BibleLeagueCanada on June 01, 2015 at 03:00 PM

    Hi there,

     

    Is the answer to this question still the same? i.e. Is it still impossible to create a matrix with calculation values?
  • Profile Image
    JotForm Support

    Answered by Mike_G on June 01, 2015 at 05:21 PM

    @BibleLeagueCanada

    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

    Thank you.