I am trying to survey few households in my area. The logic is to collect the details of house like houseno,wardno and then the number of members present in the house and then to collect the details like name,age and sex of the all the members. To make the same possible came to know about the repeat…

Households.xml (3.7 KB) Attaching the xml file and xlsx file for reference Households.xlsx (13.9 KB)

Google Drive has a few limitations. No repeats (see Repeat groups and google sheets upload - #11 by LN ) The form must have less than 254 variables. Any non-group row (e.g., text, integer, select_one, geopoint, calculate, date) is considered a variable. Only alphanumeric characters (123ABCdef) and …

As far as repeats behavior of Aggregate, there is currently no easy way to flatten the data, @mistcrrgpsa . You can stream data to Fusion Tables and that will flatten it. Or export to CSV and flatten as you wish. I don’t see this filed as a feature request yet. Perhaps you can file it?

Thank u Yaw, At the same time i would like to suggest the below. As the repeat is part of the succeeding questions, there can be a login in repeating the master data for the repeat questions if the user wishes for the same. i.e Lets say in my case the parent data is Local Body Name, House No, W…

As the repeat is part of the succeeding questions, there can be a logic in repeating the master data for the repeat questions if the user wishes for the same. Thanks & Regards,Anup Krishna P,Specialist MIS,State Program Management Unit(SPMU),Rasthriya Gram Swaraj Abhiyan (RGSA),Local Self Govern…

This feature is in ODK Aggregate server and you are using 2 methods one is ODK Aggregate and second is google drive. Use ODK Aggregate and then append all data in a one CSV file with the help of Stata and then export that into excel and put that on google drive. This is solutions which I can give yo…

If you would like to see repeat support in the Google Sheets integration, please vote and comment at Repeat groups and google sheets upload .

ODK Forum

Using Repeats in XLSForm with Google Drive and Aggregate

Support

odk-xlsform

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.