We've got SP2010 foundation, and the other limitation is that we do not have access to SPD or any of the programmatic ways of accomplishing this. I'm looking for information about how to set this up in a validation formula on the survey settings page.
We're using a survey as a checkpoint quiz after a training session, and each question has a three-choice radio button with one correct answer. We are trying to validate the correct answers, and ONLY advance users to the next question when they answer correctly.
For instance:
What is 1+1? Today is
O 1 -or- O Monday
O 2 O Tuesday
O 3 O Wednesday
Validation Formulae:
=[What is 1+1]="2" =[Today is]="Monday"
My expected result is that when "2" or "Monday" are selected from the respective lists, validation passes and the survey advances to the next question. If the choice does not validate, a default "please try again" message will prompt the user until the correct selection is made.
However, using this approach, I get an ERROR: List validation failed
dialog box no matter which answer I select in a survey question. Is there a way to evaluate the selected value in a formula?