click_here_to_see_how_a_questionnaire_is_setup_in_detail

Question Types and Codes

In a survey, there are typically 10 types of questions, each identified by a unique code. Below is the standard list of Question Types along with their respective codes and descriptions.

Question Type Question Type Code Description
Single Response 1 Respondents can select only one option from a predefined list of choices.
Open Toelichting (Open-ended Text) 2 Provides an open text box for respondents to type their response (e.g., comments, feedback).
Multiple Response 3 Respondents can select multiple options from a predefined list.
Aspect 4 Typically used for questions focusing on specific aspects of a product or service.
Net Promoter Score (NPS) 5 Measures the likelihood of recommending a product/service on a 0-10 scale.
Image Picker Question 6 Allows respondents to select an image as a response option.
Rapportcijfer (Rating Score) 7 Captures a numeric rating (1-10) to assess performance.
Infoquestion 8 Provides informational text without requiring any input from the respondent.
Organization Question 9 Captures organization-specific information like department, branch, etc.
Multiple Image Picker 10 Allows respondents to select multiple images from a given set.
Upload Images and Files 11 Allows respondents to upload files or images as their response.
Multiple Response Aspect Question 12 Allows respondents to select multiple options under a specific aspect.

✅ Step-by-Step Process to Fill Question Tables

Filling in the questionnaire requires updating four key tables in the database. Follow these steps carefully:

Step 1: Fill the QuestionDetails Table

This table contains the main question setup, such as question text, type, and visibility settings.

👉 Click here to learn how to fill the fw_questionnairedetails table in detail.

Step 2: Fill the QuestionDetailsLang Table

👉 Click here to learn how to fill the questionnairedetailslang table in detail.

Step 3: Fill the QuestionOptions Table

This table contains all the predefined answer options for Single Response, Multiple Response, Aspect, and similar questions.

👉 Click here to learn how to fill the questionoptions table in detail.

Step 4: Fill the QuestionOptionsLang Table

This table contains the text for each answer option in the survey. It supports the same answer in multiple languages.

👉 Click here to learn how to fill the questionoptionlang table in detail.

Step 5: Fill the QuestionnaireHeader Table

This table stores the header information for each questionnaire.

👉 Click here to learn how to fill the QuestionnaireHeader table in detail.

click_here_to_see_how_a_questionnaire_is_setup_in_detail.txt · Last modified: 2025/03/11 05:59 by gloria