Which field(s) to use a primary key ?



We store the responses in database and use it for analytics etc. We need to define a primary key for table storing the survey responses. Which field(s) or combination do we use as primary key which guarantees uniqueness.

We can not use Response ID, as although Response ID maybe unique for a given survey but it is not unique across surveys, so thinking it has to be a combination of keys. I was not sure if Survey ID gets exported as part of results, hence the question.

Thank you for your time and help.

Saarak answered

    I found the answer for this one, using [survey(“id”)] merge code for populating hidden value.




    Saarak answered


      Question stats

      • Active
      • Views4399 times
      • Answers1 answer
      • Followers1 follower