- Currency Formatters

This feature requires: WOW 7.02 or above.

WOW Supports the use of Currency Formatters with the User Defined HTML feature. It is necessary for the database to be holding the currency value. This is not a conversion feature but will allow you to display the proper currency symbol if you have need to show currency symbols apart from the USD sign ($).

Since multi language currency symbols are not part of standard keyboards, we will need to use the UNICODE character sequence which will be encoded by HTML. To locate which currency symbol you need to create in HTML, reference this site: http://www.xe.com/symbols.php

For the sake of this example, we will create a symbol for the Costa Rica Colon:

Steps to create this include:

1. Create a derived field for the type of currency you wish to display, i.e. D_Colon within your operation and run your application.

1. Create a new FD for the derived field by clicking on the red gear icon.

1. Change the external name to something more friendly:

1. Scroll down to the Display Settings Section and set the Display Component to HTML Image and click “Apply.” Doing this, will allow you to type whatever HTML is desired to apply your symbol to your field. It is now necessary to locate HTML numeric Unicode associated with the desired symbol, again in our case, the Colon. These can be found here: http://www.w3schools.com/charsets/ref_utf_currency.asp. Enter in your HTML in the FD User Defined HTML section of the FD manager:

In this case the 8353 corresponds to the character found in the W3 Schools website:

So HTML:

&#8353 ??!VALUE

</div>

Make sure there are NO SPACES between the &#8353

The WOW framework will look for ??!VALUE and replace it with the runtime value of the column from the database.

The <DIV> tag can be replaced by any HTML code. For example: use the following:

<h1> ??!VALUE </h1>

1. Re-run application to see desired result: