I am trying to design a form with branching based on an integer value.
Specifically, I have a question 'rand' that takes an integer value. If
that integer is between two values, I want to go to Q5a. If that integer
is between two different values, I want to go to Q5b. And so on.
I know you can combine conditions using "and", "or" and so forth, but I
can't seem to get it to actually work. I've tried all of the following:
((data('rand')>=1) and (data('rand')<=30))
(data('rand')>=1) and (data('rand')<=30) data('rand')>=1 and
data('rand')<=30
but all of them return the same error in xlsx converter. I get "Error:
missing ) in parenthetical interpretting formula: data('rand')=1 or
data('rand')=30 on sheet: survey row: 4 column: condition" no matter which
version I use.
I am sure this is a result of my noviceness, but I am hoping someone can
point out the error I'm making. Thanks!
I am trying to design a form with branching based on an integer value.
Specifically, I have a question 'rand' that takes an integer value. If
that integer is between two values, I want to go to Q5a. If that
integer is between two different values, I want to go to Q5b. And so
on.
I know you can combine conditions using "and", "or" and so forth, but I
can't seem to get it to actually work. I've tried all of the following:
((data('rand')>=1) and (data('rand')<=30))
(data('rand')>=1) and (data('rand')<=30) data('rand')>=1 and
data('rand')<=30
but all of them return the same error in xlsx converter. I get "Error:
missing ) in parenthetical interpretting formula: data('rand')=1 or
data('rand')=30 on sheet: survey row: 4 column: condition" no matter which
version I use.
I am sure this is a result of my noviceness, but I am hoping someone can
point out the error I'm making. Thanks!