Rotator Survey Advanced tips for data validation during Data Entry

Rotator automatically performs validations of your data according to many criteria, like for example by variable type, by numeric ranges, by the skips logic programmed in the step �Flow�, among others. Besides these validations, the system offers advanced data validation options that can be programmed by you.

Detecting conditions while loading data
  • Scenario: Suppose you asked in your questionnaire �Age� and �Level of education�, then you want to detect those subjects less than 15 years old and with a level of education equal or higher than "University".
  • How to do it? Go to the Activity 3, step "Conditions and Actions" and create a new condition formula. That formula could be something like: �IF V1 <= 15 AND V2=3� . This is equivalent to say AGE IS UNDER 15 and Education=University. You may also program the system to send a message to the user once the condition is detected.

Validating hierarchized choices:
  • Scenario: : Suppose your survey has two single-choice questions like "City" and "Parish" and then you want that when the users select a City, the system displays only the Parishes of that city.
  • How to do it? Go to the activity "Prepare the Data for the Analysis", then go to the step "Hierarchies" and there create a new hierarchy selecting the desired variables, in our example: "City" and "Parish". Place City above and Parish below and follow the wizard instructions.
  • Another easier way: If the questions City and Parish have not been created yet, instead of having 2 individual questions, you might join them into a single question, i.e. You can name it as �City-Parish� and include all cities and all Parishes within the same list of choices. Proceed to establish the relationship between Parishes and cities. (By selecting the tab ''Advanced'' and then select "Allow indentation". Return to the tab Basic and use the arrows <- -> to stablish the hierarchical relationship). Finally assign to each city the mark "Invisible Aggregation Choice" to avoid the user to select a city.

Validating a code using a mask
  • Scenario: Suppose you want to capture a formatted code using a mask, for example: �AAA-99-99�.
  • How to do it? Create a question type �Short text�, go to the �Advanced� tab, find the section �Format validation� and select from the list the option �Validate according to mask�. Type your mask, for example: �999-AA� indicating that the value expected will accept only 3 numbers, 2 letters and the character �-� as defined by the mask.