Validating student id from a list but recording a different but associated id

We want to validate the student’s id prior to taking the survey but store a corresponding id.

The student id is not the unique key to their record, but it is used for all kinds of student rosters, etc. so it’s easy to find someone if you had their “public” student id. But the actual record_id is something different, that no one would know, only the database administrator.

So we’d like to validate the student id but record the record_id. So if you looked at the data in qualtrics, you wouldn’t be able to identify the person, unless you were the database administrator and looked up their student_id based on record_id.

This is a means of making the survey not 100% anonymous, but it’s a strong measure to make it basically impossible to identify the respondent, with appropriate language at the beginning of the survey.

So like this

Student_id      Record_id
-----------------       ----------------
241234            87439

The respondent enters 241234 and it’s validated but 87439 is recorded in Qualtrics.

This post helped but I’m taking it a step further.