Return English only labels in multilingual form using jr:choice-name

[Rusti]

Hi,
Is it possible to return the text label in a calculated field as English (en) only when using a multilingual form and the enumerators have selected a different language?

jr:choice-name(${Project_ID},'${Project_ID}')

thanks

[wroos]

Could you provide more details, please, or a related example/extract of your form, incl. choices?

• Esp. what are the types of the variables?
• Do you use multiple language labels for the Project_ID? If not, you can just copy the ::English (en) label into all other label columns for this ID-variable. (In XLSForm, you can use an Excel cell reference formula for this copied value).

[Rusti]

Thanks for the reply Wroos, Project_ID was just one example and not a good one as the name is the same across all languages as you suggest, however several common species names change across the languages and I would like to only return the English name if possible independent of the language the enumerator is completing the form in. The variables are text values, common names of animals.
thanks

[danbjoseph]

jr:choice-name() returns the label value, in the active language. I am not aware of a way to get a label of a non-active language using that function. See the following two posts for more details. The first one has a workaround described in the thread.

Retrieve the label of a non active language in multilingual form

I have a multilingual form (attached) and I need to retrieve the label of the "markets" field always in English. I have used a calculation field as below: jr:choice-name(${MarketName},'${MarketName}') This works well when the active language of the form is in English. But when I collect the data in another language it doesn't work (as stated in the documentation. Is there a way to retrieve the label of a non-active language? SMPMS_20190726_0220.xls (57.5 KB) MyCom.csv (284 Bytes)

Jr:choice-name() not re-evaluated on form language change

1. What is the issue? Please be detailed. When changing the form language, jr:choice-name() does not appeared to be re-evaluated. Swiping backwards and forwards is enough to update calculations that are triggered by a variable, but calculations without implicit or explicit triggers are never updated. When expressions are evaluated suggests a number of points when expression will be evaluated, but we've noticed when passing static values into jr:choice-name() sometimes a calculation could go t…

[wroos]

Depending on the number of choices to treat here, you might use some workarounds:

• Add a look-up column to the original choice list, with the corresponding EN choice names you want to show (or empty value to switch to the language-specific label). See first link cited above. https://docs.getodk.org/form-datasets/#looking-up-values-in-dataset.
• Use a look-up table (or csv file), with the corresponding EN choice names you want to show and the original name as key. See https://docs.getodk.org/form-datasets/#attaching-csvs-for-lookups-without-a-select.
• Do an extra calculation with cascading if clauses, based on the name of the original choice, returning either a written EN text or the original language-specific choice label.
• Add the EN name to all language-specific choice labels, e.g. in [brackets].

Hint: Often the search function of the forum can help to find similar discussions and examples.

[Rusti]

Thanks for this i got it to work.