Restrict what is inputted in a text field
I have a survey that I will be sending out to internet users. I am pushing out an email with a unique ID for each person. They have to enter this to take the survey and once that ID is used they will ...
Forum Discussion
One thing you could do is make their ID the primary key in your survey results table, and pre-populate the records with empty results. When they take the survey, they will be updating their already-created survey results record, not adding a new one. Prevent additions through the role and only allow modifications.
If you do this then people will be able change other people's responses by changing the value by one. Which I think is much worse than the original issue.