Matrix Question Custom Validation | Experience Community
Skip to main content
Solved

Matrix Question Custom Validation

  • December 17, 2021
  • 1 reply
  • 232 views
W

Hi all, I have a matrix question with 12 statements and each statement has 3 answers, select all that apply. If they click column B and/or column C, then they must also click column A. However, they can choose not to click on any of the three columns. I tried the custom validation logic but I can't figure out how to do it there. Any suggestions? Thanks.

Best answer by rondev

Assuming column A, B and C has recode values 1, 2 and 3 respectively. We can add validation as:
Statement 1 (Recode) is equal to 1,2,3 OR Statement 1 (Recode) is equal to 1,2 OR Statement 1 (Recode) is equal to 1,3 OR Statement 1 (Recode) is empty
AND
Statement 2 (Recode) is equal to 1,2,3 OR Statement 2 (Recode) is equal to 1,2 OR Statement 2 (Recode) is equal to 1,3 OR Statement 2 (Recode) is empty

1 reply

rondev
Level 6 ●●●●●●
Forum|alt.badge.img+22
  • rondev
  • Level 6 ●●●●●●
  • Answer
  • December 25, 2021

Assuming column A, B and C has recode values 1, 2 and 3 respectively. We can add validation as:
Statement 1 (Recode) is equal to 1,2,3 OR Statement 1 (Recode) is equal to 1,2 OR Statement 1 (Recode) is equal to 1,3 OR Statement 1 (Recode) is empty
AND
Statement 2 (Recode) is equal to 1,2,3 OR Statement 2 (Recode) is equal to 1,2 OR Statement 2 (Recode) is equal to 1,3 OR Statement 2 (Recode) is empty

Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
Terms & ConditionsAccessibility statement