Which variables are available for the templates?

Back to the homepage

Which variables are available for the templates?

Standardised texts that you would like to send as e-mails or letters can be created with templates in the FundraisingBox. With the help of variables automatic individualisation of the texts can be realised. In this way you can, for example, personally speak to your donors without extra manual effort.

Choosing variables

If you would like to use variables, then click on the "show available variables for the subject line and text" link. Afterwards a box with the available variables and some examples will open. To add a variable to the current place of your text, simply click on the desired variable. If you wish to use a variable in the subject line, please type this in by hand.

Available variables
The following person -variables are available::

  • {{salutation}} Salutation of the donor, values: Mr. / Mrs. / diverse/ couple / family
  • {{salutation_de}} German salutation of the donor, values: Herr / Frau / Divers / Ehepaar / Familie
  • {{title}} Official title of the donor
  • {{first_name}} First name of the donor
  • {{last_name}} Last name of the donor
  • {{company_name}} Name of the company
  • {{full_name}} Complete name of the donor, example: "Mr. Dr. John Doe" or "Example Company"
  • {{greeting}} Individual greeting of the donor, that you have defined in the FundraisingBox (only applies to already existing contacts)
  • {{formal_greeting_de}} Formal German greeting format, Example: "Sehr geehrter Herr Dr. Mustermann", for companies: "Sehr geehrte Damen und Herren"
  • {{person_id}}  ID of the person in the FundraisingBox
  • {{external_person_id}}  external (individual) ID of the person
  • {{wants_newsletter}} Value of the setting "Wants newsletter", values: 0 (= no) / 1 (= yes)
  • {{address}} Adress (street etc.) taken from the contact's main address
  • {{postcode}} Postcode taken from the contact's main address
  • {{city}} City taken from the contact's main address
  • {{country}} Country code (e.g. "DE" for Germany) taken from the contact's main address
  • {{country_de}} Country name in German taken from the contact's main address
  • {{email}} Main e-mail address of the contact
  • {{donation_count}} Number of donations from the contact
  • {{active_recurring_count}} Number of active standing orders
  • {{person_custom_field_*ID*}} Value of the user-defined field. Instead of *ID*, the ID of the desired field must be used, e.g. {{person_custom_field_1234}}. The IDs can be found under Settings > User-Defined Fields.

Please note: for companies, salutation, title, first and last name are all empty.

  For transaction -variables the following are available in addition to the person-variable:

  • {{amount}} Amount WITHOUT currency symbol in standard format, example: 1234.5
  • {{amount_de}} Amount WITHOUT currency symbol with comma and two decimal places, example: 1234,50
  • {{amount_en}}  Amount WITHOUT currency symbol with a period and two decimal places, example: 1234.50
  • {{item_id}} ID of the item to which the donation was made. The IDs to your items can be found under Settings > Donation Form > Button-Generator in item dropdown.
  • {{item_name}} Name of the item in your FundraisingBox to which the donation was made.
  • {{project_description}} Description of the project to which the donation was made. The description of your projects can be found under Settings > Projects
  • {{project_id}} ID of the project to which the donation was made. The IDs for your projects can be found under Settings > Projects
  • {{project_name}} Name of the project in your FundraisingBox to which the donation was made.
  • {{type_id}} ID of the payment method that was used for the donation:
    3 = PayPal
    5 = Sofort Online Banking
    8 = Manual SEPA Direct Debit
    11 = EPS-Bank Transfer
    The IDs of your individual donation types can be found under Settings > Donation Types.
  • {{receipt_status}} Values: no_receipt / receipt_now / receipt_end_of_year / receipt_never
  • {{receipt_status_de}} German values: Nein / Ja / Am Jahresende / Niemals
  • {{interval}} Monthly-rhythm of the standing order, values: 0 / 1 / 3 / 6 / 12
  • {{interval_de}} German values of the monthly-rhythm, values: einmalig / monatlich / vierteljährlich / halbjährlich / jährlich
  • {{is_recurring}} displays 0 for one-time donations, otherwise 1
  • {{donation_custom_field_*ID*}} Value of the user-defined field. Instead of *ID*, the ID of the desired field must be used, e.g. {{donation_custom_field_1234}}. The IDs can be found under Settings > User-Defined Fields.
  • {{donation_date_day}} Values: 1-31, Example: Donation on 23.10. => Day on which the donation was made = 23
  • {{donation_date_month}} Values: 1-12, Example: Donation on 23.10. => Month in which the donation was made = 10
  • {{donation_date_year}} Year in which the donation was made, example: 2017
  • {{donation_date}} Date on which the donation was made in the format YYYY-MM-DD
  • {{donation_date_de}}  Date on which the donation was made in the format DD-MM-YYYY
  • {{donation_date_en}}  Date on which the donation was made in the format: 10 October 2019
  • {{device_type}}  The device used for the online donation. Values: unknown / mobile / tablet / desktop
  • {{wikando_direct_debit_pay_date}}  Example: 2019-03-11
  • {{wikando_direct_debit_pay_date_de}}  Example: 11.03.2019
  • {{wikando_direct_debit_pay_date_en}}  Example: 11 March 2019
  • {{sepa_creditor_id}}
  • {{sepa_mandate_reference_id}}
  • {{sepa_mandate_link}}  public Download-Link for the SEPA Mandate
  • {{sepa_mandate_iban}}
  • {{sepa_mandate_iban_shortend}}  the last 5 digits of the IBAN are replaced with X
  • {{sepa_mandate_bic}}
  • {{sepa_mandate_status}} Values: active / pending / cancelled
  • {{public_name}}  public name
  • {{public_message}}  public messeage/comment
  • {{fundraising_page_title}} Title of the fundraising campaign page

For standing order -variables the following are available in addition to the person-variable:

  • {{amount}} Amount WITHOUT currency symbol in standard format, example: 1234.5
  • {{amount_de}} Amount WITHOUT currency symbol with comma and two decimal places, example: 1234,50
  • {{amount_en}}  Amount WITHOUT currency symbol with a period and two decimal places, example: 1234.50
  • {{project_description}} Description of the project to which the donation was made. The description of your projects can be found under Settings > Projects
  • {{project_id}} ID of the project to which the donation was made. The IDs for your projects can be found under Settings > Projects
  • {{project_name}} Name of the project in your FundraisingBox to which the donation was made.
  • {{type_id}} ID of the payment method that was used for the donation:
    3 = PayPal
    5 = Sofort Online Banking
    8 = Manual SEPA Direct Debit
    11 = EPS-Bank Transfer
    The IDs of your individual donation types can be found under Settings > Donation Types.
  • {{receipt_status}} Values: no_receipt / receipt_now / receipt_end_of_year / receipt_never
  • {{receipt_status_de}} German values: Nein / Ja / Am Jahresende / Niemals
  • {{interval}} Monthly-rhythm of the standing order, values: 0 / 1 / 3 / 6 / 12
  • {{interval_de}} German values of the monthly-rhythm, values: einmalig / monatlich / vierteljährlich / halbjährlich / jährlich
  • {{donation_custom_field_*ID*}} Value of the user-defined field. Instead of *ID*, the ID of the desired field must be used, e.g. {{donation_custom_field_1234}}. The IDs can be found under Settings > User-Defined Fields.
  • {{next_payment_date}} Next appointment of the standing order in the format YYYY-MM-DD
  • {{next_payment_date_de}}  Next appointment of the standing order in the format DD.MM.YYYY
  • {{next_payment_date_day}} Day of the next appointment of the standing order, example 01, 02, ..., 10, 11
  • {{next_payment_date_month}} Month of the next appointment of the standing order, example 01, 02, ..., 10, 11
  • {{next_payment_date_year}} Year of the next appointment of the standing order (four-digits)
  • {{end_date}} End date of the standing order in the format YYYY-MM-DD
  • {{end_date_de}}  End date of the standing order in the format DD.MM.YYYY
  • {{sepa_creditor_id}}
  • {{sepa_mandate_reference_id}}
  • {{sepa_mandate_link}} öffentlicher Download-Link für das SEPA-Mandat
  • {{sepa_mandate_iban}}
  • {{sepa_mandate_iban_shortend}} die letzten 5 Zeichen werden durch X ersetzt
  • {{sepa_mandate_bic}}
  • {{sepa_mandate_status}} Werte: active / pending / cancelled

For SEPA-mandate -variables the following are available in addition to the person-variable:

  • { {sepa_creditor_id}}
  • {{sepa_mandate_reference_id}}
  • {{sepa_mandate_link}} Public download-link for the SEPA mandate
  • {{sepa_mandate_iban}}
  • {{sepa_mandate_iban_shortend}} The last 5 characters are replaced with X
  • {{sepa_mandate_bic}}
  • {{sepa_mandate_status}} Values: active / pending / cancelled

For  donation receipt -variables the following are available in addition to the person-variable:

  • {{receipt_amount}} Amount WITHOUT currency symbol in standard format, example: 1234.5
  • {{receipt_amount_de}}  Amount WITHOUT currency symbol with period as separator, comma and two decimal places, example: 1.234,50
  • {{receipt_amount_en}} Amount WITHOUT currency symbol with comma as separator, period and two decimal places, example: 1,234.50
  • {{receipt_link}} public download-link for the donation receipt
  • {{receipt_type}} Values: single / multi
  • {{receipt_donation_date_de}} vDepending on the settings either the "Transacted-on-date" or the "Received-on-date" of the donation in the format DD.MM.YYYY

For fundraising campaign -variables the following are available in addition to the person-variable:

  • {{expires_at}} End date in the format YYYY-MM-DD
  • {{expires_at_de}} End date in the format DD-MM-YYYY
  • {{fundraiser_name}} Name of the campaign starter
  • {{fundraising_page_title}} Title of the fundraising campaign
  • {{description}} Description of the fundraising campaign
  • {{days_left}} Days left until the end of the campaign
  • {{link}} Link to the campaign
  • {{admin_link}} Secret editing link
  • {{project_id}} ID of the project to which the donations were made. The IDs of your projects can be found under Settings > Projects
  • {{project_name}} Name of the project to which the donations were made.
  • {{project_description}} Description of the project in the FundraisingBox to which the donations were made.
  • {{category}} Category of the campaign. Values: personal, sports, creative, business, memorial
  • {{has_image}} Campaign with its own image. Values: Nein / Ja
  • {{goal}} Donation goal WITHOUT currency symbol in standard format, example: 1234.5
  • {{goal_de}} Donation goal WITHOUT currency symbol with comma and two decimal places, example: 1234,50
  • {{received}} Currently received donation amount WITHOUT currency symbol in standard format, example: 1234.5
  • {{received_de}}  Currently received donation amount WITHOUT currency symbol with comma and two decimal places, example: 1234,50
  • {{organisation_name}} Name of your own organisation

For document -variables the following are available in addition to the according object-variables:

  • {{page_break}} Creates a page break
  • {{signature}} Adds the previously uploaded digital signature into the document
  • {{receipt_donations_table_de}} List of the individual contributions in a collective donations receipt in German
  • {{receipt_donations_table_en}}  List of the individual contributions in a collective donations receipt in English
  • {{receipt_donations_table_stiftung_de}} List of the individual contributions in a collective donation receipt from a foundation in German
  • {{receipt_donations_table_stiftung_en}}  List of the individual contributions in a collective donation receipt from a foundation in English
  • {{receipt_number}} Sequential donation receipt number
  • {{current_date}} Current date in the format YYYY-MM-DD
  • {{current_date_de}} Current date in the format DD.MM.YYYY
  • {{current_day}} Current day, example 01, 02, ..., 10, 11
  • {{current_month}} Current month, example 01, 02, ..., 10, 11
  • {{current_year}} Current year (four-digit)

Control structures
You also have the possibility to handle various special cases with the help of IF/ELSE instructions.

Example for an individual salutation:

{% if company_name != "" %}
Dear sir or madam,
{% elseif salutation_de == "Mrs." %}
Dear {{first_name}} {{last_name}},
{% elseif salutation_de == "Mr." %}
Dear {{first_name}} {{last_name}},
{% elseif salutation_de == "Couple" %}
Dear mr. and mrs. {{last_name}},
{% endif %}


Example for amount request:

{% if amount >= 1000 %}
As a major donor you will receive a small gift in the coming days as a thank you for your support.
{% endif %}


Important: For the amount request you ust use amount and not amount_de.

Everything else can be implemented using AND/OR-logical operations including bracketing.

Example for item request:

{% if item_id == 1234 or item_id == 5678 %}
Thank you very much for ...
{% endif %}


Example with bracketing:

{% if amount >= 100 and (item_id == 1234 or item_id == 5678) %}
Thank you very much for ...
{% endif %}

Export to PDF