Placeholders
  • 20 Jul 2022
  • 5 Minutes To Read
  • Dark
    Light
  • PDF

Placeholders

  • Dark
    Light
  • PDF

Placeholders allow you to pull in data about a specific client, group, loan account, or deposit account in an email, SMS, or webhook.

You may use placeholders when creating:

The placeholders available when you are creating a specific notification template will depend on the other template details including information such as target, recipient, or event trigger.

Adding a placeholder to a template or document

To add a placeholder to a notification template or document:

  1. Go to the template editor.
  2. Select a field from the Placeholder dropdown menu.
  3. Copy the placeholder text that is displayed when the field is selected, including the curly brackets.
  4. Paste the placeholder text in the content editor, where it should be displayed.
  5. Save your changes.

For example, if the document requires to have the account ID then this field should be selected in the placeholder dropdown, and its placeholder {ACCOUNT_ID} copied and pasted in the document editor. Whenever the document is generated for an account, the account ID will be displayed where the placeholder was inserted.

Product document placeholders

Account placeholders
You can select account placeholders using the Account Placeholders dropdown. They are available for account documents and include information about the account and the account holder, including custom fields.

Transaction placeholders
You can select transaction placeholders using the Transaction Placeholders dropdown. The dropdown is only displayed and available if the Include transaction history checkbox is selected. Transaction placeholders are available for transaction and account documents and they include transaction fields. They are available for transaction and account documents.

Start Statement / End Statement Placeholders
Product Documents which have the Include transaction history checkbox selected (for example, an account statement) have two additional placeholders which define where the transaction history such as the list of transactions within a date range will be displayed.

  • Start statement: defines the start of the transaction history area in the document
  • End statement: defines the end of the transaction history area

Any transaction history information that should be displayed in the document should be included between the start or end statement placeholders, no other placeholders should be included in between the start or end statement placeholders. You will only need to add one row of placeholders and the system will create as many rows as there are transactions between the date range given. Using the HTML editor you can make sure each element of the statement is properly formatted and aligned.

For example, a template with this section:

Statement HTML Code

<p>MBU Bennett Bank. - Branch: {BRANCH_NAME}<br>Address: 1506&nbsp; 00502&nbsp; Tel: <br></p>

<p>Deposits Account Statement<br>Printed on: {CURRENT_DATE}</p><table class="statementheader" border="1" cellspacing="#000000" width="100%"><thead><tr style="border-color: #000000;"><th width="50%">Client Information:</th><th width="50%">Account Information:</th></tr></thead><tbody><tr><td><p>Name: {CLIENT_NAME}<br>Contact Data: {ADDRESS_LINE_1}, {ADDRESS_POSTCODE}, {ADDRESS_CITY}, Phone: {MOBILE_NUMBER}<br>Identification: ID Number: {ID_DOCUMENT_NUMBER}, ID Type: {ID_DOCUMENT_TYPE}</p></td><td><p>Product: {ACCOUNT_NAME}<br>Account ID: {ACCOUNT_ID}<br><br></p></td></tr></tbody></table>

<p><br></p><p><br></p><div><br></div>

<table style="height: 95px; border-color: #000000; float: left;" border="#000000" width="80%">

<tbody>

<tr>

<td><b>Transaction Date</b></td>

<td><b>Transaction ID</b></td>

<td><b>Transaction Type</b></td>

<td><b>Debit Amount</b></td>

<td><b>Credit Amount</b></td>

<td><b>Balance&nbsp;</b>{START_STATEMENT}</td>

</tr>

<tr>

<td>{TRANSACTION_DATE}</td>

<td>{TRANSACTION_ID}</td>

<td>{TRANSACTION_TYPE}</td>

<td>FORMAT{DEBIT_AMOUNT,numericPattern=#,###.##}</td>

<td>FORMAT{CREDIT_AMOUNT,numericPattern=#,###.##}</td>

<td>FORMAT{AVAILABLE_BALANCE,numericPattern=#,###.##}<br>{END_STATEMENT}</td>

</tr>

</tbody>

</table>

<p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>

will produce a statement like this:

Statement template for regular checking

Example of account statement

Please be Aware
Amount placeholders will represent the absolute numeric value upon document generation (no negative/positive representation) but you can use transaction type to differentiate between deposits, withdrawals, and other fees and charges.
Please Note
For the complete list of the currently available placeholders for document templates as well as communications templates, please download the following Placeholder Matrix file .

Contracts and receipts for groups

Some placeholders can be combined with numbers to retrieve information from each member of a group. Following the syntax {PLACEHODER:X} where X means the group member number.

For example, for the client name field, {CLIENT_NAME:1} ; {CLIENT_NAME:2} ; {CLIENT_NAME:3} could be added, displaying the name of the first, second, and third client.

Placeholders that can be used with the syntax above:

  • {CLIENT_NAME}
  • {CLIENT_ID}
  • {ID_DOCUMENT_TYPE}
  • {ID_DOCUMENT_NUMBER}
  • {ID_DOCUMENT_EXPIRY_DATE}
  • {MOBILE_NUMBER}
  • {HOME_NUMBER}
  • {TRANCHE_NUMBER}
  • {TRANCHE_AMOUNT}
  • {ANTICIPATED_DISBURSAL_DATE}

The INTEREST_TIER_RATE placeholder can also be used with numbers using the following syntax:

  • Tier 1 Interest Rate: {INTEREST_TIER_RATE:1,numericPattern=#,###.##}
  • Tier 2 Interest Rate: {INTEREST_TIER_RATE:2,numericPattern=#,###.##}
Please Note
The numbers added to the placeholder should start with "1" and go up to the maximum number of members in a group.

Formatting numbers

In many jurisdictions, for legal reasons, contracts and other documents need to specify amounts in numeric and written form for example the value GBP120.25 would also need to be written out as "One hundred and twenty pounds sterling and twenty five pence".

Mambu can automatically convert numeric values into words in the following languages: English, Spanish, and Chinese.

Placeholders are available for use in both document and notification templates.

Please Note
The numeric placeholders will be converted to words in the language of the current user viewing the document.

Options

After selecting a placeholder, you will be able to select one of the following:

Display Option Output
Formatted Number 1,250.25
Unformatted Number 1.250
Integer in Words one hundred twenty
Fractional in Words twenty five
Tenths in Words two
Hundredths in Words five

Placeholder type that can be Formatted Number,  Unformatted Number, Integer in Words, Fractional in Words, Tenths in Words, Hundredths in Words

Currency

The currency symbol can be included as either its symbol (eg. $, £, €) or currency code (eg. USD, GBP, EUR). The placeholders for these are {ACCOUNT_CURRENCY_SIGN} and {ACCOUNT_CURRENCY_CODE} respectively.

If you need to include the currency as words in your templates (eg. United States dollars, pound sterling, euros), this can be achieved by adding a custom field to your accounts with the desired text (for example currency in words) and including it in templates using the specific placeholder (eg. {CF:LOAN:CURRENCY IN WORDS}. For more information, see Custom Fields.

Please Note
We recommend making this field a required selection box if you work in multiple currencies so as to avoid possible human error when adding this to accounts.

Formatting Dates

For any placeholders which provide a date or date and time you can alter the pattern used to reflect the legal and cultural expectations of your region using the letters d for day, M for month, y for year, h for hour, m for minute and s for second. For clarity a few examples are given in the table below:

Placeholder Generated output
FORMAT_DATE{CURRENT_DATE,datePattern=dd/MM/yyyy} 29/02/2020
FORMAT_DATE{CURRENT_DATE,datePattern=MM-dd-yy} 02-29-20
FORMAT_DATE{CURRENT_DATE_TIME,datePattern=yyyy-MM-dd hh:mm:ss} 2020-02-29 02:54:03

The date and time used will be in the local time as configured in Administration > General Setup > Organization Details.


Was This Article Helpful?