Loop and Merge with Calculated Embedded Data Field

With scores inside a Loop & Merge block can definitely be a bit tricky since there  isn't a native "out-of-the-box" scoriing feature that plays nice with loop.s. Relying on Survey Flow logic gets messy fast, especially if you have a long list of products.

The most efficient way to handle this is definitely through a bit of JavaScript. You can use the Qualtrics.SurveyEngine.addOnload function within your loop block to dynamically calculate that index. Basically, your script would grab the matrix responses for the current iteration, map those scale labels to  your 0-4 values (skipping the "N/A" options), and then run your math: $(\text{sum} / (4 \times \text{answered})) \times 100$.  From there, you can use the API to save that value into a dynamically named embedded data field, like ${lm://Field/1} - Index Score, so it stays organized for every item.

Hi Luis, thanks for the response.

This is exactly what I am looking to do and what I was looking for help from the community on the code design. I was not able to find anything posted on the community to do this, and I’m not a JavaScript developer myself. See what I tested from Copilot below and how I tested it but it did not work.

Qualtrics.SurveyEngine.addOnPageSubmit(function () {
  // ---- CONFIG ----
  // Replace with the QID of the MATRIX question you want to score (the 5-statement Likert matrix)
  var MATRIX_QID = "QID2";

  // If "Not applicable" is the 6th column, set NA_COL = 6.
  // (i.e., Strongly disagree..Strongly agree = 1..5, Not applicable = 6)
  var NA_COL = 6;

  // Max score for a non-NA response (Strongly agree = 4 in your scoring scheme)
  var MAX_SCORE = 4;

  // Column -> score mapping (adjust if your column order differs)
  // 1: Strongly disagree (0)
  // 2: Somewhat disagree (1)
  // 3: Neither (2)
  // 4: Somewhat agree (3)
  // 5: Strongly agree (4)
  var COL_TO_SCORE = { 1: 0, 2: 1, 3: 2, 4: 3, 5: 4 };

  // Current loop item (product name) coming from Loop & Merge Field 1
  var productLabel = "${lm://Field/1}";

  // Build a "safe" key for Embedded Data field names
  // (avoid spaces/special chars per ED naming best practices)
  var productKey = (productLabel || "")
    .trim()
    .replace(/[^A-Za-z0-9]+/g, "_")
    .replace(/^_+|_+$/g, "");

  // ---- READ RESPONSES FROM THE MATRIX ----
  // We find checked radios belonging to the matrix by ID pattern: QR~QIDxxxx~ROW~COL
  var selector = 'input[type="radio"][id^="QR~' + MATRIX_QID + '~"]:checked';
  var checked = document.querySelectorAll(selector);

  var sum = 0;
  var answeredCount = 0;

  checked.forEach(function (inp) {
    var parts = inp.id.split("~"); // ["QR", "QID...", "row", "col"]
    if (parts.length < 4) return;

    var col = parseInt(parts[3], 10);
    if (!isFinite(col)) return;

    // Exclude Not applicable
    if (col === NA_COL) return;

    var score = COL_TO_SCORE[col];
    if (score === undefined || score === null) return;

    sum += score;
    answeredCount += 1;
  });

  // ---- CALCULATE INDEX ----
  // sum(scores) / (4 * #answered) * 100
  // If 0 answered, keep blank
  var indexScore = "";
  if (answeredCount > 0) {
    indexScore = (sum / (MAX_SCORE * answeredCount)) * 100;
    // optional rounding (1 decimal)
    indexScore = Math.round(indexScore * 10) / 10;
  }

  // ---- WRITE EMBEDDED DATA ----
  // Safe, analysis-friendly field names:
  //   <productKey>_IndexScore
  //   <productKey>_Label  (stores the human-readable product label)
  Qualtrics.SurveyEngine.setEmbeddedData(productKey + "_IndexScore", indexScore);
  Qualtrics.SurveyEngine.setEmbeddedData(productKey + "_Label", productLabel);

  // If you *insist* on human-readable dynamic ED names like "[Selected Product] - Index Score",
  // you *can* also set it like this — but it may create messy column names:
  // Qualtrics.SurveyEngine.setEmbeddedData(productLabel + " - Index Score", indexScore);
});

Hi ​@jake_dufinetz 

I had a similar use case based of a fixed loop. From there, it shouldn’t be too difficult to adapt for a loop based off a question and integrate dynamic names for your ED fields.

Qualtrics.SurveyEngine.addOnPageSubmit(function (type) {

    console.log("[avgScore] addOnPageSubmit fired, type:", type);
    if (type !== "next") return;

    // configuration
    var EXCLUDED_RECODE_VALUES = ["9"];
    var DECIMAL_PLACES = 2;

    var qid = this.questionId;
    console.log("[avgScore] qid:", qid);

    var statements = this.getSelectedChoices();
    var scalePoints = this.getAnswers();
    console.log("[avgScore] statements:", statements, "| scalePoints:", scalePoints);

    var recodeMap = {};
    for (var c = 0; c < scalePoints.length; c++) {
        var spId = String(scalePoints[c]);
        var rv = this.getChoiceRecodeValue(spId);
        recodeMap[spId] = (rv !== null && rv !== undefined) ? String(rv) : null;
    }
    console.log("[avgScore] recodeMap:", recodeMap);

    var sum = 0;
    var count = 0;

    for (var r = 0; r < statements.length; r++) {
        var stmtId = String(statements[r]);
        var selectedSpId = null;

        for (var c = 0; c < scalePoints.length; c++) {
            var spId = String(scalePoints[c]);
            if (this.getChoiceValue(stmtId, spId)) {
                selectedSpId = spId;
                break;
            }
        }

        var recodeVal = recodeMap[selectedSpId];

        if (recodeVal === null || recodeVal === undefined || EXCLUDED_RECODE_VALUES.indexOf(recodeVal) !== -1) {
            console.log("[avgScore] stmt", stmtId, "→ col", selectedSpId, "recode", recodeVal, "→ excluded, skipped");
            continue;
        }

        console.log("[avgScore] stmt", stmtId, "→ col", selectedSpId, "recode", recodeVal, "→ counted");
        sum += parseFloat(recodeVal);
        count += 1;
    }

    console.log("[avgScore] sum:", sum, "| count:", count);

    var edKey = "average" + qid;
    var result = count > 0 ? (sum / count).toFixed(DECIMAL_PLACES) : "";

    console.log("[avgScore] storing ED key:", "__js_" + edKey, "| value:", result === "" ? "(empty)" : result);
    Qualtrics.SurveyEngine.setJSEmbeddedData(edKey, result);
});