Hi everyone!I am trying to construct something really tricky:I have a matrix question with 6 statements ...our company competitor 1 competitor 2 competitor 3 competitor 4 competitor 5and 5 scale points:no knowledge knowledge considerance purchase loyaltyThe scale points are recoded in values from 1 to 5.Now I want to safe two of the statements as embedded data according to the following rules:a) If for "our company" 2 or higher is chosen, then store "our company" AND store another statement, namely the one with the highest chosen scale point. If there are two or more statements with the same (highest) chosen scale point, then take one of them randomly and store it.b) If for "our company" 1 is chosen, then store the two (other) statements with the highest chosen scale point. If there are three or more statements with the same (highest) chosen scale point, then take two of them randomly and store them.I created two embedded data fields:SelectedStatement1 SelectedStatement2Then I created a new "Text/Graphic" question right after my matrix question (only text display, no answer option) and within this question I set up this java code:import org.apache.http.HttpResponse;import org.apache.http.client.HttpClient;import org.apache.http.client.methods.HttpGet;import org.apache.http.impl.client.HttpClients;import org.apache.http.util.EntityUtils;public class QualtricsApiExample { public static void main(String[] args) { // Your Qualtrics API key String apiKey = "YOUR_API_KEY"; // Qualtrics survey ID String surveyId = "YOUR_SURVEY_ID"; // Qualtrics API base URL String baseUrl = "https://yourdatacenterid.qualtrics.com/API/v3/surveys/" + surveyId; try { // Create an HttpClient instance HttpClient httpClient = HttpClients.createDefault(); // Create an HTTP GET request HttpGet getRequest = new HttpGet(baseUrl); // Set the API key as a request header getRequest.addHeader("X-API-TOKEN", apiKey); // Send the GET request HttpResponse response = httpClient.execute(getRequest); // Check the response status code int statusCode = response.getStatusLine().getStatusCode(); if (statusCode == 200) { // Request was successful String responseBody = EntityUtils.toString(response.getEntity()); System.out.println("Response from Qualtrics API:"); System.out.println(responseBody); } else { // Request failed System.err.println("Request failed with status code: " + statusCode); } } catch (Exception e) { e.printStackTrace(); } }} But it does not work: The embedded data fields are always empty. Can anyone help me with this?I would be very happy.Henrike

@HenrikeSAdd a page break between matrix question and Text/Graphic question. Also, add recode values for Matrix scales. Then add the below script to text/graphic question.Note: Update the question Id’s in script.Qualtrics.SurveyEngine.addOnload(function(){jQuery("#QID6").hide(); //to hide the text-graphic questionvar a = (parseInt("${q://QID5/SelectedAnswerRecode/1}"))||0var b = (parseInt("${q://QID5/SelectedAnswerRecode/2}"))||0var c = (parseInt("${q://QID5/SelectedAnswerRecode/3}"))||0var d = (parseInt("${q://QID5/SelectedAnswerRecode/4}"))||0var e = (parseInt("${q://QID5/SelectedAnswerRecode/5}"))||0var f = (parseInt("${q://QID5/SelectedAnswerRecode/6}"))||0var arr = [b, c, d, e, f];var largest = arr[0];var secondLargest = 0;var statement1var statement2//script to find largest answerfor (var i = 0; i < arr.length; i++) { if (arr[i] > largest ) { largest = arr[i]; }}//script to find 2nd largest answervar max = Math.max.apply(null, arr); // get the max of the array arr.splice(arr.indexOf(max), 1); // remove max from the array secondLargest = Math.max.apply(null, arr);if (largest == b){largest = "Competitor 1"}else if(largest == c){largest = "Competitor 2"}else if(largest == d){largest = "Competitor 3"}else if(largest == e){largest = "Competitor 4"}else {largest = "Competitor 5"}if (secondLargest == b){secondLargest = "Competitor 1"}else if(secondLargest == c){secondLargest = "Competitor 2"}else if(secondLargest == d){secondLargest = "Competitor 3"}else if(secondLargest == e){secondLargest = "Competitor 4"}else {secondLargest = "Competitor 5"}if (a >= 2){statement1 = "Our Company"statement2 = largestQualtrics.SurveyEngine.setEmbeddedData('SelectedStatement1', statement1 );Qualtrics.SurveyEngine.setEmbeddedData('SelectedStatement2', statement2 );}else{statement1 = largeststatement2 = secondLargestQualtrics.SurveyEngine.setEmbeddedData('SelectedStatement1', statement1 );Qualtrics.SurveyEngine.setEmbeddedData('SelectedStatement2', statement2 );}});

@AnushreeFixed it!!!I found out that question export tags for my matrix question statements were not numbered sequentially (obviously I haddeleted some so that they were numberedQID31_1QID31_16QID31_17QID31_18QID31_19QID31_21)Now I created a new matrix question wherin the question export tags are sequentially numbered.AND IT WORKS!Thank you so much, Anushree!

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

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

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded