Format as Currency

Super Contributor

hello experts,


I need to format [Amount] as either $, €, or kr


I have a field [Currency] that is text and displays one of 3 currencies: USD, EUR or DKK

How can I display the currency symbol in my [Amount] field based on the text value in [Currency]? 




thank you 

2 Replies
best response confirmed by Tony2021 (Super Contributor)
your system only assign 1 currency symbol based on your regional setting.
for multiple currency, you need an additional short text field to put those
different currency symbol.
I just covered this in one of my videos. See: