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?
Discussion Filed Under:
Comments 2 Comments • Jump to latest comment
one way off the top of my head is to format as Number(Decimal) and merge in a dollar sign.
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.
Would you like to reply?
Login or Register to post your comment.