Forum Discussion

Stephony_DBH_'s avatar
Stephony_DBH_
Qrew Cadet
8 years ago

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 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_
  • MichaelBarrow's avatar
    MichaelBarrow
    Qrew Cadet
    8 years ago
    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.
    • MCFNeil's avatar
      MCFNeil
      Qrew Captain
      8 years ago
      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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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?