I am trying to experiment with Sheets as the server, all seems to be running smoothly except for the repeat group. I gather this functionality now exists but I am not sure what I need to do to actually make it work.
I am using ODK collect v1.16.4
I create the form in Excel and then convert to XML using http://opendatakit.org/xlsform/
I have set "submission_url" in settings sheet to the editable sharing link for the target sheet in Google drive
Do I need to create a separate sheet, or tab in the existing submission sheet, to receive the data from the repeat group? And do I need to put the separate "submission URL" for this sheet somewhere in my original XLS/XML? If so - where?
As it is, the cell for the repeat group in the parent sheet just says: =HYPERLINK("null", "rmf_monitoring_form_gdrive-visit_1-rcm_plan")