Hi all,
I've created a side-by-side table with 5 drop down lists. Some respondents might have enough locations to enter all five, some may just enter one.
Is there a way (probably custom validation) to validate it so that the first column has to have an answer against each statement?
Hope that makes sense.
Any help would be much appreciated!
!
Page 1 / 1
For each of the 7 statements add a Custom Validation logic set like the following with ANDs between the logic sets:
IF Qxx - SBS1 Statement (Recode) - Is Not Displayed
OR Qxx - SBS1 Statement (Recode) - Is Displayed
AND Qxx - SBS1 Statement (Recode) - Is Not Empty
Where SBS1 means pick the first occurrence (for the first column) of the Statement in the drop down.
IF Qxx - SBS1 Statement (Recode) - Is Not Displayed
OR Qxx - SBS1 Statement (Recode) - Is Displayed
AND Qxx - SBS1 Statement (Recode) - Is Not Empty
Where SBS1 means pick the first occurrence (for the first column) of the Statement in the drop down.
> @TomG said:
> For each of the 7 statements add a Custom Validation logic set like the following with ANDs between the logic sets:
>
> IF Qxx - SBS1 Statement (Recode) - Is Not Displayed
> OR Qxx - SBS1 Statement (Recode) - Is Displayed
> AND Qxx - SBS1 Statement (Recode) - Is Not Empty
>
> Where SBS1 means pick the first occurrence (for the first column) of the Statement in the drop down.
Thanks @TomG!
There are around 200 options within the drop down list, so I obviously wasn't looking properly for this first time round!
> For each of the 7 statements add a Custom Validation logic set like the following with ANDs between the logic sets:
>
> IF Qxx - SBS1 Statement (Recode) - Is Not Displayed
> OR Qxx - SBS1 Statement (Recode) - Is Displayed
> AND Qxx - SBS1 Statement (Recode) - Is Not Empty
>
> Where SBS1 means pick the first occurrence (for the first column) of the Statement in the drop down.
Thanks @TomG!
There are around 200 options within the drop down list, so I obviously wasn't looking properly for this first time round!
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.