Hi all,
I need your help in tackling these questions. I am designing ODK tool using
excel sheet.
-
I have inserted image as a column under survey in excel sheet and
uploaded the images on appspot.com with the form but when I open the form
on ODK collect I get this message File:/storage/emulated/0/odk/form/Draft
House-media/weight.jpg is missing. The same statement appears for the other
inserted images. Kindly assist as I would like the images to appear on the
tablet.
-
Under the age of household member, I put the hint - *Age (in months for
children 0-59 months old; in years for 5 years+) *but I wondering how the
data can differentiated (on the server or once the data has been downloaded
), if the age is for an adult or a child. For example 24 could mean 24
months or 24 years. Is there another way to do this. I hope I am clear on
the issue.
-
How do you put a relevancy so that the entire repeat section
Q2_NEWBORN_INFANT_YOUNGCHILD only appears if the *Age_Household_member *is
between 0-23 months only.
-
How do you out a relevancy to the question Ever_Been_Pregnant so that
it only appears if the gender is Female and also if the age of the
woman is between 15-19 years old? I have put the below relevant tag but
its not working;
selected(${Gender}, '2') and selected(${Age_Household_member}, '>=15 and
selected(${Age_Household_member}, '.<=19')
My guess would probably be that the problem is either in the relevance code
or in the type i.e whether string or interger.
Please find the attached ODK excel sheet for your assistance. Thank you in
advance.
House.xlsx (47.3 KB)
1). Try with a .png format
2). Place a 'pre-Q' (under_5) asking of the person is < 5 years of age (If
yes, qualify for Anthro portion of survey and enter age as months. If no,
not part of anthro (unless doing mother measurements), and enter years. So
you will have a age_months question and a age_years questions, with a
relevant based on the 'under_5'.
-
I assume you want this section to repeat for each child under 24 months?
You would want to do a 'calculation' that sums up the number of children
under 24 months in the household. To do this you place a 'calculate' after
'under 5' (in the repeat group), perhaps named count_u_24, this calculate
would be ----> if(${count_u_24}<24,1,0). This writes a 1 to the data if
person is less than 24 months. Then, outside of the repeat group you create
another calculate, tot_under_24, this calculate would be -->
sum(${count_u_24}). This give you the total number of persons under 24
months. You can than use the 'jr:count' column on the *Q2_NEWBORN_INFANT_YOUNGCHILD
*section, and set that to equal ${tot_under_24} --- so this repeat section
would repeat 4 times if there were 4 people under 24 month.
-
The constraint would be *${Gender}=2 and (**${Age_Household_member} >14
and *${Age_Household_member}<20)
ยทยทยท
On Sunday, January 31, 2016 at 5:34:47 PM UTC-5, Karisa Kazungu wrote:
>
> Hi all,
>
> I need your help in tackling these questions. I am designing ODK tool
> using excel sheet.
>
> 1) I have inserted image as a column under survey in excel sheet and
> uploaded the images on appspot.com with the form but when I open the form
> on ODK collect I get this message File:/storage/emulated/0/odk/form/Draft
> House-media/weight.jpg is missing. The same statement appears for the other
> inserted images. Kindly assist as I would like the images to appear on the
> tablet.
>
> 2) Under the age of household member, I put the hint - *Age (in months
> for children 0-59 months old; in years for 5 years+) *but I wondering how
> the data can differentiated (on the server or once the data has been
> downloaded ), if the age is for an adult or a child. For example 24 could
> mean 24 months or 24 years. Is there another way to do this. I hope I am
> clear on the issue.
>
> 3) How do you put a relevancy so that the entire repeat section
> *Q2_NEWBORN_INFANT_YOUNGCHILD* only appears if the *Age_Household_member *is
> between 0-23 months only.
>
> 4) How do you out a relevancy to the question *Ever_Been_Pregnant* so
> that it only appears if the *gender is Female and also if the age of the
> woman is between 15-19 years old*? I have put the below relevant tag but
> its not working;
>
> *selected(${Gender}, '2') and selected(${Age_Household_member}, '>=15 and
> selected(${Age_Household_member}, '.<=19')*
>
> My guess would probably be that the problem is either in the relevance
> code or in the type i.e whether string or interger.
>
> Please find the attached ODK excel sheet for your assistance. Thank you in
> advance.
>