I have 10 household_test cases. Each case has several properties:
hh_id
hh_full_name
age
sex
phone_number
I want to run through these cases one-by-one in a repeat group so I can mark attendance (Present/Absent) for each household member. On each screen, I want to see just one person’s hh_full_name, choose Present or Absent, then go to the next person.
Within your repeat group you then use the position() function as you've been doing and simply retrieve the case_id at that position from case_ids_of_interest. From there you can retrieve the applicable fields associated with that case_id using the queries. The join function used to create the case_ids_of_interest works since it is a space-separated list similar to those that CommCare generates for multi-select question types, which allows you to use the selected-at function to retrieve the case_id. Also case_ids themselves do not have any spaces. You cannot have the retrieved values that are being concatenated together also include spaces (for example, a name with spaces). If those values themselves include spaces the count() function and selected-at() function cannot be reliably used to retrieve desired values.
Just keep in your mind after you went through all names then you click submit, you can't edit the attendance sheet even through follow up form, unless you create subcases when you submit the first form.