Restrict what is inputted in a text field

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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 not be able to enter it a second time. However, if someone simply changes the last number then it will allow them to enter another survey. 

How do I create a formula that only allows the users to input an ID that come from a prepoulated list? 

I do not want someone to be able to submit more than one survey and it has to be anonymous for the people analysis the results which is why I am using an ID number instead of their email addy.

Thanks
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
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.
Photo of Matthew Neil

Matthew Neil

  • 31,418 Points 20k badge 2x thumb
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.
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
Good point - bad idea!
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Using everyone on the internet and then needing this type of restriction is tough because you really can't control/prevent them from manipulating the URL.

Have you considered using an outside source, (Google Forms, Gravity Forms, etc) that has the features to limit one per entry?