Sample App - User Form with Multilingual Questions based on User Language Selected

[jyothis_m]

Hi all,

This Tip is posted for better visibility to all. The basis of this tip is the Query asked by @Surdusvacca regarding Multiple Language Survey to which I have replied. Later I made some improvements with Googletranslate Function available in Googlesheet and thought to add it as a new Tip here.

USE CASE : for creating user-forms in which the Questions being asked should be Mutilingual based on the Language that the user selects first

SAMPLE APP

IMPLEMENTATION

• Created a Table USERFORM which contains the actual userdata. The Table has a Column [LANGUAGE] which the user selects and the Questions in the Form will be in the Language Selected by User

• Created a Table TRANSLATE which contains the List of Languages to be shown to the user. This Table also contains the Questions Translated in the corresponding Language using the Googlesheet Formula =IFERROR(GOOGLETRANSLATE("What is your name?","EN",$B2),""

•  The Column [LANGUAGE] in USERFORM is of type ENUM with base type as REF with Reference Table as TRANSLATE
• The Questions in USERFORM are then translated to the Language Selected by using the De-reference Expression [LANGUAGE].[Question]
• The Language Code is Lookedup from another table which contains all Languages and Codes supported by Googletranslate function