Im working on changing format of the value in datagrid. I need to change the format of value from US format to German format, meaning switching comma as thousand seperator to period as thousand seperator, and switching period as decimal seperator to comma as decimal seperator. I tried implement javascript, but It doesnt seem to work.
Here is my scriptHere its how the script affect the result,
Hi,
It looks like you're using a regular number column and trying to format it as currency manually, instead of using the built-in Currency Column.
I recommend switching to the Currency Column widget, it lets you easily set the currency symbol (which I assume is €).
To handle the thousand and decimal separators correctly, just set the locale to "de-DE". That will automatically apply the proper formatting. You can follow this guide for step-by-step instructions: Internationalization | OutSystems Data Grid.
My result:
Thanks for sharing