Documents templates contain symbolic codes that are used instead of different data. For example, {DocumentCreateTime} code is used in a document template and gets replaced by actual document creation time in a document print form.

But there are different date formats or address formats, how can you select a specific date format that you need?

Don't worry, you can modify symbolic codes in documents templates and solve this problem.

How it works

You can add specific symbols after ~ to symbolic code to change the data format. For example, {DocumentCreateTime~d.m.Y h:s}

You can modify symbolic codes for dates, addresses, names and money amounts.

Date and time

By default, the date format in a document template is the same as the country that this document template belongs to. Let's modify the symbolic code that is used for adding document creation time to a document print form.

Here's how the print form looks now:

Name

You can modify the name format by adding specific words to symbolic codes. For example, the symbolic code {FormattedName~Format=#TITLE# #NAME# #SECOND_NAME_SHORT# #LAST_NAME#} will be replaced by salutation, first name, the first letter of the second name and last name in the print form.

Address

By default, the address format in a document template is the same as the address format used in the country that this document template belongs to. But we can modify the address symbolic code and use, for example, North American address format although the document template is bound to the UK.

Here's how the document print form will look like after address symbolic code modification:

Money amounts

For money amounts, you can modify symbolic code so that zeros after dot and currency will be shown in a print form of a document.

For example, let's modify the {TotalSum} symbolic code so that zeros after dot will be shown and currency sign will be added:

Here's how the document print form will look like:

Phone number

You can specify phone number format by adding a specific symbolic code after format. For example:

Available formats:

• E.164 - +12122191234
• International - +1 212 219-12-34
• National - 1 (212) 219-12-34

A specific product, tax or contact from the list

Some data is added to the document as a list. For example, taxes, products or contacts.

You can add to a document a specific item from the list. Just use the symbolic code:

By default, the first item from the list will be added to the document.

If you need to add an item that is not first in the list, just add index to this symbolic code. For example, this symbolic code will add the third item:

"Multiple" fields

In Bitrix24 CRM, fields can be marked as Multiple. That means that this field can have multiple values at the same time. For example, Phone, Email, Messeneger fields or any custom field marked as Multiple.

Use the symbolic code mfirst to add "multiple" filed values to the document:

• mfirst=y - add the first value
• mfirst=n - add all the values

For example:

By default, values are separated by comma. Use the symbolic code mseparator to select a separator - cooma (1) or line break (2):

Listing all products, contacts or taxes from the list

For example, you can list all the products in the document. Just add all=y to the corresponding symbolic code:

Instead of a comma, you can use a line break as a separator by adding mseparator=2 to the symbolic code:

Text case (from documentgenerator 22.200.0 version)

One of the frequent requests is a modifier to change the text case.

For example, {DocumentCreateTime~format=d F Y} displays the name of the month with a capital letter.

Now you can add letterCase modifier to any field to change the text case.

The modifier can take the following values:

• upper — upper case,

• lower — lower case,

• title — upper case for the first letter of each word.

Recommended articles

• Client's address in the invoice
• Documents templates
• Documents in CRM