Email automation returning currency format different from the grid

[Camanzi]

Hello community,
Please, can someone explain (or where can I find the information) on how to add 2 decimal places after the comma in the currency format in email automation?
Thanks

[Camanzi]

In the attached file you can see another example of what has happened to us in the values in the automated emails. Please, We need help from someone qualified to answer!!! Or, do we only have Administrators who delete posts that criticize Bugs like these on Airtable?

[Andy_Lin1]

I haven't run into this problem myself, but it looks like this solution could work for you:

https://community.airtable.com/t5/automations/currency-format-in-email/m-p/41204#M1116

The solution is to add an extra step (a script) to the automation to format the currency value before it goes into your email.

[Camanzi]

Hi @Andy_Lin1 @ thanks for this awesome code and example base!

But unfortunately the Script does not work with numbers below 1,000.00.

We are in a difficult situation here. Could you please tell us how we could correct this point or suggest other Codes that solve this?

Thank you very much for your willingness to help.

[Andy_Lin1]

Is this the script you're using?
https://community.airtable.com/t5/automations/currency-format-in-email/m-p/41210#M1122

The regular expression in the script should work for numbers below 1000. Can you show what's happening with those numbers and how they should look instead?

[Lu]

@Andy_Lin1  is correct, you need to add a Run script automation step before the email step. You need to pass each number you want to as an Input variable. Use something like this in the script:

const formatter = new Intl.NumberFormat('pt-BR', {
    style: 'currency',
    currency: 'BRL'
});
Object.entries(input.config()).forEach(([k, v]) => {
    output.set(k, formatter.format(v));
});

Then use that script step's output variables in your email content (instead of the original record's values).