Relevant: ABC and DEF or ABC and GHI

Support
1

Hi there,

I'm currently working on an ODK form in Excel (then converting using the XLS form tool) and having some difficulties with my "relevant" cells. E.g. I would like a certain question to only display for people who have selected [yes for add_contracep AND yes for pam_extra] OR [yes for add_contracep AND yes for pam_sometimes] - I've therefore written the following:

selected(${add_contracep}, 'yes') and selected(${pam_extra}, 'yes') or selected(${add_contracep}, 'yes') and selected(${pam_sometimes}, 'yes')

but I don't think it's working as intended so I'm wondering if I can/need to put some extra brackets around the [add_contracep AND pam_extra] or [add_contracep AND pam_sometimes]. Is this possible/necessary? I would be so grateful if someone could advise me on how to sort out this issue!

Very best wishes,

Laura

2

Laura,

Instead of square brackets, use parentheses. Should work then.

Yaw

ยทยทยท -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Tue, Apr 8, 2014 at 3:11 AM, laura@blueventures.org wrote:

Hi there,

I'm currently working on an ODK form in Excel (then converting using the XLS form tool) and having some difficulties with my "relevant" cells. E.g. I would like a certain question to only display for people who have selected [yes for add_contracep AND yes for pam_extra] OR [yes for add_contracep AND yes for pam_sometimes] - I've therefore written the following:

selected(${add_contracep}, 'yes') and selected(${pam_extra}, 'yes') or selected(${add_contracep}, 'yes') and selected(${pam_sometimes}, 'yes')

but I don't think it's working as intended so I'm wondering if I can/need to put some extra brackets around the [add_contracep AND pam_extra] or [add_contracep AND pam_sometimes]. Is this possible/necessary? I would be so grateful if someone could advise me on how to sort out this issue!

Very best wishes,

Laura

--

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.