Hey Guys!
I wanna ask for your help!
I have an array of text which can only accept numbers in the text field.
I want to validate each subquestions with this logic:
in each row the number given in the firs column should be larger than in the second column and the second should be larger than the number in the third column.
Can you help me how to do this?
Thx!
Tom
Assuming the question is mandatory and given something like the following:
- Question code: Q1
- Y-scale codes: Y001, Y002, Y003
- X-scale codes: X001, X002, X003...
You could insert something like this for the "Question validation equation":
Code:
Q4_Y001_X001 > Q4_Y001_X002
AND
Q4_Y001_X002 > Q4_Y001_X003
AND
Q4_Y002_X001 > Q4_Y002_X002
AND
Q4_Y002_X002 > Q4_Y002_X003
AND
Q4_Y003_X001 > Q4_Y003_X002
AND
Q4_Y003_X002 > Q4_Y003_X003
AND
...
Cheers,
Tony Partner Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.