Request for assistance - designing and pre screening form

Good day,

(my apologies for the cross posting)

I am using ODK collect on Android and formhub.org to host my forms. I am
designing a pre screening form for our survey.

For a subject to be eligible to take part in the study they should meet all
the inclusion criteria, the inclusion criteria involves scoring above a
certain threshold (cut off score) and also not answering yes to one the the
questions in the pre screening tool.

what is the best way of designing the form? Use a conditional? if using the
conditional for the multiple select options, I am bit clear on how to
handle that, how do I handle the calculation?

See attached sample form.

In the form I would like to add all yes responses for the depression
screening group, anyone scoring 8 and above and not answering yes to ssq11
and meeting the inclusion and criteria should be enrolled.

Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 039

eligibility.xlsx (14.8 KB)

Ronald,

Add up all the counts from the questions to calculate the score. Then
make the questions for the actual study relevant based on that score.

See https://groups.google.com/d/msg/opendatakit/6xvJHi234i8/eeVdv_GYE2oJ
for an example.

Yaw

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

On Sun, Jun 29, 2014 at 3:29 AM, ronald munjoma simbiso@gmail.com wrote:

Good day,

(my apologies for the cross posting)

I am using ODK collect on Android and formhub.org to host my forms. I am
designing a pre screening form for our survey.

For a subject to be eligible to take part in the study they should meet all
the inclusion criteria, the inclusion criteria involves scoring above a
certain threshold (cut off score) and also not answering yes to one the the
questions in the pre screening tool.

what is the best way of designing the form? Use a conditional? if using the
conditional for the multiple select options, I am bit clear on how to handle
that, how do I handle the calculation?

See attached sample form.

In the form I would like to add all yes responses for the depression
screening group, anyone scoring 8 and above and not answering yes to ssq11
and meeting the inclusion and criteria should be enrolled.

Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 039

--

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.

Yaw and Martijn,

Thank you for your assistance. I have tried the proposed solutions but
could not get it to work.

I have attached a section of the form of what I have tried to do.

Before administering the SSQ 14 I would like to evaluate if the client
meets the criteria. I need to replace: "Are you comfortable with us taking
you through the interview?" with something like:

  1. Not selected - NO for the inclusion questions
    or
  2. Selected Yes for the inclusion questions

Then for the SSQ 14, I want to count the number of Yes responses.

Thanks and Regards
Ronald Munjoma

inclusion_exclusion.xls (60 KB)

··· On 29 June 2014 23:16, Martijn van de Rijdt wrote:

Hi Ronald,

One way of doing this is to create a calculated item for each question
that sets the value to 0 if no answer has been given and otherwise the
score according to your algorithm. The overall score will then simply be
the sum() of all these calculated items. While designing the form use notes
to output all the calculated values so you can check that they work
correctly. Be careful with sum() as it will result in NaN if one of the
values is empty.

You could also just create one long formula (without the other calculated
items) for the overall score but it will be harder to troubleshoot if it
doesn't work correctly.

The actual survey questions could be placed in one group that has a
relevant expression: ${overal_score} >= 8

Good luck!

On Sun, Jun 29, 2014 at 4:29 AM, ronald munjoma simbiso@gmail.com wrote:

Good day,

(my apologies for the cross posting)

I am using ODK collect on Android and formhub.org to host my forms. I am
designing a pre screening form for our survey.

For a subject to be eligible to take part in the study they should meet
all the inclusion criteria, the inclusion criteria involves scoring above a
certain threshold (cut off score) and also not answering yes to one the the
questions in the pre screening tool.

what is the best way of designing the form? Use a conditional? if using
the conditional for the multiple select options, I am bit clear on how to
handle that, how do I handle the calculation?

See attached sample form.

In the form I would like to add all yes responses for the depression
screening group, anyone scoring 8 and above and not answering yes to ssq11
and meeting the inclusion and criteria should be enrolled.

Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 039

--
You received this message because you are subscribed to the Google Groups
"formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Did you know that Enketo Smart Paper has now become the #1 tool for data
collection? Don't fall behind. Use it!

Enketo https://enketo.org | LinkedIn
http://www.linkedin.com/company/enketo-llc | GitHub
https://github.com/MartijnR | Twitter https://twitter.com/enketo

--
You received this message because you are subscribed to the Google Groups
"formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309

Hi Ronald,

Please don't cross post to multiple lists.

In order increase the chance that someone will help, you'll need to
break down the problem into single issues and be very specific about
what is not working.

Let's start with counting responses. Build a simple two question form
and see if you can count the number of yes responses there. Try that
first and let us know how that goes (on one list).

If that doesn't work, attach the simple two question form you are
using and describe what doesn't work. The more detail you can provide,
the better.

Yaw

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

On Thu, Aug 21, 2014 at 8:35 AM, ronald munjoma simbiso@gmail.com wrote:

Yaw and Martijn,

Thank you for your assistance. I have tried the proposed solutions but could
not get it to work.

I have attached a section of the form of what I have tried to do.

Before administering the SSQ 14 I would like to evaluate if the client
meets the criteria. I need to replace: "Are you comfortable with us taking
you through the interview?" with something like:

  1. Not selected - NO for the inclusion questions
    or
  2. Selected Yes for the inclusion questions

Then for the SSQ 14, I want to count the number of Yes responses.

Thanks and Regards
Ronald Munjoma

On 29 June 2014 23:16, Martijn van de Rijdt martijn@enketo.org wrote:

Hi Ronald,

One way of doing this is to create a calculated item for each question
that sets the value to 0 if no answer has been given and otherwise the score
according to your algorithm. The overall score will then simply be the sum()
of all these calculated items. While designing the form use notes to output
all the calculated values so you can check that they work correctly. Be
careful with sum() as it will result in NaN if one of the values is empty.

You could also just create one long formula (without the other calculated
items) for the overall score but it will be harder to troubleshoot if it
doesn't work correctly.

The actual survey questions could be placed in one group that has a
relevant expression: ${overal_score} >= 8

Good luck!

On Sun, Jun 29, 2014 at 4:29 AM, ronald munjoma simbiso@gmail.com wrote:

Good day,

(my apologies for the cross posting)

I am using ODK collect on Android and formhub.org to host my forms. I am
designing a pre screening form for our survey.

For a subject to be eligible to take part in the study they should meet
all the inclusion criteria, the inclusion criteria involves scoring above a
certain threshold (cut off score) and also not answering yes to one the the
questions in the pre screening tool.

what is the best way of designing the form? Use a conditional? if using
the conditional for the multiple select options, I am bit clear on how to
handle that, how do I handle the calculation?

See attached sample form.

In the form I would like to add all yes responses for the depression
screening group, anyone scoring 8 and above and not answering yes to ssq11
and meeting the inclusion and criteria should be enrolled.

Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 039

--
You received this message because you are subscribed to the Google Groups
"formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Did you know that Enketo Smart Paper has now become the #1 tool for data
collection? Don't fall behind. Use it!

Enketo | LinkedIn | GitHub | Twitter

--
You received this message because you are subscribed to the Google Groups
"formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309

--

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 Ronald,

Nearly there!

For the ssqscore the formula should be in a 'calculation' column, not in
the relevant column. It should not include 'calculate='. See attached form.

It seems that casting an empty answer to number results in NaN (so the
score is only shown when all questions are answered). I think this is
correct behaviour. In your case you could probably just use ${ssq1} +
${ssq2} + ... etc to avoid this from happening.

Another tip, you could add the 'relevant' condition to the group ssq14_
instead of to all the individual questions.

When you're stuck with these kind of things Yaw's approach to divide the
problem into small pieces is the way to go. This tool is very useful too:
https://enketo.org/formtester especially in combination with the amazing
offline XLSForm convertor Nafundi has created and is linked to on
http://opendatakit.org/use/xlsform/. The formtester allows you to look
behind the scenes at the record in realtime, so you can see exactly what is
happening.

Cheers,
Martijn

inclusion_exclusion.xls (38 KB)

··· On Thu, Aug 21, 2014 at 9:35 AM, ronald munjoma wrote:

Yaw and Martijn,

Thank you for your assistance. I have tried the proposed solutions but
could not get it to work.

I have attached a section of the form of what I have tried to do.

Before administering the SSQ 14 I would like to evaluate if the client
meets the criteria. I need to replace: "Are you comfortable with us taking
you through the interview?" with something like:

  1. Not selected - NO for the inclusion questions
    or
  2. Selected Yes for the inclusion questions

Then for the SSQ 14, I want to count the number of Yes responses.

Thanks and Regards
Ronald Munjoma

On 29 June 2014 23:16, Martijn van de Rijdt martijn@enketo.org wrote:

Hi Ronald,

One way of doing this is to create a calculated item for each question
that sets the value to 0 if no answer has been given and otherwise the
score according to your algorithm. The overall score will then simply be
the sum() of all these calculated items. While designing the form use notes
to output all the calculated values so you can check that they work
correctly. Be careful with sum() as it will result in NaN if one of the
values is empty.

You could also just create one long formula (without the other calculated
items) for the overall score but it will be harder to troubleshoot if it
doesn't work correctly.

The actual survey questions could be placed in one group that has a
relevant expression: ${overal_score} >= 8

Good luck!

On Sun, Jun 29, 2014 at 4:29 AM, ronald munjoma simbiso@gmail.com wrote:

Good day,

(my apologies for the cross posting)

I am using ODK collect on Android and formhub.org to host my forms. I
am designing a pre screening form for our survey.

For a subject to be eligible to take part in the study they should meet
all the inclusion criteria, the inclusion criteria involves scoring above a
certain threshold (cut off score) and also not answering yes to one the the
questions in the pre screening tool.

what is the best way of designing the form? Use a conditional? if using
the conditional for the multiple select options, I am bit clear on how to
handle that, how do I handle the calculation?

See attached sample form.

In the form I would like to add all yes responses for the depression
screening group, anyone scoring 8 and above and not answering yes to ssq11
and meeting the inclusion and criteria should be enrolled.

Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 039

--
You received this message because you are subscribed to the Google
Groups "formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Did you know that Enketo Smart Paper has now become the #1 tool for data
collection? Don't fall behind. Use it!

Enketo https://enketo.org | LinkedIn
http://www.linkedin.com/company/enketo-llc | GitHub
https://github.com/MartijnR | Twitter
https://twitter.com/enketo

--
You received this message because you are subscribed to the Google Groups
"formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309

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

--
Did you know that Enketo Smart Paper has now become the #1 tool for data
collection? Don't fall behind. Use it!

Enketo https://enketo.org | LinkedIn
http://www.linkedin.com/company/enketo-llc | GitHub
https://github.com/MartijnR | Twitter https://twitter.com/enketo

Hi Yaw,

​Thanks for your response.​

Hi Ronald,

Please don't cross post to multiple lists.

​Noted.

In order increase the chance that someone will help, you'll need to
break down the problem into single issues and be very specific about
what is not working.

Let's start with counting responses. Build a simple two question form
and see if you can count the number of yes responses there. Try that
first and let us know how that goes (on one list).

​As per your suggestion I have created a three question form (attached).
Following instructions in this thread:
https://groups.google.com/forum/#!searchin/opendatakit/calculation/opendatakit/R9pwelsmTlY/SwMTEm6_6zkJ

I am failing to display the SSQ 14 score. On enketo I am getting NaN as the
result, on ODK I am getting the note text only?

In my sheet a Yes =1 and No = 0

Thanks and Regards
Ronald Munjoma

··· On 21 August 2014 19:20, Yaw Anokwa wrote:

If that doesn't work, attach the simple two question form you are
using and describe what doesn't work. The more detail you can provide,
the better.

Yaw

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

On Thu, Aug 21, 2014 at 8:35 AM, ronald munjoma simbiso@gmail.com wrote:

Yaw and Martijn,

Thank you for your assistance. I have tried the proposed solutions but
could
not get it to work.

I have attached a section of the form of what I have tried to do.

Before administering the SSQ 14 I would like to evaluate if the client
meets the criteria. I need to replace: "Are you comfortable with us
taking
you through the interview?" with something like:

  1. Not selected - NO for the inclusion questions
    or
  2. Selected Yes for the inclusion questions

Then for the SSQ 14, I want to count the number of Yes responses.

Thanks and Regards
Ronald Munjoma

On 29 June 2014 23:16, Martijn van de Rijdt martijn@enketo.org wrote:

Hi Ronald,

One way of doing this is to create a calculated item for each question
that sets the value to 0 if no answer has been given and otherwise the
score

according to your algorithm. The overall score will then simply be the
sum()

of all these calculated items. While designing the form use notes to
output

all the calculated values so you can check that they work correctly. Be
careful with sum() as it will result in NaN if one of the values is
empty.

You could also just create one long formula (without the other
calculated

items) for the overall score but it will be harder to troubleshoot if it
doesn't work correctly.

The actual survey questions could be placed in one group that has a
relevant expression: ${overal_score} >= 8

Good luck!

On Sun, Jun 29, 2014 at 4:29 AM, ronald munjoma simbiso@gmail.com wrote:

Good day,

(my apologies for the cross posting)

I am using ODK collect on Android and formhub.org to host my forms. I
am

designing a pre screening form for our survey.

For a subject to be eligible to take part in the study they should meet
all the inclusion criteria, the inclusion criteria involves scoring
above a

certain threshold (cut off score) and also not answering yes to one
the the

questions in the pre screening tool.

what is the best way of designing the form? Use a conditional? if using
the conditional for the multiple select options, I am bit clear on how
to

handle that, how do I handle the calculation?

See attached sample form.

In the form I would like to add all yes responses for the depression
screening group, anyone scoring 8 and above and not answering yes to
ssq11

and meeting the inclusion and criteria should be enrolled.

Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 039

--
You received this message because you are subscribed to the Google
Groups

"formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an

email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Did you know that Enketo Smart Paper has now become the #1 tool for data
collection? Don't fall behind. Use it!

Enketo | LinkedIn | GitHub | Twitter

--
You received this message because you are subscribed to the Google
Groups

"formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an

email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309

--

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.

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309

Hi Martijn,

Hi Ronald,

Nearly there!

For the ssqscore the formula should be in a 'calculation' column, not in
the relevant column. It should not include 'calculate='. See attached form.

​Thanks for the pointers, I realised the mistake earlier and changed but
still could note get it work, may be it was defned as 'calculate' type.​

It seems that casting an empty answer to number results in NaN (so the
score is only shown when all questions are answered). I think this is
correct behaviour. In your case you could probably just use ${ssq1} +
${ssq2} + ... etc to avoid this from happening.

Another tip, you could add the 'relevant' condition to the group ssq14_
instead of to all the individual questions.

​In thefinal form I will do it the suggested way. ​

When you're stuck with these kind of things Yaw's approach to divide the
problem into small pieces is the way to go.

​I have started using this approach. I am now working on the selected and
not selected ​issue of the first part, if I get stuck I will post to the
list

This tool is very useful too: https://enketo.org/formtester

​Thanks for the pointer to the formtester​

especially in combination with the amazing offline XLSForm convertor
Nafundi has created and is linked to on
http://opendatakit.org/use/xlsform/. The formtester allows you to look
behind the scenes at the record in realtime, so you can see exactly what is
happening.

​Thanks and Regards
Ronald Munjoma​

··· On 22 August 2014 17:35, Martijn van de Rijdt wrote:

Cheers,
Martijn

On Thu, Aug 21, 2014 at 9:35 AM, ronald munjoma simbiso@gmail.com wrote:

Yaw and Martijn,

Thank you for your assistance. I have tried the proposed solutions but
could not get it to work.

I have attached a section of the form of what I have tried to do.

Before administering the SSQ 14 I would like to evaluate if the client
meets the criteria. I need to replace: "Are you comfortable with us taking
you through the interview?" with something like:

  1. Not selected - NO for the inclusion questions
    or
  2. Selected Yes for the inclusion questions

Then for the SSQ 14, I want to count the number of Yes responses.

Thanks and Regards
Ronald Munjoma

On 29 June 2014 23:16, Martijn van de Rijdt martijn@enketo.org wrote:

Hi Ronald,

One way of doing this is to create a calculated item for each question
that sets the value to 0 if no answer has been given and otherwise the
score according to your algorithm. The overall score will then simply be
the sum() of all these calculated items. While designing the form use notes
to output all the calculated values so you can check that they work
correctly. Be careful with sum() as it will result in NaN if one of the
values is empty.

You could also just create one long formula (without the other
calculated items) for the overall score but it will be harder to
troubleshoot if it doesn't work correctly.

The actual survey questions could be placed in one group that has a
relevant expression: ${overal_score} >= 8

Good luck!

On Sun, Jun 29, 2014 at 4:29 AM, ronald munjoma simbiso@gmail.com wrote:

Good day,

(my apologies for the cross posting)

I am using ODK collect on Android and formhub.org to host my forms. I
am designing a pre screening form for our survey.

For a subject to be eligible to take part in the study they should meet
all the inclusion criteria, the inclusion criteria involves scoring above a
certain threshold (cut off score) and also not answering yes to one the the
questions in the pre screening tool.

what is the best way of designing the form? Use a conditional? if using
the conditional for the multiple select options, I am bit clear on how to
handle that, how do I handle the calculation?

See attached sample form.

In the form I would like to add all yes responses for the depression
screening group, anyone scoring 8 and above and not answering yes to ssq11
and meeting the inclusion and criteria should be enrolled.

Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 039

--
You received this message because you are subscribed to the Google
Groups "formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Did you know that Enketo Smart Paper has now become the #1 tool for
data collection? Don't fall behind. Use it!

Enketo https://enketo.org | LinkedIn
http://www.linkedin.com/company/enketo-llc | GitHub
https://github.com/MartijnR | Twitter
https://twitter.com/enketo

--
You received this message because you are subscribed to the Google
Groups "formhub-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to formhub-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309

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

--
Did you know that Enketo Smart Paper has now become the #1 tool for data
collection? Don't fall behind. Use it!

Enketo https://enketo.org | LinkedIn
http://www.linkedin.com/company/enketo-llc | GitHub
https://github.com/MartijnR | Twitter https://twitter.com/enketo

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

--
Best and Regards
Ronald Munjoma
+263 775 625 283, +263 776 444 309