...
- Define a basic table that includes the information you'd like to store. Here is an example of a table that stores States. Note: I've set this table up so that its visible to all users (for simplicity).
- Download the table from CommCareHQ to add language information.
Modify the types sheet to identify which columns will have multiple languages. This is done by adding an extra property on the field that will indicate the language. This is highlighted in Red below.
Delete(Y/N) table_id is_global? field 1 field 2 field 3 field 3 : property 1 N state yes population id name lang Modify the state sheet to add the list of states with each language. We'll also need to modify this sheet's columns to include the additional language information. You will need to add columns for each language supported. The example below includes two languages, but you can add additional columns titled name: lang X and field: name X for more languages.
In the lang column, specify the language code used in CommCareHQ for the language. You can find this by reviewing the language configuration page in CommCareHQ. In this example, I've used English and Hindi. (Note: For new rows, you can ignore the UID and Delete(Y/N) columns).
UID Delete(Y/N) field: population field: id name: lang 1 field: name 1 name: lang 2 field: name 2 1000 up en Uttar Pradesh hin उत्तर प्रदेश 1500 gujurat en Gujurat hin गुजरात 1583 bihar en Bihar hin बिहार Upload the updated Excel file to CommCareHQ. You can check "Replace Existing Tables" to replace any existing data for this table on CommCareHQ.
- You can review the uploaded data by clicking the View Table link next to the table on the page.
...
- First we need to setup a label that contains the language codes that you want to use in your app. In your form, add a label with the question ID of lang-code and label text that matches the language code for each language. We'll also set a Display Condition of 1=2 on this to ensure that it doesn't appear in the form. This label will be used to determine which language to display, based on what language is chosen.
- Now add a single or multiple answer lookup table question question to the form
- Choose the Lookup Table Data item
- Set the lookup table to the lookup table you uploaded (ex. state)
- Set the value field to the column in your table you want to store (ex. id)
- Set the display text field to the following: name[@lang = jr:itext('lang-code-label')] . You can replace name with the column that contains multiple languages.
- Update and Save your form. Now the list of options should change their label based on what language is chosen for the application. However, the data stored will remain the same.
...
- Sync your application. Some users have reported this error with large lookup tables that have not properly downloaded which choosing "Update Commcare" from the menu. Run the sync to ensure all assets are properly downloaded to the device
- Make sure that the current user has lookup table rows assigned to them (Creating and Updating Lookup Tables)
- Alternatively, setup your lookup table so that it is available for all users (For the lookup table, set it up so that it is "Visible to All Users" by clicking Edit Type).
- Once you've done this, make sure you've synced your phone.
...