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

    How do I set values for each radio columns in the matrix?

    Asked by jannyfer.chua on August 05, 2016 at 04:22 AM

    I have a set of 28 questions and 5 radio columns (Never, Rarely, Sometimes, Very often, Always).

     

    a) How do I set values for each column and when they are selected, the values are added up? e.g. Never=1, Rarely=2, Sometimes=3, Veryoften=4, Always=5

    if Never is selectedx2, rarely x1, always x2 = the total is 14.

     

    b) How do I set the 28 questions to calculate 4 different totals from the above columns. eg. Qs 1-7, 8-14, 15-21, 22-28 and then set a formula to only show the results for the highest total?



    This is a re-post of a comment on How to Perform Form Calculation in the Matrix Field?

    matrix
  • Profile Image
    JotForm Support

    Answered by Chriistian on August 05, 2016 at 05:58 AM

    a) How do I set values for each column and when they are selected, the values are added up? e.g. Never=1, Rarely=2, Sometimes=3, Veryoften=4, Always=5

    You seem to have correctly setup the values based on the guide. Since you have already set the values of the columns, we shall move on to part B of your concern.

     

    b) How do I set the 28 questions to calculate 4 different totals from the above columns. eg. Qs 1-7, 8-14, 15-21, 22-28 and then set a formula to only show the results for the highest total?

    You will need to add 4 different Form Calculation widgets to calculate 4 different totals.

    1. Add the calculation fields.

    2. Add the Matrix field in the calculation. A matrix with a checkbox will appear after. Only check the ones you need to calculate. So for the 1 to 7 Calculation, you will need to check boxes 1 to 7. Please see screen recording below.

    3. Repeat step 2 for the rest of the calculation widgets and you're all set.

    Here's a demo form that you can clone to your account to see the setup: https://form.jotform.com/62172794982973.

    Result:

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

     

     

  • Profile Image

    Answered by jannyfer.chua on August 05, 2016 at 06:45 PM
    Hi,
    Thank you for your prompt response.
    How do I set a formula to calculate the highest total of the 4 totals and then for it to show related information to that total on the next page?
    e.g.
    Q1= 35
    Q2 = 30
    Q3= 22
    Q4= 18
    So the highest total is Q1 but instead of showing the actual formula to the user,
    [cid:image001.png@01D1EFB4.83DD5F90]
    It shows information related to that result on the Next Page:
    [Image result for prioritiser]
    You are a Prioritiser!
    Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
    ...