How do I validate that one field in a matrix table is a greater value than another? | XM Community
Skip to main content
Solved

How do I validate that one field in a matrix table is a greater value than another?

  • March 31, 2022
  • 3 replies
  • 113 views
L
Forum|alt.badge.img+1

I have a 2x2 matrix question - 1 row for Highest and 1 row for Lowest. How do I validate that the value entered into the Highest field is greater than the value entered in the Lowest field?

Best answer by liwesu

Edit: Solved using custom validation with regex matching to ensure only numbers entered and then Piped Text for the comparison of values.

3 replies

L
Forum|alt.badge.img+1
  • liwesu
  • Author
  • Answer
  • March 31, 2022

Edit: Solved using custom validation with regex matching to ensure only numbers entered and then Piped Text for the comparison of values.

Q
Forum|alt.badge.img

Hi there, I have a very similar issue. Is it possible for me to take a look at your code?

L
Forum|alt.badge.img+1
  • liwesu
  • Author
  • May 18, 2022

qualtrics_user_007 here is a snippet of the custom validation:
image.pngthe regex I used for digits (since it's slightly cut off in the screenshot) was: /\\d+(,\\d{3})?(.\\d{2})?/ - this allows numbers like 1, 100, 99.00, 10,000 and so on.
basically the first two regex conditions ensure only numbers are entered and then the third line compares the two inputs and ensures the value in the Highest field is greater than that in the lowest field. I pulled the input in the Highest field as Piped Text for comparison.
hope this helps.

Terms & ConditionsAccessibility statement