Hi All,

I am trying to assign unique IDs for participants filling out my survey. I am storing first name, last name, last name, email and phone number to an XM Directory Lite Contact List. I want Qualtrics to search this list before assigning IDs to participants. 

Basically,

If someone fills out the survey and reports an email that already exists on the XM contact list (i.e., they are trying to fill out the survey again), they will be assigned a value of -55.

If someone fills out the survey and reports an email that doesn’t exist on the contact list (i.e, they have NOT filled out the survey already), they will be assigned a new unique ID.

I have asked the Qualtrics AI, but nothing seems to be working.

Please see the image for what I have tried.

Where “emaile” = email that the participant reported in the survey

Where “Email” is the embedded email from the XM Directory Contact List.