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

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

    Asked by dsawant 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

    Page URL:
    https://form.jotform.com/62419201376149

    and a JotForm style size font
  • Profile Image
    JotForm Support

    Answered by BDAVID on August 30, 2016 at 01: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

    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:

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

    Result:

    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:

    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.

  • Profile Image

    Answered by dsawant on August 30, 2016 at 08: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.

  • Profile Image
    JotForm Support

    Answered by liyam on August 31, 2016 at 02: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.