Separator of thousands and decimals


Hi everyone, I would like to know in what way you can do something to avoid having the disadvantages with the separators of thousands and decimals in the price and number fields, since depending on the region this varies, and almost always there are problems when working with the traditional excel. thanks :slight_smile:

(Philip Garrett) #2

Forgive me if I misunderstand the question.

We select the decimal and thousands separator we display based on the Locale of the AppSheet table.
You can see the Locale for the table under the Localization setting for the table.
We normally determine the Locale of the table based on the Google Sheets Locale setting.

For more information search on β€œLocale” i the documentation.

1 Like

I think if that was the problem. thanks

1 Like

Hello Phil, I was able to solve the problem from the spreadsheet. but for example: here in Panama the separator of thousands is β€œ,” and the decimal is β€œ.”, since the spreadsheet works well, but from my app it is still different. I attach the photos

From APP:

From Spreadsheet:

(Philip Garrett) #5

Are you referring to how the data is displayed in the AppSheet application on the client device?
If so, that is controlled by the Locale setting on the client device.

This article explains how to set the Locale

1 Like

Thanks Phill that was the problem :+1::facepunch:

change the google chrome browser settings and it worked

1 Like