Storing matrix question statements as embedded data (according to respondent's choice)

@HenrikeS - Your JavaScript is completely unrelated to what you are trying to accomplish. You’ll need to create JavaScript to apply your rules and set embedded data fields using the addOnPageSubmit function. Based on what you posted, you may need to find someone that knows JavaScript to do it for you.

Sorry, I posted the wrong code (my concentration got lost after hours of error seeking). The correct one is:

Qualtrics.SurveyEngine.addOnload(function() {
var selectedStatements = [];

// Find the selected value for each statement
jQuery('.q-matrix-table tbody tr').each(function() {
var statement = jQuery(this).find('td').first().text();
var selectedValue = parseInt(jQuery(this).find('input:checked').val());

if (!isNaN(selectedValue)) {
selectedStatements.push({ statement: statement, value: selectedValue });
}
});

// Sort selected statements by value in descending order
selectedStatements.sort(function(a, b) {
return b.value - a.value;
});

// Initialize variables to store the carried forward statements
var carriedForwardStatements = [];

// Check the value of "our company"
var ourCompanyValue = selectedStatements.find(function(statement) {
return statement.statement === 'our company';
});

if (ourCompanyValue && ourCompanyValue.value >= 2) {
// If "our company" has 2 or higher, carry it forward
carriedForwardStatements.push('our company');

// Find other statements with the same highest value
var highestValue = selectedStatements[0].value;
var highestValueStatements = selectedStatements.filter(function(statement) {
return statement.value === highestValue;
});

// If there are multiple statements with the same highest value, select one randomly
var randomIndex = Math.floor(Math.random() * highestValueStatements.length);
carriedForwardStatements.push(highestValueStatements[randomIndex].statement);
} else if (ourCompanyValue && ourCompanyValue.value === 1) {
// If "our company" has 1, carry forward the two other statements with the highest value
carriedForwardStatements.push(selectedStatements[0].statement);
carriedForwardStatements.push(selectedStatements[1].statement);
}

// Set the embedded data fields
Qualtrics.SurveyEngine.setEmbeddedData('SelectedStatement1', carriedForwardStatements[0] || '');
Qualtrics.SurveyEngine.setEmbeddedData('SelectedStatement2', carriedForwardStatements[1] || '');
});

Anushree, that is a great step forward - now the embedded fields are filled!

But it is not working completely correctly. When I set the following choices for my matrix question …

• our company: 1
• competitor 1: 4
• competitor 2: 5
• competitor 3: 2
• competitor 4: 3
• competitor 5: 3

… then

• SelectedStatement1 is competitor 1
• SelectedStatement2 is competitor 1

Correctly it should be:

• SelectedStatement1 is our company
• SelectedStatement2 is competitor 2

I tried it again with other choices, but the result is always the same:

• SelectedStatement1 is competitor 1
• SelectedStatement2 is competitor 1

@HenrikeS 

No, the coding I have provided gives the correct result. I tried replicating the same answer you have provided and received the expected output. 

Please check if you have updated the question id in the code.

var a =  (parseInt("${q://QID5/SelectedAnswerRecode/1}"))||0
var b =  (parseInt("${q://QID5/SelectedAnswerRecode/2}"))||0
var c =  (parseInt("${q://QID5/SelectedAnswerRecode/3}"))||0
var d =  (parseInt("${q://QID5/SelectedAnswerRecode/4}"))||0
var e =  (parseInt("${q://QID5/SelectedAnswerRecode/5}"))||0
var f =  (parseInt("${q://QID5/SelectedAnswerRecode/6}"))||0

@Anushree 

Yes, I have updated the question IDs. I will check everything again, maybe I have made another mistake ...

@HenrikeS - Also check the recoded values as well, as the context piped in is selectedChoiceRecodedValue.

Let me know if the script solves the requirement.

@Anushree 

Fixed it!!!

I found out that question export tags for my matrix question statements were not numbered sequentially (obviously I had deleted some so that they were numbered

• QID31_1
• QID31_16
• QID31_17
• QID31_18
• QID31_19
• QID31_21)

Now I created a new matrix question wherin the question export tags are sequentially numbered. 

AND IT WORKS!

Thank you so much, Anushree!

@Anushree 

One bug left:

When “Our Company” rates 1 and three competitors rate the same, then one of the three competitors is selected for SelectedStatement1 and for SelectedStatement2.

This seems to work:

Qualtrics.SurveyEngine.addOnload(function() {

jQuery("#QID30").hide(); //to hide the text-graphic question

var a = (parseInt("${q://QID31/SelectedAnswerRecode/1}")) || 0;

var b = (parseInt("${q://QID31/SelectedAnswerRecode/2}")) || 0;

var c = (parseInt("${q://QID31/SelectedAnswerRecode/3}")) || 0;

var d = (parseInt("${q://QID31/SelectedAnswerRecode/4}")) || 0;

var e = (parseInt("${q://QID31/SelectedAnswerRecode/5}")) || 0;

var f = (parseInt("${q://QID31/SelectedAnswerRecode/6}")) || 0;

var arr = [b, c, d, e, f];

// Find the largest and second largest answers

var largest = Math.max.apply(null, arr);

var secondLargest = Math.max.apply(null, arr.filter(x => x !== largest));

// Create an array to store Competitors with the largest score

var largestCompetitors = [];

if (largest == b) largestCompetitors.push("Competitor 1");

if (largest == c) largestCompetitors.push("Competitor 2");

if (largest == d) largestCompetitors.push("Competitor 3");

if (largest == e) largestCompetitors.push("Competitor 4");

if (largest == f) largestCompetitors.push("Competitor 5");

// Randomly select one from the largestCompetitors

var selectedLargest = largestCompetitors[Math.floor(Math.random() * largestCompetitors.length)];

var statement1;

var statement2;

if (a >= 2) {

statement1 = "Our Company";

statement2 = selectedLargest;

} else {

statement1 = selectedLargest;

// Filter out selectedLargest from largestCompetitors

var remainingCompetitors = largestCompetitors.filter(x => x !== selectedLargest);

// Randomly select one from the remainingCompetitors

statement2 = remainingCompetitors[Math.floor(Math.random() * remainingCompetitors.length)];

}

Qualtrics.SurveyEngine.setEmbeddedData('SelectedStatement1', statement1);

Qualtrics.SurveyEngine.setEmbeddedData('SelectedStatement2', statement2);

});