+30
-
-
Level 6 ●●●●●●
-
1030 replies
I have an annual survey that collects monetary values that go into the millions. I use mostly Matrix Table - Constant Sum questions, along with some regular Constant Sum questions., to capture these data The problem I'm running into is that, since the fields do not accept or display the comma separators, respondents can easily enter an answer that has an extra (or missing) digit without realizing it. I can't set up valid ranges with custom validation for most of these questions because the ranges vary greatly; some respondents could have answers in the thousands while others are in the millions for the same question.
Fellow Research Core users, do you have any suggestions to better validate these responses at the point of entry? Thank you in advance.