Good Day All!
I`m Neil of Tacloban City Philippines and working on coming up a household
level survey.
I have just started on some questions using the XLSForm, based on the
reference got online.
We would like to ask help on some issues for us to come up a mobile survey
using mobile device.
The survey covers the household and members basic information. There are
sets of questions that will be repeated ask to each of the member, it`s
about 20 questions.
We would like to adopt the format below for the database.
Example:
In Household Number 1, there are 3 household member.
In Household Number 2, there are 2 household member.
HouseholdNumber MemberID MemberSurname
MemberFirstName Q1 Q2 Q3 .....Q20
1 1 Member1_Surname
Member1_FirstName M1_A1 M1_A2 M1_A3 .....M1_A20
1 2 Member2_Surname
Member2_FirstName M2_A1 M2_A2 M2_A3 .....M2_A20
1 3 Member3_Surname
Member3_FirstName M3_A1 M3_A2 M3_A3 .....M3_A20
2 1 Member1_Surname
Member1_FirstName M1_A1 M1_A2 M1_A3 .....M1_A20
2 2 Member2_Surname
Member2_FirstName M2_A1 M2_A2 M2_A3 .....M2_A20
In the set of questions I'm working on. I have following questions for this.
1. What is the Assigned Household Number?
2. How many members are there in the household?
3. What is the members Surname? 4. What is the members Surname?
5...... Q1 - Q20
Is this possible in the ODK? How will I code it in the XLSForm to adopt
the above format?
Thanks in advance!
God bless.
Neil Jerson
Hi Neil,
It will be easy to have this format by inserting in a « begin repeat...
end repeat » structure all the questions you want to ask for the
households members . The memberId must be the « calculate type» and in
the field 'calculation' you must put this function "position (..)" to
assure that memberID start with the number 1 for each household and this
will be handle by the system.
type name label
calculation
begin repeat houshold Household members
calculate MemberID Household number
position(..)
text Surname What is the member`s Surname?
text FirstName
...
end repeat
I hope this wil help you
···
2014-07-22 1:48 GMT-07:00 neil jerson de los santos :
Good Day All!
I`m Neil of Tacloban City Philippines and working on coming up a household
level survey.
I have just started on some questions using the XLSForm, based on the
reference got online.
We would like to ask help on some issues for us to come up a mobile survey
using mobile device.
The survey covers the household and members basic information. There are
sets of questions that will be repeated ask to each of the member, it`s
about 20 questions.
We would like to adopt the format below for the database.
Example:
In Household Number 1, there are 3 household member.
In Household Number 2, there are 2 household member.
HouseholdNumber MemberID MemberSurname
MemberFirstName Q1 Q2 Q3 .....Q20
1 1 Member1_Surname
Member1_FirstName M1_A1 M1_A2 M1_A3 .....M1_A20
1 2 Member2_Surname
Member2_FirstName M2_A1 M2_A2 M2_A3 .....M2_A20
1 3 Member3_Surname
Member3_FirstName M3_A1 M3_A2 M3_A3 .....M3_A20
2 1 Member1_Surname
Member1_FirstName M1_A1 M1_A2 M1_A3 .....M1_A20
2 2 Member2_Surname
Member2_FirstName M2_A1 M2_A2 M2_A3 .....M2_A20
In the set of questions I'm working on. I have following questions for
this.
1. What is the Assigned Household Number?
2. How many members are there in the household?
3. What is the members Surname? 4. What is the members Surname?
5...... Q1 - Q20
Is this possible in the ODK? How will I code it in the XLSForm to adopt
the above format?
Thanks in advance!
God bless.
Neil Jerson
--
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.
Hi Neil,
It will be easy to have this format by inserting in a « begin repeat...
end repeat » structure all the questions you want to ask for the
households members . The memberId must be the « calculate type» and in
the field 'calculation' you must put this function "position (..)" to
assure that memberID start with the number 1 for each household and this
will be handle by the system.
type name label
calculation
begin repeat houshold Household members
calculate MemberID Household number
position(..)
text Surname What is the member`s Surname?
text FirstName
...
end repeat
I hope this wil help you
···
2014-07-22 1:48 GMT-07:00 neil jerson de los santos :
Good Day All!
I`m Neil of Tacloban City Philippines and working on coming up a household
level survey.
I have just started on some questions using the XLSForm, based on the
reference got online.
We would like to ask help on some issues for us to come up a mobile survey
using mobile device.
The survey covers the household and members basic information. There are
sets of questions that will be repeated ask to each of the member, it`s
about 20 questions.
We would like to adopt the format below for the database.
Example:
In Household Number 1, there are 3 household member.
In Household Number 2, there are 2 household member.
HouseholdNumber MemberID MemberSurname
MemberFirstName Q1 Q2 Q3 .....Q20
1 1 Member1_Surname
Member1_FirstName M1_A1 M1_A2 M1_A3 .....M1_A20
1 2 Member2_Surname
Member2_FirstName M2_A1 M2_A2 M2_A3 .....M2_A20
1 3 Member3_Surname
Member3_FirstName M3_A1 M3_A2 M3_A3 .....M3_A20
2 1 Member1_Surname
Member1_FirstName M1_A1 M1_A2 M1_A3 .....M1_A20
2 2 Member2_Surname
Member2_FirstName M2_A1 M2_A2 M2_A3 .....M2_A20
In the set of questions I'm working on. I have following questions for
this.
1. What is the Assigned Household Number?
2. How many members are there in the household?
3. What is the members Surname? 4. What is the members Surname?
5...... Q1 - Q20
Is this possible in the ODK? How will I code it in the XLSForm to adopt
the above format?
Thanks in advance!
God bless.
Neil Jerson
--
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.