USERSETTINGS and Virtual Columns

Hello everyone.

I need help about USERSETTINGS and Virtual Columns.

I am creating an App that works with different languages.

In a table I have the following columns: TypeID, Type1, Type2, Type3. Each column belongs to a language.
The Key is TypeID and the Label is a Virtual Column with the following expression:

SWITCH(USERSETTINGS(ID),
1, [_THISROW].[TYPE0],
2, [_THISROW].[TYPE2],
3, [_THISROW].[TYPE3],
FALSE)

The result is always FALSE. It is read by the USERSETTINGS ID. If I do the test with "Test" it works fine, but when I put the column in DETAILS, the result that appears is FALSE

If USERSETTINGS cannot be used in VCs... What can I do?

Thank you for your help, greetings to the Community

0 15 272
15 REPLIES 15
Top Labels in this Space