Single select constraint based on previous selection

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1 is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

··· On Mon, May 2, 2016 at 1:36 AM, Louis Omoya wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1 is
no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Thanks

··· On 4 May 2016 22:56, "Mitch Sundt" wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1 is
no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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? I added or 'syntax'. When i choose Yes for HMIS- 032- Availability it
only accepts a No for HMIS032-Use.

The bigger issue i want to resolve is;

A variable has to be available for it to be in use. Otherwise what is not
available cannot be presently in use.

Please find attached my trail workbook.

Thanks in advance for your assistance.

Louis...

SINGLE_SELECT_CONSTRAINT.xlsx (10.7 KB)

··· On 4 May 2016 22:56, "Mitch Sundt" wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1 is
no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

Hello Mitch,

am having a problem with combining "(selected(${Q1},'1')
and (selected(${Q2},'1')" with "(selected(${Q3},'1') or
(selected(${Q3},'2')" in the relevant column and having them skip through
the same cell of another question in xls build.

Their combination nulls the entire question and renders the skip invalid.
is it possible to have the "or" in the constraint column of the same
question where you have the "and" in the relevant column?

your advice and support will be highly appreciated.

··· On Wednesday, May 4, 2016 at 8:56:00 PM UTC+1, Mitch Sundt wrote: > > add an (....) or selected(${Q1},'1') to the expression. > > You can use: > > ... and ... > ... or ... > not( ... ) > > and parentheses for grouping to construct any test condition you need. > > https://opendatakit.org/help/form-design/binding/ > > On Mon, May 2, 2016 at 1:36 AM, Louis Omoya <louis...@gmail.com > wrote: > >> Hi? >> I am looking for solution where Q1 is yes/no. Q2 is also yes/no. >> However Q2 cannot be a yes when Q1 is no. >> >> I looked up some conversations on the odk group and found/used >> >> (selected(${Q1},'0'and ${Q2}!=1) >> >> However this constraint only works when Q1 is No. What i want is if Q1 is >> no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no. >> >> Any assistance is highly appreciated >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@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...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >

Use a relevant condition (column) to prevent a question from being asked.
Use a constraint condition (column) to restrict the answers to the question.

You wrote this constraint:

selected(${hmis032_availability},'0') and ${hmis032_use}!='1' or
selected(${hmis032_availability},'1') and ${hmis032_use}='1'

Perhaps you really want a 'relevant' column with this constraint:

selected(${hmis032_availability},'1')

This would suppress this question (and leave it blank) when
${hmis032_availability} is No.

··· On Mon, May 9, 2016 at 8:05 AM, Louis Omoya wrote:

Hi? I added or 'syntax'. When i choose Yes for HMIS- 032- Availability it
only accepts a No for HMIS032-Use.

The bigger issue i want to resolve is;

A variable has to be available for it to be in use. Otherwise what is not
available cannot be presently in use.

Please find attached my trail workbook.

Thanks in advance for your assistance.

Louis...
On 4 May 2016 22:56, "Mitch Sundt" mitchellsundt@gmail.com wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1
is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Both sections are to be asked.
The issue is to prevent a situation where something which is not available
showing up as being used.

··· On 9 May 2016 20:23, "Mitch Sundt" wrote:

Use a relevant condition (column) to prevent a question from being asked.
Use a constraint condition (column) to restrict the answers to the
question.

You wrote this constraint:

selected(${hmis032_availability},'0') and ${hmis032_use}!='1' or
selected(${hmis032_availability},'1') and ${hmis032_use}='1'

Perhaps you really want a 'relevant' column with this constraint:

selected(${hmis032_availability},'1')

This would suppress this question (and leave it blank) when
${hmis032_availability} is No.

On Mon, May 9, 2016 at 8:05 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi? I added or 'syntax'. When i choose Yes for HMIS- 032- Availability it
only accepts a No for HMIS032-Use.

The bigger issue i want to resolve is;

A variable has to be available for it to be in use. Otherwise what is not
available cannot be presently in use.

Please find attached my trail workbook.

Thanks in advance for your assistance.

Louis...
On 4 May 2016 22:56, "Mitch Sundt" mitchellsundt@gmail.com wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1
is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

Yes. They are independent of each other.

Note that the formulas you pasted do not have matching parentheses and are
not properly grouped.

··· On Wed, Aug 17, 2016 at 8:45 AM, Chinedu Arinze wrote:

Hello Mitch,

am having a problem with combining "(selected(${Q1},'1')
and (selected(${Q2},'1')" with "(selected(${Q3},'1') or
(selected(${Q3},'2')" in the relevant column and having them skip through
the same cell of another question in xls build.

Their combination nulls the entire question and renders the skip invalid.
is it possible to have the "or" in the constraint column of the same
question where you have the "and" in the relevant column?

your advice and support will be highly appreciated.

On Wednesday, May 4, 2016 at 8:56:00 PM UTC+1, Mitch Sundt wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louis...@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1
is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

I had ignored the use of relevant in this situation.

Let me give it a try.

··· On 9 May 2016 20:37, "Louis Omoya" wrote:

Both sections are to be asked.
The issue is to prevent a situation where something which is not available
showing up as being used.
On 9 May 2016 20:23, "Mitch Sundt" mitchellsundt@gmail.com wrote:

Use a relevant condition (column) to prevent a question from being asked.
Use a constraint condition (column) to restrict the answers to the
question.

You wrote this constraint:

selected(${hmis032_availability},'0') and ${hmis032_use}!='1' or
selected(${hmis032_availability},'1') and ${hmis032_use}='1'

Perhaps you really want a 'relevant' column with this constraint:

selected(${hmis032_availability},'1')

This would suppress this question (and leave it blank) when
${hmis032_availability} is No.

On Mon, May 9, 2016 at 8:05 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi? I added or 'syntax'. When i choose Yes for HMIS- 032- Availability
it only accepts a No for HMIS032-Use.

The bigger issue i want to resolve is;

A variable has to be available for it to be in use. Otherwise what is
not available cannot be presently in use.

Please find attached my trail workbook.

Thanks in advance for your assistance.

Louis...
On 4 May 2016 22:56, "Mitch Sundt" mitchellsundt@gmail.com wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1
is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

Dear Louis,
I myself prefer using choice_filter. Then Q2 only shows Yes when Q1 is Yes, and show No when Q1 is No.
Plz see attached file

SINGLE_SELECT_CONSTRAINT_td.xlsx (9.98 KB)

very many thanks Mitch! I appreciate.

Best Regards,
Chinedu Arinze.
Data Manager II
Ebola Emergency Operations Center|EEOC.
+2348032745375.

··· On 17 August 2016 at 18:37, Mitch Sundt wrote:

Yes. They are independent of each other.

Note that the formulas you pasted do not have matching parentheses and are
not properly grouped.

On Wed, Aug 17, 2016 at 8:45 AM, Chinedu Arinze chinedar@gmail.com wrote:

Hello Mitch,

am having a problem with combining "(selected(${Q1},'1')
and (selected(${Q2},'1')" with "(selected(${Q3},'1') or
(selected(${Q3},'2')" in the relevant column and having them skip through
the same cell of another question in xls build.

Their combination nulls the entire question and renders the skip invalid.
is it possible to have the "or" in the constraint column of the same
question where you have the "and" in the relevant column?

your advice and support will be highly appreciated.

On Wednesday, May 4, 2016 at 8:56:00 PM UTC+1, Mitch Sundt wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louis...@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if Q1
is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/opendatakit/UDJtzzuk8FU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Then I would write the constraint as:

selected(${hmis032_availability},'1') or selected(${hmis032_use},'0')

I.e., you need availability to be a Yes. If it isn't, you need usage to be
No.

··· On Mon, May 9, 2016 at 10:40 AM, Louis Omoya wrote:

I had ignored the use of relevant in this situation.

Let me give it a try.
On 9 May 2016 20:37, "Louis Omoya" louisomoya@gmail.com wrote:

Both sections are to be asked.
The issue is to prevent a situation where something which is not
available showing up as being used.
On 9 May 2016 20:23, "Mitch Sundt" mitchellsundt@gmail.com wrote:

Use a relevant condition (column) to prevent a question from being asked.
Use a constraint condition (column) to restrict the answers to the
question.

You wrote this constraint:

selected(${hmis032_availability},'0') and ${hmis032_use}!='1' or
selected(${hmis032_availability},'1') and ${hmis032_use}='1'

Perhaps you really want a 'relevant' column with this constraint:

selected(${hmis032_availability},'1')

This would suppress this question (and leave it blank) when
${hmis032_availability} is No.

On Mon, May 9, 2016 at 8:05 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi? I added or 'syntax'. When i choose Yes for HMIS- 032- Availability
it only accepts a No for HMIS032-Use.

The bigger issue i want to resolve is;

A variable has to be available for it to be in use. Otherwise what is
not available cannot be presently in use.

Please find attached my trail workbook.

Thanks in advance for your assistance.

Louis...
On 4 May 2016 22:56, "Mitch Sundt" mitchellsundt@gmail.com wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if
Q1 is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--
--
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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

I tried the above. When i make selection it show this message;

"Xpath evaluation: cannot handle function 'selected' requires 2 arguements.
Only 1 provided."

··· On 9 May 2016 20:44, "Mitch Sundt" wrote:

Then I would write the constraint as:

selected(${hmis032_availability},'1') or selected(${hmis032_use},'0')

I.e., you need availability to be a Yes. If it isn't, you need usage to be
No.

On Mon, May 9, 2016 at 10:40 AM, Louis Omoya louisomoya@gmail.com wrote:

I had ignored the use of relevant in this situation.

Let me give it a try.
On 9 May 2016 20:37, "Louis Omoya" louisomoya@gmail.com wrote:

Both sections are to be asked.
The issue is to prevent a situation where something which is not
available showing up as being used.
On 9 May 2016 20:23, "Mitch Sundt" mitchellsundt@gmail.com wrote:

Use a relevant condition (column) to prevent a question from being
asked.
Use a constraint condition (column) to restrict the answers to the
question.

You wrote this constraint:

selected(${hmis032_availability},'0') and ${hmis032_use}!='1' or
selected(${hmis032_availability},'1') and ${hmis032_use}='1'

Perhaps you really want a 'relevant' column with this constraint:

selected(${hmis032_availability},'1')

This would suppress this question (and leave it blank) when
${hmis032_availability} is No.

On Mon, May 9, 2016 at 8:05 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi? I added or 'syntax'. When i choose Yes for HMIS- 032- Availability
it only accepts a No for HMIS032-Use.

The bigger issue i want to resolve is;

A variable has to be available for it to be in use. Otherwise what is
not available cannot be presently in use.

Please find attached my trail workbook.

Thanks in advance for your assistance.

Louis...
On 4 May 2016 22:56, "Mitch Sundt" mitchellsundt@gmail.com wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if
Q1 is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--
--
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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

You introduced a typo.

··· On Tue, May 10, 2016 at 12:10 AM, Louis Omoya wrote:

I tried the above. When i make selection it show this message;

"Xpath evaluation: cannot handle function 'selected' requires 2
arguements. Only 1 provided."
On 9 May 2016 20:44, "Mitch Sundt" mitchellsundt@gmail.com wrote:

Then I would write the constraint as:

selected(${hmis032_availability},'1') or selected(${hmis032_use},'0')

I.e., you need availability to be a Yes. If it isn't, you need usage to
be No.

On Mon, May 9, 2016 at 10:40 AM, Louis Omoya louisomoya@gmail.com wrote:

I had ignored the use of relevant in this situation.

Let me give it a try.
On 9 May 2016 20:37, "Louis Omoya" louisomoya@gmail.com wrote:

Both sections are to be asked.
The issue is to prevent a situation where something which is not
available showing up as being used.
On 9 May 2016 20:23, "Mitch Sundt" mitchellsundt@gmail.com wrote:

Use a relevant condition (column) to prevent a question from being
asked.
Use a constraint condition (column) to restrict the answers to the
question.

You wrote this constraint:

selected(${hmis032_availability},'0') and ${hmis032_use}!='1' or
selected(${hmis032_availability},'1') and ${hmis032_use}='1'

Perhaps you really want a 'relevant' column with this constraint:

selected(${hmis032_availability},'1')

This would suppress this question (and leave it blank) when
${hmis032_availability} is No.

On Mon, May 9, 2016 at 8:05 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi? I added or 'syntax'. When i choose Yes for HMIS- 032-
Availability it only accepts a No for HMIS032-Use.

The bigger issue i want to resolve is;

A variable has to be available for it to be in use. Otherwise what is
not available cannot be presently in use.

Please find attached my trail workbook.

Thanks in advance for your assistance.

Louis...
On 4 May 2016 22:56, "Mitch Sundt" mitchellsundt@gmail.com wrote:

add an (....) or selected(${Q1},'1') to the expression.

You can use:

... and ...
... or ...
not( ... )

and parentheses for grouping to construct any test condition you
need.

https://opendatakit.org/help/form-design/binding/

On Mon, May 2, 2016 at 1:36 AM, Louis Omoya louisomoya@gmail.com wrote:

Hi?
I am looking for solution where Q1 is yes/no. Q2 is also yes/no.
However Q2 cannot be a yes when Q1 is no.

I looked up some conversations on the odk group and found/used

(selected(${Q1},'0'and ${Q2}!=1)

However this constraint only works when Q1 is No. What i want is if
Q1 is no, Q2 must be no. If Q1 is yes,Q2 can be either yes or no.

Any assistance is highly appreciated

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--
--
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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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.

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com