insert question value

Previous  Top  Next

With the action insert question value you can place answers that respondents give to the survey into the destination database.

Question list
When you choose this action you will see a pulldown that contains a list with the questions that are present in the dialogue that is used for the selected project in the right pane. You can select the question for which you want the feedback to be placed in the destination database. For any question that you select, an interface that contains the possible answers to the question will be shown. For each column that is selected in the left pane of the Attribute Setup tab, only one answer of the respondent can be used for database feedback. If you want to feed back multiple answers from a respondent, you will have to place these in different columns.

Closed questions
For questions other than open questions, the respondent can choose one or more answers. You can define what data has to be inserted into the database for any answer the respondent chooses. The input fields in which you can enter what has to be placed in the database depend on the data type of the column in which the data is to be placed. For the string type, you will be presented with a textbox in which you can enter any value. For the number type, you will be presented with a number picker. You can also enter a numeric value manually. For the date type, you will be presented with a date picker. You can choose any date with the picker or you can enter it manually. You can also choose the special value <<DateParticipated>>. If you choose this option, the date at which the respondent completes the survey will be used. For the boolean type, you can either choose true or false.

Open questions
For open questions, the respondent fills out a value. You can choose to place the value the respondent enters into the destination database by choosing the special value <<UserInput>> for any open question. If a question has an 'Other' option, you can also choose <<UserInput>>, in the same manner as for the open questions. <<UserInput>> can only be used if the destination column is of the string or number type. If you choose to specify your own value instead of <<UserInput>>, this value will be placed in the destination database if the respondent answers the question.

Not Applicable
For questions that have the 'Not Applicable' option, you will be able to specify that the NULL value should be used if the respondent chooses the 'Not Applicable' answer. You can do this by selecting the special value <<NULL>>.

Not answered
A respondent does not have to answer each question in a dialogue. Not answering some questions will most likely occur for interactive dialogues. For each question, you can specify what has to be done if the respondent does not answer it. There are three options you can choose from:

1.	Do nothing: No action will be taken, for an update operation this means that the old value will be kept. For an insert operation, the NULL value will be used if there is no default value for the column. Otherwise, the default value will be used.

2.	Use NULL: The NULL value will be used.

3.	Use ___: You can specify what value will be used.

Figure 6: Question not answered options

You can select one of these options from the bottom part of the right pane. The Metatude software automatically checks the constraints for columns in the feedback database. The possible actions that can be performed when the respondent does not answer a question are derived from these constraints. For example, if your column has the Not NULL constraint, you will not be able to choose the option Use NULL.

In the next chapters the interface for each question will be explained.