Check out our latest news and articles.

Visit our Blog

Localize your apps with the Currency Selector

Our multinational clients often want to roll out apps for use in different countries. The Currency Selector allows them to create more flexible apps that display local currencies. Users simply select the right currency symbol for their country from the dropdown menu.

After adding a Currency Selector to the interface, you can choose which currencies will appear on the menu by clicking “Edit Currencies” under the properties tab.

You can select from a wide range of symbols to be displayed in the dropdown menu

As you would expect, the appearance of the dropdown is fully customizable. You can also choose whether to display currency symbols (e.g. “€”), currency names (“Euro”) or currency codes (EUR) in the menu.

Any control in your app with a currency format (such as Text Fields, or Tables) can be set to display the user-entered currency by setting the “Symbol” to “User”.

A Text Field [2] displays the user-defined currency format, since “User” has been selected as the symbol [2] in the properties tab

Using a formula to display the user-defined currency

If you build spreadsheets in Excel or BaseCase, you may already be familiar with the TEXT() function, which allows you to apply a format to a number. For instance, to format the value 1234 as a dollar amount, you can use the formula:

=TEXT(1234, “$#,##0”)

to display “$1,234”.

If you would like your formula to use the user-defined currency, then you can do so with “/$/”. For example, if the user-defined currency is “£”, then this formula:

=TEXT(1234, “/$/#,##0”)

will display “£1,234”. You can place the symbol on either side of the number, or in the default position for that currency, as follows:

Please note that the Currency Selector changes only the symbol displayed and does not carry out a currency conversion. Access the Editor Reference Guide within BaseCase Interactive for more information and technical help using the Currency Selector.