Is there any way to populate fields in a repeat group based on information submitted in the parent form?
We use ODK for gathering information about students we support in schools. The information submitted from these forms is automatically mapped into our database through Jitterbit, with one record per student.
We need to gather general information such as the date, the name of the data collector and the name of the school, as well as student specific information in every record inserted into our database. We can map information from either the parent or the repeat group into a single record in our database, but not from both. This has led us to use forms without repeats, where the data collector has to enter all of this general information (such as date etc.) every time, for every student. We sometimes get complaints from the data collectors about how long these forms take to complete, and it would be great if we could design the forms so that they only need to enter the general information once, and then use a repeat group to enter the specific information about each of the students. This would be possible if all of the general information entered in the parent could be pulled into the repeat but I do not know of any way this can be done.
We primarily use XLSForm for creating forms, but would be willing to venture into making XML edits if this provided a solution.
Or, if you wrote your own app to fetch data (e.g., 'choose the school'),
you could use the external app feature to populate a set of values about
the school from a single request to this external app.
ยทยทยท
On Tue, Jan 27, 2015 at 7:17 AM, wrote:
Hi everyone,
Is there any way to populate fields in a repeat group based on information
submitted in the parent form?
We use ODK for gathering information about students we support in schools.
The information submitted from these forms is automatically mapped into our
database through Jitterbit, with one record per student.
We need to gather general information such as the date, the name of the
data collector and the name of the school, as well as student specific
information in every record inserted into our database. We can map
information from either the parent or the repeat group into a single record
in our database, but not from both. This has led us to use forms without
repeats, where the data collector has to enter all of this general
information (such as date etc.) every time, for every student. We sometimes
get complaints from the data collectors about how long these forms take to
complete, and it would be great if we could design the forms so that they
only need to enter the general information once, and then use a repeat
group to enter the specific information about each of the students. This
would be possible if all of the general information entered in the parent
could be pulled into the repeat but I do not know of any way this can be
done.
We primarily use XLSForm for creating forms, but would be willing to
venture into making XML edits if this provided a solution.