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.