Hi, I am constructing a matrix table in which participants have to fill out one column to total 35. However, the first column must remain constant at 15. I am unable to use two different validations for the columns in my table. Is there code to require two different validation numbers for each matrix column?
If this is not possible, I have been exploring an alternative route. I have hidden the 'total' cell for the left column, as it is not important to my study. With the total column not showing, I could create an additional row and hide it from participants such that the left row always also equals 35 (but participants view it as totaling 15 because the row containing "20" is hidden from them).
Although I have successfully been able to hide a single cell from the matrix, and have been successful hiding a column, I cannot figure out how to hide only a row. I have looked at several related posts on this forum and none of these options have been successful.
Your help is greatly appreciated!
I can I see what it would look like? I am having a hard time visualizing it.
Yes. Participants are tasked with allocating task hours to two different employees. The left represents Employee 1 and the right represents Employee 2. I included a snip below. I am primarily interested in Employee 2, whose total hours MUST equal 35. I want to validate the question so that the right column has to equal 35, but so that it does not matter what the left column totals. The problem I am running into is that adding a validation requires BOTH columns to equal 35 before the participant can move on. This is what I am looking for a solution to.
If it is not possible to require a validation for one column and not the other, I could alternatively create a hidden row in the matrix (labeled task 11) and fill its left column with a "ghost" number that would result in the column also equaling 35. I have hidden the left-hand "total" from participant view using java, so that would not be an issue.
I just can't figure out how to get either of these options to work.
I should mention that Employee 1's column is going to be pre-filled from a participant's view, and they will not be able to edit Employee 1's hours. The pre-filled hours for Employee 1 must equal 15 (hence the problem with a blanket validation of 35 for both columns).
Here is the participant view when they fill the right column to 35 and try to move on. The validation prevents it because the left column does not also equal 35.
Honestly I would just load in the all the numbers in the first column as embedded text since you can't change it, but you still want to display it.
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.