Hi all
I'm currently working on a formhub survey and I'm currently doing piloting. I find it hard to control the forms that are submitted by the interviewers in the evening if there were some questions skipped. This is because I'm using relevant commands, that non-relevant questions are skipped. Is there any possibility within the formhub syntax to auto fill an automatically skipped question with a code like 999?
A simple example, regarding the relevant question "Please specify other": Is there any possibility if "Other" was NOT selected in previous question to fill in 999 as Answer for other?
IN this example it may seem unnecessary, but if applied to other cases where questions are skipped it makes sense.
Like that I would have a much easier way to check the forms were fully completed.
For those who suggest the required command: I don't want to use this command, as the risk is too high to get the survey stuck at one or another point in my opinion.
Thank you very much for your help!
PS:sorry if this is a too simple question, I searched quite a bit and didn't find a solution.I'm just a newbie...
Hi?
I think there is a way. This is theory and my creative thinking based on
what MS Excel can do. Look for how to do the following (If I succeed in it,
I will tell you exactly how to do it. At the moment its just an idea about
how you might do it.)
- The first relevant command will say "If response is not 'code' for
Other; Specify,
- Then this cell ${this cell}= -999
What that command should do (In theory) in the default-value field; is to
only prefill the cell with "-999" only if the previous response is not
Other; Specify.
Good luck.
Louis...
ยทยทยท
On Wed, Oct 7, 2015 at 1:09 PM, wrote:
Hi all
I'm currently working on a formhub survey and I'm currently doing
piloting. I find it hard to control the forms that are submitted by the
interviewers in the evening if there were some questions skipped. This is
because I'm using relevant commands, that non-relevant questions are
skipped. Is there any possibility within the formhub syntax to auto fill an
automatically skipped question with a code like 999?
A simple example, regarding the relevant question "Please specify other":
Is there any possibility if "Other" was NOT selected in previous question
to fill in 999 as Answer for other?
IN this example it may seem unnecessary, but if applied to other cases
where questions are skipped it makes sense.
Like that I would have a much easier way to check the forms were fully
completed.
For those who suggest the required command: I don't want to use this
command, as the risk is too high to get the survey stuck at one or another
point in my opinion.
Thank you very much for your help!
PS:sorry if this is a too simple question, I searched quite a bit and
didn't find a solution.I'm just a newbie...
--
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.
Thank you very much for your response.
I think this might work, but i actually don't know how i should implement
it. Can I put just the whole command in the relevant column?
Example:
I have a question (named is011) with 3 possible answers: 1, 2, 3, which is
only displayed when on the previous question (is010) choices number 1,2,3
or 4 are selected.
The required command to only display the question is like this:
(selected(${is010},'1'))or(selected(${is010},'2'))or(selected(${is010},'3'))or(selected(${is010},'4'))
In my opinion, to auto fill the required command would be:
(if(not(selected(${is011},'1'))or(selected(${is011},'2'))or(selected(${is011},'3')))then(${is011}=-999))
But how can I combine both required commands to one, so i still have the
auto fill function aswell as only displaying the question when relevant?
can I just put 'and' without ' ' in between the two commands? As like this:
((selected(${is010},'1'))or(selected(${is010},'2'))or(selected(${is010},'3'))or(selected(${is010},'4'))and(if(not(selected(${is011},'1'))or(selected(${is011},'2'))or(selected(${is011},'3')))then(${is011}=-999)))
I would be glad if you could send me a feedback if I got you right.
Regards
Pascal