Plausibility check: sum

[alice123]

Hello, I have a question about how to introduce a plausibility check for my questionnaire. I have three questions related to workers in a plantation. Q006 how many workers work in the plantation? (Integer for the number of workers); Q006a how many female workers work in the plantation? (integer); Q006b how many male workers work in the plantation? (Integer). I want to create a condition where if the sum of Q006a and Q006b is greater than the amount of workers the respondent indicates in Q006 they will receive a notification say “error”. How can I do it? Thanks in advance!

[mictr]

Lets assume that Q006 is v_6, Q006a is v_7 and Q006b is v_8. All questions must be on the same page, if the questions are all on their own page, you can only show the error message on the last page of the three pages.
If the questions are on different pages, go to the last page of the group, else go to the page where all three questions are.

In the left menu should be something like plausibility checks (4th from the top). Go there, click on the grey +Plausicheck button at the top, give it a meaningful name and click on next. Leave the top settings as they are (or modify if you need to), and in the lower definition block choose one variable (no matter which one, we will overwrite in the next step) and click save. Then click pro editor above the title and then paste the following text in the plausibility check meta code editor:

if (v_7 + v_8 > v6 )

print "The sum of female workers (your entry: #v_7#) and male workers (your entry: #v_8#) is bigger than the total number of workers (your entry: #v_6#)";

NOT TESTED – but should work 🙂

[alice123]

It works! Thanks a lot!
Do you also know if there is a way to translate the questionnaire fast? By now it’s in English and I need to translate it in French, I know already how the transaction should look like but I wanted to avoid changing every question by hand. Is there a method where I can maybe download the code and modify it in excel or something like this and then re upload it in unipark? Thanks! 🙂

[mictr]

This option does indeed exist and it works more or less as you described it.

Go to Questionnaire Editor > Language Editor > Export/Import. Default Export format should xlsx, so thats what you want. Reference language should be automatically the language that existed first (english in your case) and then set Other Language to the language you’ve created. Leave the other settings as they are and click export.

Translate the excel file (from one column in the other column), save the file and then again go to Questionnaire Editor > Language Editor > Export/Import, but this time import at the top. Specify the language which should be updated with the excel data, select the excel file and upload the file.

[alice123]

Thanks! I have one more question: can I also export the project and modify it on excel or so, if I want to add more questions? Like how you would do for SurveyCTO that you can code the questionnaire in excel first. Thanks again!

[mictr]

i cannot answer this question with one hundred percent certainty. If this feature exists, i haven’t seen or read about it. There is an export option project when you use the normal export function, but the description says Please note: The XML file can not be used for external editing or for documentation purposes. I.e. you can not open and edit it. Its meant to be used if you want/have to move to another unipark server installation.

[alice123]

Okay that is also what I thought. Thank you a lot for taking the time to read all of my questions! 🙂

[Author]

Posts