Skip to main content
Question

Restrict what is inputted in a text field

  • June 30, 2017
  • 0 replies
  • 70 views
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_
      This topic has been closed for replies.

      • MichaelBarrow
      • Quickbase Alumni
      • July 1, 2017
      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
      • Quickbase Alumni
      • July 6, 2017
      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?
      Terms & ConditionsAccessibility statement