Edit

GETLABELTEXT ER function

  • Article

The GETLABELTEXT function searches for a specific label to return a String value that represents the translation of the specified label in the specified language.

Syntax

GETLABELTEXT (label id, language)

Arguments

Label ID

label id: String or Label Id

The valid ID of one of the following label types:

Usage notes

This argument can be defined only as a constant, by using one of the following supported patterns:

  • For ER labels:

    • @"GER_LABEL:<LABEL ID>"
    • "GER_LABEL:<LABEL ID>"

  • For Finance labels:

    • @"<LABEL ID>"
    • "<LABEL ID>"

Note

At design time, a validation error message is shown on the Formula designer page if no label can be found by using the provided label ID.

Language

language: String

A string that represents a language code.

Usage notes

This argument can be defined either as a text constant or as the path of a data source field that returns a String value.

Note

At design time, a validation error message is shown if no language code can be found by using the provided language argument when it has been defined as a text constant.

At runtime, the translation for the EN-US system language is returned for a specified label if no language code has been found by using the provided language argument.

Return values

String

The resulting text value.

Example 1: System label

The expressions GETLABELTEXT (@"SYS70894", "en-us") and GETLABELTEXT ("SYS70894", "en-us") return the English translation "Nothing to print" for the @SYS70894 application label.

Example 2: ER label

You start to edit an ER configuration that has been derived from the ISO20022 Credit transfer (DE) configuration, enter a new data source of the Calculated field type, and configure the expression GETLABELTEXT(@"GER_LABEL:VendorName", "de") for this data source. In this case, at runtime, the data source returns the German translation "Kreditorenname" for the @GER_LABEL:VendorName ER label that was initially configured in the base ISO20022 Credit transfer (DE) ER configuration.

Additional resources

Text functions

Design multilingual reports in Electronic reporting