Discussions

Expand all | Collapse all

Restrict what is inputted in a text field

  • 1.  Restrict what is inputted in a text field

    Posted 06-30-2017 19:02
    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_


  • 2.  RE: Restrict what is inputted in a text field

    Posted 06-30-2017 20:41
    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.


  • 3.  RE: Restrict what is inputted in a text field

    Posted 07-06-2017 06:48
    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.


  • 4.  RE: Restrict what is inputted in a text field

    Posted 07-06-2017 18:43
    Good point - bad idea!


  • 5.  RE: Restrict what is inputted in a text field

    Posted 07-06-2017 06:53
    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?