Localize text in card

[Scott_Nesbitt]

My app uses a card view for the home / landing page, and I would like to localize the Title, Subheader, and Description text:

Could someone tell me how to do this?  It looks like expressions are not supported here.

Thanks

[Denny774]

Hey man,

you gotta translate the content of the field(s).
Maybe this can help you in case you're using a gSheet as Database:
https://support.google.com/docs/answer/3093331

Cheers

[Scott_Nesbitt]

Right, I am using the Sheets GOOGLETRANSLATE() function in the Sheet, but I need to do this expression to get the right language:

LOOKUP(usersettings(Language), Language, Language, "Description")

I cannot get to usersettings in the Sheet, that is only accessible in AppSheet, correct?

[Denny774]

Hey,

that's what USERLOCALE() normally is there for:
https://support.google.com/appsheet/answer/10108289?hl=en

e.g. Create a Virtual Column "TranslatedText" and put this as the AppFormula:

SWITCH(USERLOCALE(), 
  "en-US", [USEnglishTranslation], "es-ES", [SpanishTranslation], "fr-FR", [FrenchTranslation], [LocalText]
)

You can then use [TranslatedText] in your CardView.

Here's an overview of the supported locales:
https://support.google.com/appsheet/answer/11579290?hl=en

Cheers

[Scott_Nesbitt]

But I cannot do a SWITCH() or USERLOCALE() in the Card layout because it does not support expressions.  Or am I missing something?

[Denny774 · Accepted solution]

Hey,

you're missing that I said, create a VC (Virtual Column) for that 😅

[Scott_Nesbitt]

Ah, you are right, I did miss that.  Great idea to have a VC, works like a charm.

Thanks so much!