Form design logic question

Support
1

Hi Yanokwa,

Good Morning,

I have four queries. I have marked my queries in yellow colour.

Q104 (Age) - If Q102 (Relationship of HoH) =1 and Q104 <=18 then Give error message for the first row of the roster.
If Q102 (Relationship of HoH) =1 and Q104 > 18 then give an error message for second-row Code 1 does not allow from row number 2.
Q102=1 accept only for 1st row of the roster from 2nd row onward it allows other than 1 code.

Q107 (Education) - 1st condition. If Q104 < 3 then skip to Q106 and Q107 questions.
2nd Condition if Q104>3 and Q106=98 then skip to Q107.

Let suppose a Total number of HH members are 4 in Household roster table where 2 male and 2 female are there. The two below queries:-

Q205a Q205a value should not be greater than or less than the of HH roster Female count value (Let suppose we have 2 female found is HH roster) then 205a value should be 2

Q205b Q205b value should not be greater than or less than the of HH roster Male count value (Let suppose we have 2 male found is HH roster) then 205b value should be 2.

I am enclosing my xlsx form your reference.

I would like to request you please make a correction in xlsx form if possible for you. I am trying these check but it is not working.

I am really grateful for your support and guidance.

Thanks & regards,

AnilAnil-Sample07-export.xlsx (18.0 KB)

2

Dear @AnilRawat,

you get the desired behaviour via some calculations.

I added these in the form and highlighted in green Anil-Sample07-export.xlsx (18.4 KB)

3

Dear Aurdipas,

Thanks for your response and guidance.

If possible please suggest and guidance in yellow marked queries.

I will check at my end and get back to you soon.

Thanks & regards,

Anil

4

Dear Aurdipas,

I have marked some queries in yellow marked. I would like to request you please suggest on that as well. The queries details are given below:

  1. Q104 (Age) - If Q102 (Relationship of HoH) =1 and Q104 <=18 then Give error message for the first row of the roster.

  2. If Q102 (Relationship of HoH) =1 and Q104 > 18 then give an error message for second-row Code 1 does not allow from row number 2.
    Q102=1 accept only for 1st row of the roster from 2nd row onward it allows other than 1 code.

  3. Q107 (Education) - 1st condition. If Q104 < 3 then skip to Q106 and Q107 questions.
    2nd Condition if Q104>3 and Q106=98 then skip to Q107.

  4. If we have big ID part can we call from external file. If yes then how do we write a command for them and where. ID part file is in which format xml or xlsx.

Thanks & regards,

Anil

1 Like
5

Dear Aurdipas,

I really thankful to you for your guidance and support.

Those check you have marked in green colour is working perfectly.

Thanks a ton for your guidance and support.

Looking forward for the same kind of support and guidance in my future queries.

Thanks & regards,

Anil

6

Look now rows 16-17 and 19.
I get automatically the Line No and only the first can be Head. From Line no 2 it is forbidden to choose Head.

Anil-Sample07-export.xlsx (18.6 KB)

1 Like
7

Dear Aurdipas,

Thanks Aurdipas!!!

You make my day to resolve some difficult issue which I am not able resolve from long time.

Can you please explain what this check means.

(selected(${Q102}, '1') and (. >=18)) or (selected(${Q102}, '2') and (. >=1)) or (selected(${Q102}, '3') and (. >=1)) or (selected(${Q102}, '4') and (. >=1)) or (selected(${Q102}, '5') and (. >=1)) or (selected(${Q102}, '6') and (. >=1)) or (selected(${Q102}, '7') and (. >=1)) or (selected(${Q102}, '8') and (. >=1)) or (selected(${Q102}, '9') and (. >=1)) or (selected(${Q102}, '10') and (. >=1)) or (selected(${Q102}, '11') and (. >=1)) or (selected(${Q102}, '12') and (. >=1)) or (selected(${Q102}, '13') and (. >=1))

Thanks a ton for your guidance and support.

These three below queries are left. Please suggest for the same.

Q107 (Education) - 1st condition. If Q104 < 3 then skip to Q106 and Q107 questions.
2nd Condition if Q104>3 and Q106=98 then skip to Q107.

If we have a Anil-Sample08-export.xlsx (18.9 KB) big ID part can we call from an external file? If yes then how do we write command for them and where. ID part file is in which format xml or xlsx.

Thanks & regards,

Anil

1 Like
8

This constraint on the AGE is saying that if you select the HEAD "(selected(${Q102}, '1')" then
the age must be greater than 18.
For
2 Wife Or Husband
3 Son Or Daughter
4 Son-In-Law/ Daughter-In-Law
5 Grandchild
6 Parent
7 Parent-In-Law
8 Brother Or Sister
9 Brother-In-Law/ Sister-In-Law
10 Niece Or Nephew
11 Other Relative
12 Adopted/ Foster /Step Child
13 Domestic Servant
it only checks that age is >=1.
If you want for example that for the choice Wife or Husband the age should be mor ethan 18 than
"(selected(${Q102}, '2') and (. >=1))" should be changed to "(selected(${Q102}, '2') and (. >=18))" etc etc

Anil-Sample08-export.xlsx (18.8 KB)

Now it should work the question Q107 (Education)

1 Like