Based on the chosen Language set via usersettings(“Language”), a virtual column should concatenate two columns:
- the translated name of an item the user has selected from the ref dropdown
- user text input
USERSETTINGS(“SiteLanguage”) = “DE”
[User Input] = “Hallo”
Enum Table from which user selects an item in the form column [Select]:
° key column
** virtual column, used as label.
SWITCH( USERSETTINGS("SiteLanguage"), "DE", [DE], "FR", [FR], "IT", [IT], [EN] )
The “Translation” column is properly used to label the selected item.
However, when trying to access the item’s translated name through dereferencing [Select].[Translation], the fallback value from the switch statement is returned instead of the correct translation [Select].[DE].
Directly accessing the German translation through dereferencing is working as expected.
Please refer to the screenshot.
How in this case can I access the translated String so that the result of the concatenation example is
Hund: bla instead of Dog: bla?