Workflow Soluiton

 View Only
  • 1.  Formatting Currency in a table column

    Posted Feb 06, 2013 10:13 AM

    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? 



  • 2.  RE: Formatting Currency in a table column

    Posted Feb 10, 2013 08:36 PM

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



  • 3.  RE: Formatting Currency in a table column

    Posted Feb 13, 2013 08:54 AM

    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.