-
dsawantAsked 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 -
David JotForm Support ManagerReplied 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
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.
-
dsawantReplied 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.
-
liyamReplied 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.