How to set data pulled from google sheet as embedded data?

Question

Hey all,Im having a difficult time navigating the google sheet workflow and was hoping someone could point me towards a solution. I have set up my workflow and have confirmed that it is pulling from the correct cell, but now I need to set that value set as embedded data to be used in the survey and I cannot for the life of me get it working.Ive tried using the Code workflow to set the value, as seen belowfunction codeTask() {  // Access the data retrieved from the Google Sheet task in Qualtrics  var value = Qualtrics.SurveyEngine.getEmbeddedData(~{ch://OCAC_3Oi8XgpnB4rN99s/LookupData});  // Set the value to the embedded variable "Number"  Qualtrics.SurveyEngine.setEmbeddedData('Number', value);  // Log the result for debugging purposes  console.log('Value retrieved from Google Sheet and stored in embedded variable', value);  return {    result: ""  }} but I keep getting the “ReferenceError: Qualtrics is not defined” error  Im only barely familiar with JavaScript so I would not be surprised if I goofed something up, but ive been able to use the .setEmbeddedData function successfully in the past and just dont know what is going wrong.anyways, im not married to the code workflow if there is a more elegant way to plug that data into an embedded data field. any help/suggestions would be greatly appreciated. Thanks

ahmedA · Answer

Workflows are usually run at the end of the survey, so I’m not sure how you’ll use the set value inside the survey.The issue with your code is that the code task is usually run on a separate server, hence there is nothing called Qualtrics (i.e., the reference error), which only present in your browser when the survey is running.What you could try is to either pass the value of the ED via query string parameters or run a web service task inside your survey flow.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded