Quote:
Originally Posted by Patrick Flynn
This is currently a work in progress, I have not determined an easy way to do this with Google forms yet though. If you have any suggestions please point me in that direction.
|
If you go from a question into advanced settings there is a data validation option. If you select Regular expression -> Contains -> [enter options]. Google says they use
regex which would use the line | as "or" so entering
would allow only those inputs. It also allows custom error text if you want to explain that you only let teams that competed be nominated. I don't know of a way that you can allow an input from a spreadsheet unless you want a drop down list--there's an add on for that but scrolling through can be very difficult.
I'm not sure if there's a limit for how many options the form can have. I tried 1|2|3...|50 and it allowed that*, but I didn't test beyond that because I haven't found a fast way to string together numbers (I used concatenate in excel but it still takes me a while).
Picture of the options I selected:
Valid entry in a form:
Invalid entry in a form:
*It also allowed 51 as an entry, but I'm not sure if it's because of a typo I made, the length of the options, or something else.