(1) Use ODK Briefcase to download your results from ODK Aggregate to your

desktop.

Then use ODK Briefcase's Export to CSV function to emit csvs of your data.

You will have one csv for your main form, and one csv for each repeat

group within it. Link the two together via the PARENT_KEY and KEY fields.

(2) if publishing, instead of publishing to Google Spreadsheets, publish

to Google Fusion Tables.

You will get a separate fusion table for the main form and each repeat

group. And, we also generate a

fusion table that joins the main form with all the first-level repeat

groups (tying together the KEY and PARENT_KEY fields of these).

If you have nested repeat groups, you could define your own composite

Fusion Table with whatever result structure you need.

================

(1) is good for analysis at the end of a survey or periodically throughout.

(2) is good for continuous access to incoming data, as once you set up the

publisher, and the tables, the data just flows into them without any manual

processing.

On Tue, Oct 21, 2014 at 7:38 AM, Oundo Moses wagson.2011@gmail.com wrote:

Halo Team,

Is there any one who may advice me on how to avoid having part of my

submissions in a "link" it is a repeat part of the form

And it is a link, instead of the normal results like the other variables.

Would like to know the mistake i made in form design, and or how to avoid

this kind of results in the future

Here is an example of the linked set of variables, associated with the

link results, and the result it's self.

```
begin group production_sales PRODUCTION AND SALES OF MAIZE (Last
```

Most Recent Season) selected(${farmer_type}, '1') and

selected(${proceed}, '1') and selected(${maize_grown1}, '1') begin

repeat plot PLOT field-list integer plot_number Plot number 1, 2, 3,

or 4. . >= 1 and . <= 4 don't exceed four plots yes decimal plot_size What

was the size of this plot (acre) estimate size in acres yes decimal

qty_sd_used What was the Quantity of Maize Seed used on this Plot (kgs)

in the last season estimate the quantity in kilogrammes yes select_one

sd_type sd_type_used What was the Type of maize Seed used on this plot

in the last season yes select_one unit_type tt_sd_produced1 In what

UNITS did you Harvest the Maize on this plot in the last season yes

minimal decimal tt_sd_produced2 How many of these UNITS referred to in

the previous question did you Produce from this Plot in the last season

yes decimal tt_sd_weight What is the estimated Weight of each UNIT in

Kilogrames? estimate in kilogrammes yes selected(${tt_sd_produced1},

'1') or selected(${tt_sd_produced1}, '2') or selected(${tt_sd_produced1},

'3') or selected(${tt_sd_produced1}, '5') end repeat end group

and here is the type of result am getting from it!

https://bracresearch.appspot.com/view/formMultipleValue?formId=LEAD_Baseline_TZ_Data[%40version%3Dnull+and+%40uiVersion%3Dnull]%2FLEAD_Baseline_TZ_Data[%40key%3Duuid%3Ae4939f1f-2bab-4ad2-9b8f-491adf5e6e69]%2Fproduction_sales%3Aplot

Thank you for the Advice

## --

Post: opendatakit@googlegroups.com

Unsubscribe: opendatakit+unsubscribe@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups

"ODK Community" group.

To unsubscribe from this group and stop receiving emails from it, send an

email to opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Mitch Sundt

Software Engineer

University of Washington

mitchellsundt@gmail.com

## --

Post: opendatakit@googlegroups.com

Unsubscribe: opendatakit+unsubscribe@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the

Google Groups "ODK Community" group.

To unsubscribe from this topic, visit

https://groups.google.com/d/topic/opendatakit/tnJStKmr1jo/unsubscribe.

To unsubscribe from this group and all its topics, send an email to

opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.