I have to design the survey which is available in based on user preferred language ServiceNow

[shubhamdubey]

Hi Team,

I have to design the survey which is available in based on user preferred language ServiceNow. I am not going to use the OOB API which ServiceNow has been provide for translation because this functionality has licensing cost.

Thanks in advance
Shubham

[Dr Atul G- LNG]

Then you need to manually make the changes in all tables. There are five tables used in the translation, and you need to update all of them.

ServiceNow stores translation information in these tables.

• Languages [sys_language]
• Translated Name / Field [sys_translated]
• Messages [sys_ui_message]
• Field label [sys_documentation]
• Choice [sys_choice]
• Translated Text [sys_translated_text]

https://www.servicenow.com/docs/r/xanadu/platform-administration/system-localization/r_TranslationTa...

[shubhamdubey]

Thanks for the prompt response do i need to create the survey in different language  then i apply this features ?

[Tanushree Maiti]

Hi @shubhamdubey 

Step 1: Translate Survey Questions & Titles

Survey titles, categories, and question strings are stored as translated_text field types. You must populate these manually in the Translated Text (sys_translated_text) table.

• Navigate to System Localization > Translated Text.
• Click New and fill out a record for each survey question/title:
1. Document: Select the exact Survey Question record (asmt_metric) or Survey Definition record (asmt_metric_type).
2. Table Name: Set to asmt_metric (for questions) or asmt_metric_type (for the survey name).
3. Field Name: Set to question (for questions) or name/description (for the survey).
4. Language: Select the target language code (e.g., fr for French, es for Spanish).
5. Value: Enter your manual translation.

Step 2: Translate Choice Options (Dropdowns)

• Navigate to System Localization > Choices.
• Filter the list where Table is asmt_metric_definition (this table stores survey choices).
• Open or create a choice record matching your target language:
1. Table: asmt_metric_definition
2. Element: value
3. Language: Select your target language.
4. Label: Put the translated text.
5. Value: Must match the exact backend integer/string value of the English original.

Refer: Surveys / Assessments and how to translate them

Translate Survey Questions in Service Portal 

[shubhamdubey]

Thanks for the prompt response.
I have 7 Country do i need to create the form in 7 seven language?