Hi everyone!
I am running multiple surveys which I then gather into a single database of ours. I'm currently using the ResponseID as the unique ID of each survey in the database. However, I was wondering whether this variable is unique across surveys (per account) or whether it's only going to be unique on a survey basis.
I.e. will there be a (very tiny, yet realistic) chance of ResponseIDs from survey A and survey B to be identical?
The easy fix would be to prefix each ResponseID with a fixed ID of the survey (e.g. "A_R_123456789" vs "B_R_123456789"), but I'm only going to update my database accordingly if it's necessary This does assume that the ResponseID is always a guaranteed unique ID (for which I found conflicting information online: is it random or is it random & unique?).
Thanks!
Michael
Best answer by faris
View original