Hi, My g.sheets locale is correctly set, but when I try to input a decimal number in Glide app it only allows a dot, and not a comma. My locale uses comma, and sheets displays a comma as well. If I try to use comma in Glide input field, nothing gets passed to sheets, dot works, and it gets passed as comma to sheets. Also in Glide data sources I see a comma if I did not edit the column, but as soon as I edit it (add units for example) I get dots instead of a comma. Any advice is appreciated. Tnx.

Is the Locale for your browser and OS set correctly?

Language in FF is set to GB, there is no locale option. Locale in sheets is set to Croatian, and the language in Android is set to US, but the region is Croatia. Everything else works as expected.

I’ve seen 3 posts in the past few days regarding the locale for numbers, so I’m starting to wonder if there is a bug somewhere. It should be automatic based on your system settings.

This is for both Windows and android. The behavior is the same.

Hi Jeff, tnx for the reply. If you work for Glide and need to me to troubleshoot anything do let me know. Can’t today, way to exhausted, but I can try tomorrow.

I do not work for Glide, but you can try submitting a support ticket. [image] How to open a support ticket? Ask for Help Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the Glide Support Page. To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: [CleanShot 2023-08-16 at 16.24.33@2x] Glide will prompt you to create a support link for your App. Click on Create Link: [CleanShot 2023-08-16 at…

hi @Spiro, maybe this helps. i assume it’s not a bug, it’s only that glide uses the US locale and this doesn’t seem to adjust in browser. I got this hint from a glider today: [image] Really no solution for thousand separator? Ask for Help There is no control over this chart values look. Hope this helps.

You should not have to do any special javascript to get the number formatted the way you want. Glide should be handling this depending on your locale. While the javascript solution may work, I don’t believe it should be necessary. Glide has been handling the decimal and thousands separator correctly for several years. Only recently, does it appear to be an issue. The locale is determined by the device, and the app should adapt accordingly. If everything is working correctly, we can both view the same app and I will see numbers in US format, whereas you will see them in German format. Glide is designed to automatically handle different number formats, as well as automatic translation of certain components. The experience for each user should be unique to their device settings.

Interesting. As far as i remember Airtable had always problems with that topic. So, we should then open a ticket for that.

I would recommend a ticket, unless others from your region can chime in. I tried it just now, and when I change the default language of my browser to German, it changes how it’s viewed in the table. OS Region setting didn’t seem to make a difference, but the browser definitely did. Browser language set to English: [image] Browser language set to German: [image] I didn’t have to do anything special other than make sure my browser is set correctly…so for me it’s working as expected. [image]

Form number input decimal separator

Ask for Help

Jeff_Hager April 4, 2023, 8:01pm 7

I do not work for Glide, but you can try submitting a support ticket.

Topic		Replies	Views
Formatting + language questions Ask for Help	7	641	June 15, 2023
Local/Regional Settings Needed Feature Requests	8	116	July 7, 2024
Really no solution for thousand separator? Ask for Help	14	1029	April 4, 2023
Number in Text Report a Bug	0	278	September 9, 2020
Formatting of number columns may misrepresent values Report a Bug	8	910	February 24, 2023

Form number input decimal separator

Related topics