MergeField formatting issues

Hi

 

I have a working Printable which prints my quotes. However, the formatting of the numbers is not in thousand separators, so I therefore updated the Word mergefield values, but when outputting from Creatio, I get no merge values populated.This is what I have done so far:

  1. Created a new version of the Word doc template
  2. Toggled the field codes to display the full merge values
  3. Changed a field which has a large multi thousand number from the following (note: how I have removed \*MERGEFORMAT):
    1. {MERGEFIELD "Opportunity product.Total, amount" \*MERGEFORMAT }

      to
    2. {MERGEFIELD "Opportunity product.Total, amount" \# #,##0.00 }
  4. Uploaded to replace the working Printable
  5. Generated the quote

In the resulting word doc, the values for this field are missing.

I have also tried the following variations, with none working:

{MERGEFIELD "Opportunity product.Total, amount" \# "#,##0.00" }

{MERGEFIELD Opportunity product.Total, amount \# #,##0.00 }

 

Either I am missing something obvious or Creatio does not like this format override.

 

Any help is greatly appreciated.

 

thanks

Like 0

Like

1 comments

Hi, Mark

 

You can use a macro for these fields in your printable. For example: ColumnName[#NumberDigit|,#] 

More information at the link: https://academy.creatio.com/docs/developer/application_components/repor…

 

Unfortunately, there are no basic application tools to add commas between the digits. It can only be done with the help of the development process. In this community thread, you can find the example of such implementation https://community.creatio.com/questions/how-set-comma-separator-money-f….

 

Show all comments