This guide provides a step-by-step approach to correctly fill the QuestionOptionsLang table. This table is used to store multilingual text for each answer option in the survey. It supports multi-language surveys, allowing the same option to appear in multiple languages with corresponding text, labels, and import/export values.

The table is linked to the QuestionOptions Table via optionid, meaning each option from QuestionOptions Table has a corresponding language text entry in fw_questionoptionslang.

You can find the detailed structure of the QuestionOptionsLang table here: 👉 QuestionOptionsLang Table Structure

This is the primary key (auto-incremented) for the table.
Do not manually enter this value if inserting data directly via the database.
It is automatically generated.

The optionid is a foreign key that links the answer option to the QuestionOptions Table (fw_questionnairedetailsoptions). This ensures that the multilingual text is linked to the correct option.

Example: Suppose your answer options in QuestionOptions are:

• id = 201 → Very Satisfied
• id = 202 → Satisfied
• id = 203 → Neutral

You need to link the text to these options using:

• optionid = 201
• optionid = 202
• optionid = 203

This column specifies the language in which the option text appears.
Use standard language codes like:

• EN → English
• NL → Dutch
• FR → French

Example: For the option Very Satisfied:

• language = EN → Very Satisfied
• language = NL → Zeer Tevreden
• language = FR → Très Satisfait

This is the text that will appear in the survey as the answer option for respondents.
It should be clear and concise.

Example:

The graphoptionname is the text that will appear in graphical reports like bar charts, pie charts, etc.. This text is usually shorter or abbreviated to ensure it fits in the graph display.

Example:

The reportoptionname is the text that will appear in the downloadable PDF/Excel reports. This text is typically the same as the option text, but you can customize it for clarity.

Example:

The importoptionname is the value that will appear in the Excel/CSV import files during bulk data import.
This should be a short code or abbreviation to make data mapping easier.

Example:

If the option allows respondents to provide an open-ended text answer (like “Other, please specify”), this field holds the import name for that text. This is useful when importing survey data with open-ended responses.

Example:

The reportopenansname is the text that will appear in downloaded reports for open-ended responses.
This text ensures the report clearly identifies open text answers.

Example:

This column indicates whether the text was:

• 0 → Manually added
• 1 → Automatically generated by Module Language Settings

Example:

This allows you to differentiate between auto-generated and manually added text.

Here’s an example of a complete record for the Very Satisfied option:

1. Always ensure the optionid matches the ID from QuestionOptions Table.
2. Always test the survey after inserting multilingual text.
3. For open-ended responses, ensure you fill importopenansname and reportopenansname.

.