Dynamic currency code in workshop

[sboari]

I’m working on a project in which I need to dynamically format a double field into different currency formats based on a currency code stored in another column of the same table. The catch is that the currency might vary row by row.

For example, consider this table:

Amount	Currency Code
1234.56	USD
789.01	EUR
345.67	JPY

I want to display the Amount column formatted like this:

Amount	Currency Code
$1,234.56	USD
€789.01	EUR
¥346	JPY

Does anyone have experience implementing something like this? Are there any built-in tools, transforms, or visual formatting options in Foundry that can handle dynamic currency formatting at the row level?

If not, would creating a custom transform or pipeline be the best approach? Open to hearing creative solutions or best practices - any suggestions are welcome.

Thanks!

[arukavina]

There is a simple way to do this (now)
In the Ontology Manager, go to the object you want to configure, then properties. Then select the desired property to format and in display select base rtpw = Currency.

Now the trick is to click on the small arrow to the right and select reference.

Select the property that stores the currency information there. In my case iti’s called: Currency (not very creative)

Make sure you use the 3-letter-code for the currency

These are ISO 3166 currency codes

Hope this helps