You can feed back the answer that a respondent gives to a multiple choice question with the following interface.
Figure 8: Multiple choice question
When you select a multiple choice question, you will see a listing of the possible answers to that question. Next to each answer is a box. In these boxes you can provide the values that have to be placed in the destination database when the respondent chooses that answer.
You can choose the value <<UserInput>> for the 'other' answer. If the respondent chooses 'other' and enters any text in the 'other' field, then this text will be used, if you have selected <<UserInput>>.
For the 'Not Applicable' answer, you can choose to use the NULL value if the respondent chooses the 'Not Applicable' answer. You can do this by selecting the value <<NULL>>.
The value that is next to the answer that the respondent gives to the question will be used. The values that you can provide depend on the data type of the destination column. For the string type, you can enter any text string. For the numeric type, you can provide any numerical vale. If the column is of type date, then you will be able to select any date and the value <<DateParticipated>>, which will be replaced by the date at which the respondent completes the survey. For the boolean data type, you will be able to select true or false.