Hello Everyone, I am trying to pull/fetch data (Full Name & Email) of my survey's applicants in a custom-made question(attached PNG file), which I have developed using html, css, and javascript on the Qualtrics platform.In this question, I let the users type some characters of either their full name or their email and I autofill/autocomplete for them the rest information of the field that they edit as well as the corresponding value of the other field. For the moment, I have initialized a variable called 'data', where I provide-hardcode the parameters/values for these two fields (Full name and Email) and based on these values I do the auto-completion for the users (For more information check the code in the attached file).Ideally, I am looking for a solution/suggestion from you, on how I can pull/fetch the needed information(Full name and email of the users) from an (external) source ( e.g. Excel-CSV file, Qualtrics contact list, embedded data field, etc.) to my custom "Autocompletion" question. Thank you very much in advance.

@TelisKan,To access external data with ajax from any site other than Qualtrics, the server side script must include an appropriateAccess-Control-Allow-Origin header in the output.This applies regardless of the data source (database, etc.).If you don’t control the web service, you can’t add the Access-Control-Allow-Origin header.If you have access to a web server you can create a database table there and write a web service to retrieve the data from the database.Then use ajax to call the web service from your question.Otherwise, you arelimitedto storing the data on Qualtrics. There are two possible options:Use the Qualtrics Autocomplete Questions functionality if it is available on your account (it probably isn’t)Upload the csv to your Qualtrics library and use JS to retrieve the data with ajax and parse it.

Moved this one to the Custom Code category -- curious to see what our Custom Code experts have to say on this one! 🤓

How to read/fetch data from an (external) source (e.g. csv file or Database) to my customized question?

How to read/fetch data from an (external) source (e.g. csv file or Database) to my customized question? | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded