My form employs skip logic to tailor the question set depending on the age of the person entered. For example, if a person is 51 years old, they see the group of questions for 50-60 year olds. Other key info:
- All questions have the answers YES, NO, DON'T KNOW.
- Field-list appearance is applied to each question group to achieve that all relevant questions for that person, based on his age, appear on the same screen.
Test form attached here. test.xlsx (81.3 KB)
How can I achieve the following three requirements using XLS Forms (e.g. Relevant column?)?
Scenario: Age of person = 50. The question set relevant for this age group (50-60 year olds) is displayed.
If the first question = YES, then if 5 consecutive NOs are entered at any point in the question set, all questions following the one with the 5th NO are removed (skipped)
If the first question = NO, then if 4 consecutive NOs are entered following this first NO (total of 5 NOs consecutively), then the rest of the questions for that age group are skipped, and instead the questions from the previous age group (40-50 year olds) must be answered.
Even though the full question set appears on a single screen (using groups & field-list appearance), all questions must be answered in the order they appear (an answer to a question is only allowed if the previous question has already been answered).
What app or server are you using and on what device and operating system?
Using XLS Forms on ODK Collect v1.22.4 connected to ODK Aggregate v2.0.3
Thank you very much for your help.