Calculation with skipping questions - Kobo Collect app

[marion.b...@free.fr]

Hi everyone !

I want to sum answers and then apply a condition to this sum. However, as I am using skipping logic, some values might not be answered. Here is my qquestionnaire :

(Q1)"Do you have A or B ?" (multiple choice : A / B / None)

(Q2)If A selected : "How much do you get from A ?"

(Q3)If B selected : "How much do you get from B ?"

(Q4)Calculate Q2+Q3 

(Q5)"What is your income?" (Validation criteria : check that Q5 > Q4)

This calculation works fine as long as A and B are selected. However, when only A is selected for example, the validation criteria doesn't work.

To solve that, I entered default values of 0. It is now OK for online submissions, but on the Kobo collect app it is still not working...

Do you know how I can solve this issue and set default values on the app as well ? 

Thank you very much for your help !

Marion

[Jonathan Munene]

Hi,

You will need to introduce an if condition that returns value of 0 if either A or B is not selected.

Please have a look at this document;

https://docs.google.com/document/d/1YspT8Ev-kZv1ld_Pu6ZT5xeLg-c1is67ToTFU81Tf8I/edit?usp=sharing

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

--

Regards,

Jonathan Munene

+254 714 345 760

https://muneneg.github.io/resume/

[Onyango Kevin]

Hope the Shared Docs has helped you get out of the issue.

Regards,

Onyango Kevin.

[marion.b...@free.fr]

Yes this is perfect, thank you so much !
Have a nice day :)

----- Mail original -----
De: "Onyango Kevin" <onyk...@gmail.com>
À: kobo-...@googlegroups.com
Envoyé: Mardi 7 Août 2018 11:13:28
Objet: Re: [KoBo Users] Calculation with skipping questions - Kobo Collect app

Hope the Shared Docs has helped you get out of the issue.




On Tue, Aug 7, 2018 at 11:02 AM, Jonathan Munene < munene...@gmail.com > wrote:




Hi,



You will need to introduce an if condition that returns value of 0 if either A or B is not selected.



Please have a look at this document;
https://docs.google.com/document/d/1YspT8Ev-kZv1ld_Pu6ZT5xeLg-c1is67ToTFU81Tf8I/edit?usp=sharing






On Tue, Aug 7, 2018 at 10:28 AM, < marion.b...@free.fr > wrote:



Hi everyone !


I want to sum answers and then apply a condition to this sum. However, as I am using skipping logic, some values might not be answered. Here is my qquestionnaire :


(Q1)"Do you have A or B ?" (multiple choice : A / B / None)
(Q2)If A selected : "How much do you get from A ?"

(Q3)If B selected : "How much do you get from B ?"
(Q4)Calculate Q2+Q3
(Q5)"What is your income?" (Validation criteria : check that Q5 > Q4)


This calculation works fine as long as A and B are selected. However, when only A is selected for example, the validation criteria doesn't work.
To solve that, I entered default values of 0. It is now OK for online submissions, but on the Kobo collect app it is still not working...


Do you know how I can solve this issue and set default values on the app as well ?


Thank you very much for your help !


Marion



--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .



--





Regards,
Jonathan Munene
+254 714 345 760
https://muneneg.github.io/resume/




--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .




--




Regards,

Onyango Kevin.

--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com .

[ntangibingura bruce vaillant]

Hello,

I actually can't access my Kobotoolbox. 

And when i try to reset it. It doesn't work. 

What can I do? 

[Jonathan Munene]

Hi Marion,

Glad it worked. Here is the same link on my page where I periodically update on form authoring, data management and mining once in while, you can keep checking;

https://muneneg.github.io/articles/2016-07/xlsform-remove-NaN

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .



--





Regards,
Jonathan Munene
+254 714 345 760
https://muneneg.github.io/resume/




--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .

--




Regards,


Onyango Kevin.

--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .

--

You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.
Visit this group at https://groups.google.com/group/kobo-users.
For more options, visit https://groups.google.com/d/optout.

[marion.b...@free.fr]

Thank you, that seems a very helpful page !
Another question if I may : is there a tool to edit automatically the questionnaire in a readable way for my colleagues ? For instance a simple list of the questions, with the corresponding possible answers and conditional checks..

Best regards,

Marion

----- Mail original -----
De: "Jonathan Munene" <munene...@gmail.com>
À: kobo-...@googlegroups.com
Envoyé: Mardi 7 Août 2018 18:22:24

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .



--





Regards,
Jonathan Munene
+254 714 345 760
https://muneneg.github.io/resume/




--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .




--




Regards,


Onyango Kevin.

--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .

--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .



--





Regards,
Jonathan Munene
+254 714 345 760
https://muneneg.github.io/resume/


--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com .

[Jonathan Munene]

Hi Marion,

Someone in the ODK forum had created an app for that, not sure how far it is but, you can try it;

https://forum.opendatakit.org/t/ppp-an-app-for-creating-elegant-documents-out-of-xlsforms/13950

Let me know how it goes.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .



--





Regards,
Jonathan Munene
+254 714 345 760
https://muneneg.github.io/resume/




--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .




--




Regards,


Onyango Kevin.

--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .

--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .



--





Regards,
Jonathan Munene
+254 714 345 760
https://muneneg.github.io/resume/


--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com .

To post to this group, send email to kobo-...@googlegroups.com .
Visit this group at https://groups.google.com/group/kobo-users .
For more options, visit https://groups.google.com/d/optout .

--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+unsubscribe@googlegroups.com.

To post to this group, send email to kobo-...@googlegroups.com.
Visit this group at https://groups.google.com/group/kobo-users.
For more options, visit https://groups.google.com/d/optout.

[Blogger Arfan]

Can you show me a screenshot ?