Table-validation

Hello
i have 2 rows dig and num.

rowcode dig num
1 11 69
2 12 36
3 13 52
4 14 33

I want to have a validation in my designer such that
Q1 is whats your dig number? if you say 11 then
Q2. is whats your num number? if you say 69 then you proceed, if you say anything outside 69you get an error.
Which command can i use to implement this kindly?

Perhaps ask just one question: “What is your N?” and expect the user to enter 1169, 1236, … Then validate the value is contained in the lookup-table LT.

rowcode exists
1169 1
1236 1
1352 1
1433 1

LT[(int)self].exists==1

1 Like

Hey sergiy, Let me put my question in a better way. I have 2 columns that I want to use. one column is random1 with values 1,2,3,4 and the other column is random2 with values 23,24,25,26. I want the RA to key in value to ONLY question on Random 1, such that if they key in

1 then there is a static text that says "you have keyed in %random1=1% and therefore the value for %random2% is 23.
OR if they key in
2 then there is a static text that says "you have keyed in %random1=2% and therefore the value for %random2% is 24.

I appreciate in advance

For example, introduce a calculated variable random2 defined as

new int[]{9999,23,24,25,26}[(int)random1)

dear sergiy,
i am getting a syntax error. can i share my questionnaire with you?

Hello, please post the exact expression you’ve typed and describe the exact types of all the questions/variables involved, as well as the kind of syntax error that you are getting. Best, Sergiy