Video Screencast Help

Formatting Currency in a table column

Created: 06 Feb 2013 | 2 comments

In Workflow 7.5 I am using the Send Email component and trying to format a table from an array.  My array is returning a cost values as a decimal.  I would like to display this value in an email as currency.  I have tried using both the "html table from collection" and the "Table from array" formatters in the email component.  There seems to be several ways to format columns but I don't see a way to format these values as currency.  Does anyone know how this can be done? 

Comments 2 CommentsJump to latest comment

africo's picture

one way off the top of my head is to format as Number(Decimal) and merge in a dollar sign.

rhamner's picture

Unfortunately, this editor doesn't let you specify a column format like the Grid UI component. One easy option I can think of is to create a second version of the data-type you're working with that has a string instead of decimal for the currency. Before the send email component iterate through your data-type to build display version with the dollar sign.

It wouldn't be a bad feature to have a format property on columns in the Build HTML Table component.