mapping of URL parameters to embedded data using lookup table + business rules

Question

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

TomG · Accepted Answer

This is best handled with web service call to an external database.  You just need a web host/server to host the script and database.

AndreasGenz · Answer

Hi Tom,thanks for your reply!The issue is that the mapping table contains sensitive information which mustn't leave the Qualtrics server. Therefore this needs to happen in Qualtrics.BestAndreas

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded