Price formatting in Brazil

Ask for Help
1

Hi everyone

In Brazil, price formatting uses a period for decimal places and a comma for cents.

Example: one thousand five hundred and fifty cents

In Glide, the format is American:

R$ 1,500.50

In Brazil, the correct format would be:

R$ 1.500,50

Is there any solution for me to change the comma?

Thanks

2

Doesn’t the number format change based on the locale of the device? Have you tested on a live app in production to see if the numbers display correctly?

3

Yes, it appears correctly on the device. But when I add an integration such as DocsAutomator PDF, it exports in the original Glide spreadsheet format. Do you have any suggestions?

1 Like
4

Under the hood, they are still just numbers. I believe you have to use a template column, pointing that to the number column where you already have it formatted, then pass the template value to PDFMonkey.