|
|
| (4 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| == Use Case ==
| | #REDIRECT[[Repeat_Groups_and_Rosters_in_SurveyCTO]] |
| In this example we list name and age for up to 10 children in a repeat group. In the second repeat group we list the children in age order and ask the respondent to select a child that has his or her mother present. If the first child's mother is not present then the second youngest child is listed and the respondent is again asked to select the child that has his or her mother present. If two children has the same age, then both children are listed at the same time and the respondent is asked to select one of them.
| |
| | |
| If a child is selected no more children is listed and the name and index in the first repeat group is stored in separate calculate fields so that they can be referenced later. If no child has a mother present then these two calculate fields are empty.
| |
| | |
| == Code Explanation ==
| |
| The example code can be found [https://docs.google.com/spreadsheets/d/1mi_nQdrcoj-y5onePzG0gluXMciuWxW3DjFf-SErz1I/edit?usp=sharing here]. The first loop and how the child names are dynamically loaded into the choice list used in the second loop is explained [[SurveyCTO_Dynamically_Populated_Choice_Lists|here]].
| |
| | |
| The second loop is repeated up to the same number of times as there are unique ages in the child roster, but the repeats are stopped as soon as a child is selected. That is achieved by first joining all ages in ''child_ages'' and remove duplicates. Duplicates are removed as children with the same ages are listed at the same time. Then the number of elements is counted in ''child_ages'' in field ''unique_ages_num''. This is used as the maximum number of repeats, but the repeat count is created in ''mother_select_repeat_count'' that is set to 0 as soon as a child is selected.
| |
| | |
| The most complicated part of the code is the filter expression in ''select_mother_present''. The expression has two part <code>rank-value(indexed-repeat(${child_age},${child_roster},filter),${child_ages}) = ${unique_ages_num} + 1 - ${mother_index}</code> and <code>filter = 0</code>. The second part is the easiest and is used to always show the option ''Not Present''.
| |
| | |
| The first part of the filter expression takes the use ''indexed-repeat()'' to get the age of all children and test how they rank in the list in ''child_ages'' using the ''rank-value()'' function. The filter column in the ''choices'' tab make sure that each child is associated with its correct age in ''indexed-repeat()''. The <code>${unique_ages_num} + 1 - ${mother_index}</code> converts the ''mother_index'' from the ascending order generated by ''index()'' to the ascending order returned by ''rank-value()''.
| |
| | |
| When no child is selected ''child_index_mother_present'' is set to zero but when a child is selected it is set to the index of that child. When ''child_index_mother_present'' takes a non-zero value ''child_index_selected'' is no longer zero and the repeat group count is set to zero and the repeat group is exited. ''child_index_selected'' is then used to get the name of the child selected.
| |
| | |
| == Back to Parent ==
| |
| This article is part of the topic [[SurveyCTO Coding Practices]]
| |
| | |
| [[Category: SurveyCTO Coding Practices ]]
| |
