How to get amount in XX.XX instead of XX.XXXXX

[Russ]

Hey guys, using embedded currency field,
on email templates I see this: $-550.1400
vs expected: $-550.14

what is the best way to trim it down on email templates? Or reduce the number of zeros? I guess it depends on 'decimal' checkbox, but once record is used and created is doesn't allow to 'deselect', thanks

[victor]

Identical topic: https://forum.espocrm.com/forum/deve...877#post101877

When using Email PDF, in the Parent field of the created email, you must specify the correct Opportunity, from which we will take values for our placeholders.

[Russ]

so I should add,
{{amountCurrencySymbol}}{{numberFormat amount_RAW decimals=2 decimalPoint='.' thousandsSeparator=','}}, I will test

[Russ]

Didn't work, victor, please advise

This amount: CPayment.amountRefunded

<p>We wanted to inform you that a refund has been initiated for your payment of <b>{{amountCurrencySymbol}}{{numberFormat CPayment.amountRefunded decimals=2 decimalPoint='.' thousandsSeparator=','}}</b> associated with Invoice Number: <strong>{CPayment.opportunityName}</strong>. Please note that this refund is currently being processed and may take a few business days to reflect in your account, depending on your bank's policies.</p><p><br></p><p>We appreciate your patience during this process. If you have any questions or need further assistance, please don't hesitate to reach out to us.</p>


Instead of amount, got 0, maybe the problem is 'parent, but how would I do that here in a workflow?

[victor]

Russ,

When sending the code, please use selection of its fragments so that the code does not merge with the text (screenshot 1). It's pretty hard to sort something out without highlights.

- I created a primitive BPMn based on the Opportunity entity (screenshot 2). I used the following code in the Email Template for clarity (screenshot 3).

{{amountCurrencySymbol}}{{numberFormat amount_RAW decimals=0 decimalPoint='.' thousandsSeparator=','}}

{{amountCurrencySymbol}}{{numberFormat amount_RAW decimals=4 decimalPoint='!!!' thousandsSeparator=','}}​

- This is what the amount field looks like in test Opportunity record (screenshot 4).
- This is what the email that was sent from the test Opportunity record looks like (screenshot 5).

[Russ]

Actually worked, victor, ty