I have created a matrix with 6 questions and 8 option box as answers.

  • dsawant
    Asked on August 30, 2016 at 10:31 AM

    I have assigned a value of 1 for "Strongly Agree", 2 for "Agree", and so on until an 8 to "Don't Know" etc..

    I wanted to make a calculation like this - 

    value1 = |Opt1-1| + |Opt2-1| + |Opt3-1| + |Opt4-1| + |Opt5-1| + |Opt6-1| + |Opt7-1| + |Opt8-1|

    value2 = |Opt1-2| + |Opt2-2| + |Opt3-2| + |Opt4-2| + |Opt5-2| + |Opt6-2| + |Opt7-2| + |Opt8-2|

    value3 = |Opt1-3| + |Opt2-3| + |Opt3-3| + |Opt4-3| + |Opt5-3| + |Opt6-3| + |Opt7-3| + |Opt8-3|

    value4 = |Opt1-4| + |Opt2-4| + |Opt3-4| + |Opt4-4| + |Opt5-4| + |Opt6-4| + |Opt7-4| + |Opt8-3|

     

    and if value 1 is the minimum of these values I need to output on a thank you page that you are master,

    if value 2 is the minimum then you are an apprentice etc..

     

    How can I check which is the minimum of these values and give a certain output?

    Is it possible to do using JotForm?

     

    Thanks & Regards,

        Digvijay

  • David JotForm Support Manager
    Replied on August 30, 2016 at 1:53 PM

    1) First, you need to assign values  to each option. As far as  I understand, in each row, columns options will go from 1 to 7(I see there are only 7 options).

    Simply click on the gear icon of your matrix field>>Edit Properties>>Options>>Calculation Values, and enter each value:

    VALUES TO BE ENTERED:

    1,2,3,4,5,6,7

    1,2,3,4,5,6,7

    1,2,3,4,5,6,7

    1,2,3,4,5,6,7

    1,2,3,4,5,6,7

    1,2,3,4,5,6,7

    1,2,3,4,5,6,7

    1,2,3,4,5,6,7

    Example

    I have created a matrix with 6 questions and 8 option box as answers Screenshot 60

    2)Now  that you have the values for each option, you can perform the calculation as shown in this guide: https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    According to this logic: 

    value1 = |Opt1-1| + |Opt2-1| + |Opt3-1| + |Opt4-1| + |Opt5-1| + |Opt6-1| + |Opt7-1| + |Opt8-1|

     

    value2 = |Opt1-2| + |Opt2-2| + |Opt3-2| + |Opt4-2| + |Opt5-2| + |Opt6-2| + |Opt7-2| + |Opt8-2|

     

    value3 = |Opt1-3| + |Opt2-3| + |Opt3-3| + |Opt4-3| + |Opt5-3| + |Opt6-3| + |Opt7-3| + |Opt8-3|

     

    value4 = |Opt1-4| + |Opt2-4| + |Opt3-4| + |Opt4-4| + |Opt5-4| + |Opt6-4| + |Opt7-4| + |Opt8-3|

     

    The calculation would be the following:

    I have created a matrix with 6 questions and 8 option box as answers Screenshot 71

    3) Clone this calculation field, and replace the discount value, example:

    I have created a matrix with 6 questions and 8 option box as answers Screenshot 82

    Result:

    I have created a matrix with 6 questions and 8 option box as answers Screenshot 93

    4) The last part would be checking which is the minimum of these values and give a certain output in the Thank You page.

    You will need to create conditions to evaluate it, and forward to a custom Thank You page depending on which condition is met. Here is the guide that explains how this works: https://www.jotform.com/help/317-Change-Thank-you-URL-Based-on-a-Condition 

    The conditions would be as follow:

    I have created a matrix with 6 questions and 8 option box as answers Screenshot 104

    Here is my cloned version: https://form.jotform.com/62424822297964 

    Please clone it in your account as explain on this guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    I have created the conditions for you to simply add the URL of the corresponding Thank You page.

    Let us know if you need more help.

  • dsawant
    Replied on August 30, 2016 at 8:33 PM

    WOW!! Thanks @BDAVID. I am going to try this tonight.

    I will definitely get back with you if I get stuck somewhere..

    Thank you so much for putting in the time and the effort to give such a descriptive answer.

  • liyam
    Replied on August 31, 2016 at 2:36 AM

    Hello dsawant,

    On behalf of David, you are welcome. Feel free to let us know should you have further questions or if you have any other concerns.

    Thanks.