Configuring Language Preferences for Date and Number Input in the Application

[AbdullaNsour]

I handed over the application to the client, and they are utilizing a different language on their device. When inputting the date, the data input method switched to the language of the device. How can we configure the application to input numbers and dates in English?

[LIUZheng]

It looks like the language is affected by the browser setting.

I used to launch my app with either MS Edge or Chrome, and saw different date types. But after I change the browser language setting, the displayed date type follows the change directly.

e.g. in MS Edge:

three dot button on the top right corner -> settings -> Languages -> Preferred Languages

the first language chosen on top of the list directly influences the AppSheet display

I am also looking for a reply, because I cannot ask my client to change his own browser preferences.

[AleksiAlkio]

AppSheet uses app user's device and it's locale settings. With the Chrome it's the language on the top of the language selections. As far as I know, this is something that you can't change with app's own settings, unfortunately. Though if you just need to show the date with a specific format, you can convert the data with the TEXT() expression.

[LIUZheng]

It's already TEXT(). The problem is that I didn't find language setting in Google date format. As for MS Excel, there is a language id. Putting the language id as a prefix to the date format will force the output string to follow the language setting specified by the id.

e.g.

• [$-en-GB]mmm -> Oct
• [$-zh-CN]mmm -> 10月 (Chinese)

I think Google doesn't have this yet.