LightningFlowComponents icon indicating copy to clipboard operation
LightningFlowComponents copied to clipboard

Datatable - Multiple Currency - Display in currency of record not users currency

Open SgtSkyfall opened this issue 4 years ago • 2 comments

Hey,

for our buisness we deal with services being in multiple countrys and currency. Could you please add the option to display currency in table in the currency of the record it shows?

Thanks a lot, Tim

SgtSkyfall avatar Jul 08 '21 11:07 SgtSkyfall

What version are you running? Multi-currency support was added in v3.1.1.

ericrsmith35 avatar Jul 08 '21 12:07 ericrsmith35

Hi there - I would just like to upvote this functionality. The use case is that we are querying multiple Opportunity Products and displaying them in the datatable. Some of these Opportunity Products have different currencies in the Currency ISO Code field.

However, currency fields in the datatable will show whatever the running users default currency is as the currency symbol, which is very misleading. It would be awesome if there was a configurable option in the datatable to either use the records currency symbol or the running users default currency.

The workaround is to create a formula field that returns a number and references the currency field. Then you can display both the Number field and currency iso code from the record in the datatable.

Thank you! image image

ganieany52 avatar Feb 11 '22 15:02 ganieany52