# Designing questionnaire on odk xls form

**URL:** <https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111>\
**Category:** Support\
**Created:** [January 9, 2019, 7:28am UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111 "2019-01-09T07:28:18Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adordeng](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/adordeng/32/5429_2.png) [@Adordeng](https://forum.getodk.org/u/Adordeng)\
**Post date:** [January 9, 2019, 7:28am UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111/1 "2019-01-09T07:28:18Z")

</div>

Continuing the discussion from [Quick ways to contribute](https://forum.getodk.org/t/quick-ways-to-contribute/9633):

[ertwash\_hhold\_questionnairefinal](https://getodk.b-cdn.net/uploads/default/original/2X/b/bbfadcc5c4f6c8807a5b8ec29791a0f9455fcb5d.xlsx)

---

<div class="post-metadata">

**Author:** ![Adordeng](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/adordeng/32/5429_2.png) [@Adordeng](https://forum.getodk.org/u/Adordeng)\
**Post date:** [January 9, 2019, 7:32am UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111/2 "2019-01-09T07:32:47Z")

</div>

need help on the attached designed form.the two rows 41& 42 with the highlighted questions in 'red'.I need questions 41 to show answer and the answer should be less or equal to 15 liters ppd to ask question 42.If the answer is bigger it should skip question 42.any help?

---

<div class="post-metadata">

**Author:** ![Xiphware](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/xiphware/32/2587_2.png) [@Xiphware](https://forum.getodk.org/u/Xiphware)\
**Post date:** [January 9, 2019, 8:00am UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111/3 "2019-01-09T08:00:56Z")

</div>

> [@Adordeng](#):
>
> I need questions 41 to show answer and the answer should be less or equal to 15 liters ppd to ask question 42.

Try this. For 42: ${reason\_water\_consumption\_low}, specify:

`relevant = '${amount_water_collected_ppday_note} <= 15'`

In ODK XForms, you can use the `relevant` property to specify when to show/hide a particular question. See [conditionally showing questions](https://docs.opendatakit.org/form-logic/#conditionally-showing-questions) for details.

---

<div class="post-metadata">

**Author:** ![Adordeng](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/adordeng/32/5429_2.png) [@Adordeng](https://forum.getodk.org/u/Adordeng)\
**Post date:** [January 9, 2019, 9:42am UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111/4 "2019-01-09T09:42:52Z")

</div>

Many thanks Xiphware.will try

---

<div class="post-metadata">

**Author:** ![Frimpongeben1](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/frimpongeben1/32/5549_2.png) [@Frimpongeben1](https://forum.getodk.org/u/Frimpongeben1)\
**Post date:** [January 9, 2019, 1:44pm UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111/5 "2019-01-09T13:44:30Z")

</div>

Hi family  
I have been using the ODK build for some months now for my company's yield survey on cashew, unfortunately for me I have no idea using the ODK xls format. Please can anyone help me to learn this format because I want to use for more works for my company.

Thanks in advance.  
Ebenezer.

---

<div class="post-metadata">

**Author:** ![Xiphware](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/xiphware/32/2587_2.png) [@Xiphware](https://forum.getodk.org/u/Xiphware)\
**Post date:** [January 9, 2019, 3:59pm UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111/6 "2019-01-09T15:59:08Z")

</div>

Please check my earlier Forum posting [here](https://forum.getodk.org/t/xlsform-giving-error/16936/2), which has a few links to useful XLSForm resources.

---

<div class="post-metadata">

**Author:** ![Frimpongeben1](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/frimpongeben1/32/5549_2.png) [@Frimpongeben1](https://forum.getodk.org/u/Frimpongeben1)\
**Post date:** [January 10, 2019, 12:03pm UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111/7 "2019-01-10T12:03:09Z")

</div>

Thank you Dr. for your response

---

<div class="post-metadata">

**Author:** ![Adordeng](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/adordeng/32/5429_2.png) [@Adordeng](https://forum.getodk.org/u/Adordeng)\
**Post date:** [February 8, 2019, 1:41pm UTC](https://forum.getodk.org/t/designing-questionnaire-on-odk-xls-form/17111/8 "2019-02-08T13:41:18Z")

</div>

Can someone show me how to map households in an ODK phone with these featuring on the map?  
1.Name of the community  
2.physical features e.g roads, water points,churches....  
3.HH with under 5