Hi Daniel, You can find information on how to use indexed-repeat() at https://opendatakit.org/help/form-design/binding/ and http://xlsform.org/ref-table/ . https://groups.google.com/forum/#!searchin/opendatakit/indexed-repeat|sort:relevance also has lots of threads discussing it. My recommendat…

Dear ODK Users, I am facing a related situation. I have a repeat group (details of household members) where one of the questions is age. As the form progresses, I have another group where I intend to capture information on the prevalence of WATSAN Among Under-five Children. Now I would like this s…

Hi @Musinguzi_Polycarp the error is in cell E24 of your excel file. You are trying to refer a repeated variable ${Q201d}, and the application does not know which iteration you want to use. At the end of the error message you have a hint, which is to use the indexed-repeat() function . In your part…

[image] Andrea_Martin: ${Q201d} Thanks @Andrea_Martin for the tips. Option one is the most relevant in my case, but please advise on how the calculation would look like. Thanks

Any help how to get this calculation done? I have used count(${Q201d})<5, but it doesn't sem to give me the number of children in the family below the age of 5. Kindly assist

Hi @Musinguzi_Polycarp Please find attached ( impact_survey_household_questionnaire_2019_AM.xlsx (28.2 KB) ) an edited version of your form, that should address your problem. The edits include: adding a calculated field (${below5}) editing the relevant field to count how many children below (or e…

Many thanks, @Andrea_Martin . One last thing, having asked the age of each household member in that repeat group, how then can calculate the number of children aged 5 and below as well as those above 5. Using if(${Q201d}<=5,1,0) only shows me that there are children aged 5 and below, but doesn't tell…

Hi @Musinguzi_Polycarp To calculate the number of children below 5 you can do as per file I attached before. There are different approaches, but the one I'm suggesting is: You include in the repeat group a calculate variable "tagging" the observations you are interested in, for example the var $…

Thanks, @Andrea_Martin worked fine.

Hi, @Andrea_Martin I am facing the same issue but not able to trace why this issue is coming. In my case, I am not referring to intergroup and not needed any value from other groups. Please attached the Excel form. The group "Survey" is absolutely working fine, however, as soon as I start group "…

Hi @Naveen_Agarwal I am not sure I understand which issue you are experiencing. I tried to convert the your form with https://opendatakit.org/xlsform/ and it doesn't throw any errors. Kindly provide more details to better assist you (see below). What is the problem? Please be detailed. What ODK …

ODK Forum

How use index-repeat()

Support

odk-xlsform, form-design

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled

Looking for a better way? Try ODK Cloud, the official managed hosting service from the creators of ODK.