How to set up full local currency?

[Bungchow_IDEApps]

Hi Gliders,

I use Glide tables and would like to set up the numbers with full local currency, not only currency symbol. For IDR/Indonesian Rupiah, the numbers use point as group separator, not comma (orange box on an image below). My client insist to use the right format of our local currency.

Does anyone know how to set up the numbers? Thanks in advance.

[Uzo]

You can use JavaScript to convert the number to local

[Bungchow_IDEApps]

JavaScript?! Oh, no… I’m just a no-code developer…

Thanks for your quick response @Uzo

[Uzo]

a little bit of Java will not hurt you

[Uzo]

if(p1){
let rupee = new Intl.NumberFormat('en-IN', {
    style: 'currency',
    currency: 'INR',
});
var price = p1;
return('Rupees: ' + rupee.format(price));
}

[Bungchow_IDEApps]

Thanks @Uzo… Do I use this JavaScript on Code column?

[Uzo]

yes… JavaScript column… put your price as p1 variable

you can take out 'Rupees: ’ +
from return if you want just price

[Bungchow_IDEApps]

I’m using Indonesian Rupiah, not Indian Rupee. But, it’s done and thanks again @Uzo

[Uzo]

I hope you will start loving Java

[Bungchow_IDEApps]

I hope so. Actually, I just copied and made a little modification only