Acoustic Campaign Ideas

The Acoustic Ideas portal has moved! Please sign up for our new Ideas portal and submit your suggestions at

Give a format field into personalization

Currently the there is possible to user "format field" olny in english format, i mean Dates and some numeric format. But it is necesary to add international currency format. Today all that use ###.###,## need to have 2 fields. One numerci currency to filter or personalization criteria and other one to use like personalization field (PE: limit of the Credit Card or Max Loan offer)

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jun 25 2018
  • Needs More Information
How will this idea be used?

It used to create emails, SMS and Push without necesary to upload more fields for personalization only (duplpicate field)

What is your industry? Professional Services
What is the idea priority? High
DeveloperWorks ID
Link to original RFE
  • Attach files
  • Admin
    Beth White commented
    July 02, 2018 20:00

    Can you clarify what you mean? You want to add personalization, but not tie it to a database field?

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    July 03, 2018 14:18

    WCA allow to add personalization into a template:

    This allow to personalize Dates and Numbers (as Currency), but only work with dot as decimal separator (and period as thousands)

    As you can see in Countries using Arabic numerals with decimal comma in there are many countries that use a comma as decimal separator (and point for thousands).

    Into the first URL: For example, if your database has a custom column "RAND", you can add %%format(RAND, "#,###.00")%% to get the correct currency format in the email body. But this example only work with this format, IF I try "#.###,00" I get an error.

    Because that, today, all countries that use a comma as Decimal Separator, we need to upload 2 fields that represent a currency. First one to use as critera from Query or Rule Builder (to use numerical criteria like "between") and other as Text with the local currency format to use to personalize a loan offer for example.

  • Admin
    Beth White commented
    July 03, 2018 15:13

    Thank you for the clarification. Yes- date and currency personalization can happen so you can have a comma separator.  You can change the format of the dates and  currency to display as you see fit.

    This exists today.  For example if I store in the database a USD currency $1,000.00 and I want it displayed as $1,000,00 - you can transform the data format in the email body only.

    You create a new database field with the date/currency format that you contact prefers- then you reference both fields to personalize the date/ currency as you see fit.

    See this article for initial guidance:

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    July 03, 2018 15:24


    Thanks, but I think that is not working well
    As I told you when I try #.###,00 I get an error.
    Maybe the problem is not the decimal comma separator, but that the point on thousands separator.
    If you wan I can try trough technical support.

    ■ Diego de Arriandiaga
    Preventa de Soluciones

    Smart Business Solutions S.A.
    Montañeses 2180, 4º piso • C1428AQH • Ciudad de Buenos Aires • Argentina. • • +54 (11) 4784-2001 Int. 20
    En BeSmart cuidamos el medio ambiente, te pedimos que pienses antes de imprimir este email.
    De: IBM Watson Customer Engagement <>
    Enviado el: martes, 3 de julio de 2018 12:15
    Para: Diego de Arriandiaga
    Asunto: Beth White responded to idea WCAIDEAS-I-50 Give a format field into personalization

  • Admin
    Beth White commented
    July 03, 2018 15:32

    If you have the data field present with the correct format- and referencing both fields in the email body-  format should work.  I would escalate this with customer support.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    July 04, 2018 00:43

    Yes please, I open a case a ong time ago 00617173 in this, representative told me that this functionallity is only for dates.... I discuss with him, but no have any response. As I told you, when I try to format like #.###.###,00 I get an error into the test view and get the "formula" if I sent the email