Can I set different Language per app User

[Jack_Bates]

I have some App Users that would function better if the app was in their own language is it possible to set user setting. Or can someone point me towards the information so I can learn it.

[Suvrutt_Gurjar]

Feature: Changing the language in your app (locali… - Google Cloud Community

Language Translate - Google Cloud Community

Sample App - User Form with Multilingual Questions… - Google Cloud Community

Here are some tips in the community that can get you started. Please search by keyword “language” in tips and tricks section and in “Q&A” section. You will get many posts discussing multi language app requirement.

[Jack_Bates]

Thank you

[Jack_Bates]

I don’t think USERLOCAL() will work alone as I will have to either make copies of the app and Localize each one in a different language EX: Spanish, Slovak , French, German

So I will probable have to make an option in the app user table to allow the user to set their preferred language.

That will be the path I will have to learn

[Jack_Bates]

I made a table “Translations and I am adding the languages that I need on it and built a reference in the user settings.

This is working great so far Ill update this thread with more information after testing.

[Jack_Bates]

I made a column visible in User Settings for Language In the main app that I want to make multi lingual. When I made a column labeled [Language] in user settings and made it to show. It isn’t showing up in the Menu Navigation Views.

1. Am I missing something

The test app I made to test this it showed up it showed up in the menu views after I added it to USER Settings and made it to show ok

[Steve]

https://support.google.com/appsheet/answer/10106760?hl=en

[Jack_Bates]

you for the Information

I had to make two show for it to show up

[Jack_Bates]

In the app I have 2 types of enum lists ( None are where the user can change the list)

1. Enum List Is on the column type for equipment type “Tractor” “Trailer”

2. Enum List pulls a valid statement from a column for expenses category and sub category in a different table.

Question: could someone be able to give me an example as to how to write the expressions to pull the enum list from the Table holding the lists in each language based on which language was chosen in [user settings]

I use this expression to pull the chosen language fro each column without an enum list

lookup(usersettings(Language),Translations, Language, EMAIL)

[Steve]

To make Enum values translatable, create a worksheet (or whatever) called (e.g.) enum values that defines the known Enum values and their translations:

Add the worksheet as a table. Read-only means Enum values and their translations need be managed in the sheet directly rather than in the app. You really don’t want to risk users of the app messing with your Enum values and translations.

Setup the columns of the table. Setting their type to LongText allows for the possibility of multi-line translations even if most or even all are just a single line. Add a virtual column named (e.g.) label to receive the translation for the current user and make this column the row’s label.

Use the label column’s App formula to compute the translation for the current app user. This example expression uses USERLOCALE() to identify the current user’s language preference, but you could just as easily use USERSETTINGS() or some other means. You might also prefer to use a different default result than [enum] if the user’s preferred language isn’t supported.

Setup an Enum-type column to use these translatable values. Set the allowable values to key column values in the enum values table. Set the Base type to Ref. Set Referenced table name to the enum values table.

[Jack_Bates]

Thank you Steve I will work on that this weekend and will post the result or more question here

[Steve]

@Jack_Bates

I need to write the expression so it will be an IF statement in Display Name that will show if the usersettings(Language) ISBLANK() Show “Load Revenue” if not blank show the expression to pull from Translations table

Sounds pretty straight-forward to me. What are you having trouble with?

[Jack_Bates]

You will laugh if I told you. Brain F>>>>

First expression kept showing the virtual column name “Loaded Miles_s” worked four hours trying to get it right

So I drove a 1000 miles unloaded fixed supper. Then sat down and 5 minutes later it worked.

IF(ISNOTBLANK(usersettings(Language)),lookup(usersettings(Language),Translations, Language,“LOADED MILES”),“LOADED MILES”)

It worked

[Jack_Bates]

Ran into a little problem that when I changed the Language to Espanyol es

The ENUM list isn’t pulling the language from the ENUM List

[Steve]

For the ENUM table, the ENUM column should be of type Text, not LongText, and should be the table’s key column. The Label column should be of type LongText. not Text, and should be the table’s label column.

I’m not sure what the “USERROLE” screenshot is showing me. The yellow triangles indicate the values displayed as options are of type Ref but do not match a key column value in the table referenced. Your Ref is misconfigured.

The expression shown uses Index(Split(…),1), which is correct when using USERLOCALE() as I suggested, but may not be for your use of usersettings(Language). Please post a screenshot of the Language column configuration in user settings.

[Jack_Bates]

I changed the usersettings(Language) to userlocale() and that removed the Triangles. and

Changed the [ENUM] to key and text


[Jack_Bates]

usersettings(Language)

[Steve]

Please post a screenshot of the columns of the Translations table.

[Jack_Bates]

Translation Table for multi language

[Steve]

I can’t make sense of this.