Hi,
The Update word doc activity is such a great tool and I am using this on at least 10 workflows. But I have come to a situation using the Table Merge where the database records are not the format our users would like. Is it possible to modify the format just like you can using the Token editor? I have 2 columns requiring formatting:
1) A Date field that is displaying as Date and Time (we require Date in format dd/MM/yyyy).
2) A number field displaying with just 2 decimal places (we require currency format including the thousands comma separator and $ symbol) I know I can easily insert the $ symbol before the merge field.
This is only an issue with Table merge fields (no issue with the Simple Merge fields as you can use the token editor).
I have been playing with the Type and Render field default options by inserting the token such as:
#,###.00
%(CustomQuery_Invoice_Amount#"c"#)
%(CustomQuery_Invoice_Date#"dd//MM//yyyy"#)
But no such luck. I couldn't find any documentation on Answers or the support site with examples on how OR if this can be done.
The only other option I can think of is using multi value tokens, but these will only be displayed in a single column cell. The users require line borders between rows.
Any ideas?
cheers