Building odk in excel relevant

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.

House.xlsx (47.3 KB)

Hi Karisa,

  1. Start with a one question form with one image. Does that work?

  2. Add a select one that asks for the unit (months/years).

3/4. Start with a small three question form that explores branching.
http://xlsform.org/#relevant is a great place to start. For the last
example, it'll probably look like: ${gender} = 2 and ${age} >=15.

Yaw

ยทยทยท -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Mon, Feb 1, 2016 at 12:32 AM, Karisa Kazungu kkarisah@gmail.com 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.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.