Localize text in card

AppSheet AppSheet Q&A
1

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

Scott_Nesbitt_0-1706111377048.png
Scott_Nesbitt_0-1706111377048.png644Ă—576 30.5 KB

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

Thanks

2

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

3

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?

4

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

5

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

6

Hey,

you’re missing that I said, create a VC (Virtual Column) for that :sweat_smile:

1 Like
7

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

Thanks so much!

1 Like