Really no solution for thousand separator?

[pluzgi]

Hi guys,

if i have used a glide table with a number column is there really no option to format the thousand separator with a “.” instead of “,”.? In Germany these numbers have a complete different meaning. Maybe by using the math column in a smart way?

Thanks, Sabine

(Already checked all format options in google sheet or airtable and imported it;-(

[Jeff_Hager]

@pluzgi I trust that your numbers are in columns set to numeric types?

@nathanaelb would you have any thoughts on this or what other settings need to be adjusted in the browser or on the device?
For further reference:

Formatting + language questions

Hi there, just started with glide today and really like it so far. After surfing the FAQ section i couldn’t find any information on these both questions. Hope somebody can help me. We in Germany use the “.” as the thousand separator (1.000 instead of 1,000). (How) can i format number columns or “big number” fields that way? Can i translated button field or default text, like “Submit” at button or “Filter by”. If yes, where? Thanks a lot and kind reg, Sabine

[pluzgi]

@Jeff_Hager, yes the columns are defined as number type.

[Uzo]

You can use a Java column and format your numbers to German:

return p1.toLocaleString('de-DE')

for display purposes only

[pluzgi]

Hi @Uzo ,
Amazing, thanks!
If you sometimes come to a solution where this can be used for calculation too please send me a note.
Have a wonderful day.

[Uzo]

… hmm… just keep both numbers

[pluzgi]

Yep, for big numbers it works, but unfortunately you can’t use this approach for graphs and legends like this because the the formatted numbers/computed column doesn’t relate to the graph.

[Uzo]

hmmm… yep, not good for that.

[Uzo]

But there is a solution to that! LOL

[pluzgi]

Great, how did you reach that?
I’ll send a for an answer.

[Uzo]

Hhahahahaha… pizza? I like German Beer

1. Create a template column with the name and amount from the Java column plus € character.
2. Uncheck the show values in legend box.
3. Put the template in Labels.
4. Put the regular number in Values.

[pluzgi]

It was a cookie
But for that you’ll get
I’m really happy now - looks like that now:

Thanks a lot, @Uzo!

[Uzo]

Na zdrowie!

[pluzgi]

@Uzo, if you don’t mind… I’ll have to use your flow today;-)
There is another separator challenge for the standard graph.
Do you have an idea for that too? Here i can’t uncheck the legend values.;-(

Thanks in advance.

[Uzo]

There is no control over this chart values look.