Hi,
Thank you for taking the time to take a look at my question.
I have a question which asks users to pick a choice from a drop down list with 21 answers.
Depending on the answer, I want to give a score between 1 and 3. (score to be saved in DB)
I think it's possible to do this with a long 'if' statement, something like this (I have only put in the first 2 of 21 answers here):
Code:
{if(Q8 == 'AGRICULTURE, FORESTRY AND FISHING', '1', if(Q8 == 'MINING AND QUARRYING', '2', '3' ))}
- Is there a better way of doing this than a long if statement?
- The code above doesn't work - I have tried with and without the '
- Rather than using the answer text in the Expression, is it possible to use the Answer code?
Many thanks for any help on this