Can I use a calculation on a matrix?

  • AdvanceMD
    Asked on August 22, 2014 at 2: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

    Jotform Thread 419451 Screenshot
  • jonathan
    Replied on August 22, 2014 at 3: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.

    Can I use a calculation on a matrix? Image 1 Screenshot 50

     

    What you can try using instead is he regular Radio buttons(found in Form Tools) as it has the Calculation Values property.

    Can I use a calculation on a matrix? Image 2 Screenshot 61

     

    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.

    Can I use a calculation on a matrix? Image 3 Screenshot 72

     

    So every time an option is selected on each of the Radio items, the grand Total is calculated

    Can I use a calculation on a matrix? Image 4 Screenshot 83

     

    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!

     

  • BibleLeagueCanada
    Replied on June 1, 2015 at 3: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?
  • Mike_G JotForm Support
    Replied on June 1, 2015 at 5: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.