Dynamic Excel Spreadsheet in Qualtrics

[@DevanBernardino]

JavaScript
Qualtrics.SurveyEngine.addOnReady(function() {
// Get all the input elements
var inputs = document.querySelectorAll("#spreadsheet input[type=text]");
// Attach an event listener to each input element
inputs.forEach(function(input) {
input.addEventListener("input", function() {
// Get the current row number
var rowNum = input.id.slice(-1);
// Get the values of column A and B
var a = document.getElementById("a" + rowNum).value;
var b = document.getElementById("b" + rowNum).value;
// Perform the calculation and update the value of column C
var c = (parseFloat(a) + parseFloat(b))/2;
document.getElementById("c" + rowNum).value = c;
// Set the value of column C to the corresponding embedded data field
Qualtrics.SurveyEngine.setEmbeddedData("TotalFruit" + rowNum, c);
});
});
});
Source Code:

Apple
Orange
Total Divided by 2

[@Manibrights]

Great work 👍

[@DevanBernardino]

Thanks Mani

[@kayseibert1077]

Your videos are nice and clear. Can you help me with this scenario? I need to set up a weekly AUTOMATED excel spreadsheet from a Qualtrics survey to an alias email. How do I do that? Is that a workflow?

[@Manibrights]

Hi Devan
If possible, please make video Custom Email configuration

[@DevanBernardino]

Hi Mani,
I created a video for Custom Email Configuration. Let me know if that is what you were looking for.
Thanks!