I feel a little stupid posting this question, as I'm sure it's easy to do and the information is already out there somewhere, but I haven't had any luck finding it. I have a question which asks for the respondent's county. The counties are sorted into three markets, with quotas for each. Is there a way to set a hidden question that will automatically input the market into the database based on their county? For instance, the respondent reports they live in County X, there would be a hidden question that automatically selects Market 1 or if they say County A, it automatically selects Market 2.

Thanks in advance,

Andrew

Hi welcome,

Which kind of question type are you using for counties?

List(Radio)

If the question code for this radio question is "Q1" ...
containing 2 items with answer option codes "us" & "uk"...:

just set an equation type question using the following code or syntax as question text:

Almost there. I should have mentioned, the main reason that I'm doing this is to make it easier to monitor quotas. Is there a way to make the information from that equation trip a radio (list)?

In this case it's easier to use a checkbox question with just one answer option checked by default... and play with relavance field

for example if you only target USA & UK:

1) set a multiple choice question
2) create one answer option
3) tick it by default (there is an icon for that near answer option creation)
4) In the relevance field set your formula, something like: (in clear: true if not uk or not us)
5) hide this question
6) Apply your quota if this question is relevant

Perfect. I had never noticed that check by default option before. Very helpful.

for radio buttons and other question types too...

Hi guys,
does anyone see the error (t2m69v01 is a multiple choice question)? :blink:
Thanks in advance

This question has at least 1 error. 1
if((t2m69v01_1 == "Y") OR (t2m69v01_2 == "Y")), 2, ' ' if(t2m69v01_3 == "Y"), 4, ' ' if(t2m69v01_4 == "Y"), 3, ' ' if(t2m69v01_nd == "Y"), 1, ' ' if((t2m69v01_1 == "N") and (t2m69v01_2 == "N") and (t2m69v01_3 == "N") and (t2m69v01_4 == "N") and (t2m69v01_nd == "N"), 5, ' '

Question attribute Value
statistics_showgraph 1
hidden 1

Seems you lost a lot of ) at end of the equation.

Denis

I don't think that there are any "N" values for multiple choice sub questions. The values should be "Y" (checked) or "" (unchecked).

Well ... :huh:
The logic check is the same for "N" & "".
I added one ) which was definitely missing, but there's something wrong, still :S

{if((t2m69v01_01=="Y") OR (t2m69v01_02=="Y")), 2,' '} {if(t2m69v01_03=="Y"), 4,' '} {if(t2m69v01_04=="Y"), 3,' '} {if(t2m69v01_nd=="Y"), 1,' '} {if((t2m69v01_01=="") and (t2m69v01_02=="") and (t2m69v01_03=="") and (t2m69v01_04=="") and (t2m69v01_nd=="")), 5,' '}