Hi everyone,



I've got a question about data mapping possibilities in Qualtrics.



We have a survey where we recieve different information via URL parameters. Those URL parameters need to be mapped to embedded data fields.

Currently we use some JS script to map some URL parameters:



`Qualtrics.SurveyEngine.addOnload(function() {

var dict = {

"StoreA": "1",

"StoreB": "2",

"StoreC": "3"

};

Qualtrics.SurveyEngine.setEmbeddedData("DirectRetail", dict["${e://Field/U_DR}"]);

});`



This approach has 2 major drawbacks:



* When we have many different values the dictionary/lookup table becomes very large and confusing

* The lookup table can't be maintained by the client by uploading a table to Qualtrics





We would now need to apply some mapping from 6 URL parameters to 2 embedded data fields. This mapping would need to work using a lookup table (which needs to be uploaded and updated in Qualtrics) and also some sort of business rules (logic sets). This could look something like this:



Source parameters: A, B, C, D, E, F

Target parameters: Y, Z



Lookup table for parameter A:

> key1 --> value1

> key2 --> value2

> ...



Lookup table for parameter C:

> key1 --> value1

> key2 --> value2

> ...



Lookup table for parameter E:

> key1 --> value1

> key2 --> value2

> ...





Business rules:



> If (lookupTable(A) == example1) {

> Y = B

> }

>

> If ((lookupTable(A) == example2) OR (lookupTable(C) == example3) {

> Y = D

> }

>

> ....

>

> if (lookupTable(E) == example4) {

> Z = F

> }

>

> ....



Has anyone experienced similar needs and maybe already found some workaround?

Is any feature like this data mapping currently planned for Qualtrics?



Thank you in advance!



Best regards

Andreas