Skipping a Question when It's Left Blank

Hi ODK Community,

I am working on my first ever XLS form and it's been going OK so far with the support material I've found.

I am designing a set of nested questions where if person enters their phone number, they will be asked if that number is a home or cell phone. But if they leave the phone number blank, the next questions will be skipped.

I know how to use the "relevant" column when the question is multiple choice but I'm not sure what to do when it's a text question. Help please.

Thank you!

2 Likes

It's the same. Test for empty questions with ${var} = ''.

Yaw

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

On Wed, Aug 26, 2015 at 4:26 PM, iknow2project@gmail.com wrote:

Hi ODK Community,

I am working on my first ever XLS form and it's been going OK so far with the support material I've found.

I am designing a set of nested questions where if person enters their phone number, they will be asked if that number is a home or cell phone. But if they leave the phone number blank, the next questions will be skipped.

I know how to use the "relevant" column when the question is multiple choice but I'm not sure what to do when it's a text question. Help please.

Thank you!

--

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.

1 Like

Thanks Yaw. I thought that too but then realized I am testing for NOT empty question. Is there a "not equal" sign (for example: ~= or !=) I can use for the command?

Thanks again!

ยทยทยท On Wednesday, August 26, 2015 at 4:30:04 PM UTC-4, Yaw Anokwa wrote: > It's the same. Test for empty questions with ${var} = ''. > > Yaw > -- > Need ODK services? http://nafundi.com provides form design, server > setup, professional support, and software development for ODK. > > On Wed, Aug 26, 2015 at 4:26 PM, wrote: > > Hi ODK Community, > > > > I am working on my first ever XLS form and it's been going OK so far with the support material I've found. > > > > I am designing a set of nested questions where if person enters their phone number, they will be asked if that number is a home or cell phone. But if they leave the phone number blank, the next questions will be skipped. > > > > I know how to use the "relevant" column when the question is multiple choice but I'm not sure what to do when it's a text question. Help please. > > > > Thank you! > > > > -- > > -- > > 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.

!= is the not equal to operator.

http://xlsform.org/ and
https://opendatakit.org/help/form-design/binding/ has the answer to
this and many of your previous questions.

Yaw

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

On Wed, Aug 26, 2015 at 4:52 PM, iknow2project@gmail.com wrote:

Thanks Yaw. I thought that too but then realized I am testing for NOT empty question. Is there a "not equal" sign (for example: ~= or !=) I can use for the command?

Thanks again!

On Wednesday, August 26, 2015 at 4:30:04 PM UTC-4, Yaw Anokwa wrote:

It's the same. Test for empty questions with ${var} = ''.

Yaw

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

On Wed, Aug 26, 2015 at 4:26 PM, iknow2project@gmail.com wrote:

Hi ODK Community,

I am working on my first ever XLS form and it's been going OK so far with the support material I've found.

I am designing a set of nested questions where if person enters their phone number, they will be asked if that number is a home or cell phone. But if they leave the phone number blank, the next questions will be skipped.

I know how to use the "relevant" column when the question is multiple choice but I'm not sure what to do when it's a text question. Help please.

Thank you!

--

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.