Table of Contents
Email Variables & Conditions
Updated
by Morgan Wynnes
Read Time: 5 mins
Below are all of the available variables that can be used to display data within various areas of Sonar, or that can be used as part of a conditional statement. It is important to note that the variables that will be available to you will depend on where in Sonar you are accessing them from. For example, the variables available when creating a contract template will differ from the ones available when creating an email message for a particular trigger.
Temporary Workaround for Preserving Variables When Pasting into the Editor
Temporary Workaround:
1. Click the { } button within the text editor
2. Paste the content that contains variables
3. Click the { } button again
A
Variable | What It Displays | Where It's Accessible |
*|ACCOUNT_ADDRESS|* | Account address | |
*|ACCOUNT_NAME|* | Account name | |
*|ACCOUNT_NUMBER|* | Account number | Canned Replies, Contract Templates, Email Messages, Mass Email |
*|AMOUNT|* | Amount | |
*|AMOUNT_DUE|* | Amount due | |
*|AMOUNT_DUE_ON_INVOICE|* | Amount due on invoice | |
*|AMOUNT_DUE_ON_INVOICE_RAW|* | Unformatted total amount due on this invoice | |
*|AMOUNT_DUE_RAW|* | Unformatted amount due | |
*|AUTO_PAY_DATE|* | Autopay date | |
*|IF:AUTOPAY_ENABLED|* | CONDITION: Whether autopay is enabled or not | |
*|IF:AUTOPAY_RUNS_ENTIRE_AMOUNT_DUE|* | CONDITION: Whether or not autopay runs the entire amount due |
B
Variable | What It Displays | Where It's Accessible |
*|BAD_ITEMS|* | Inventory items that are in a "Down" or "Warning" state |
C
Variable | What It Displays | Where It's Accessible |
*|COMPANY_NAME|* | Company name | |
*|CONTACT_EMAIL_ADDRESS|* | Contact email address | |
*|CONTACT_NAME|* | Contact name | |
*|CONTACT_ROLE|* | Contact role | |
*|CONTRACT_SIGNING_URL|* | URL to sign contract | |
*|CUSTOM_MESSAGE|* | Custom message (i.e. contracts, invoices) | |
*|CUSTOMER_PORTAL_URL|* | Customer portal URL | |
*|IF:CUSTOMER_PORTAL_URL|* | CONDITION: If the customer portal is enabled in the instance |
D
Variable | What It Displays | Where It's Accessible |
*|DATE|* | Date |
E
Variable | What It Displays | Where It's Accessible |
*|EXPIRING_SERVICE_LIST|* | Expiring service list | |
*|EXPIRING_SERVICE_LIST_WITH_PRICES|* | Expiring service list with prices |
F
Variable | What It Displays | Where It's Accessible |
*|FLAPPING|* | Inventory items that are flapping | |
*|FNAME|* | First name |
G
Variable | What It Displays | Where It's Accessible |
*|GOOD_ITEMS|* | Inventory items that are healthy (in a "Good" state) |
I
Variable | What It Displays | Where It's Accessible |
*|INSTANCE_URL|* | Instance URL | |
*|INVOICE_DUE_DATE|* | Invoice due date | |
*|INVOICE_NUMBER|* | Invoice number |
J
Variable | What It Displays | Where It's Accessible |
*|JOB_SCHEDULED_DATETIME|* | Job scheduled date and time | |
*|JOB_TYPE|* | Job type |
L
Variable | What It Displays | Where It's Accessible |
*|LAST_4_DIGITS|* | Last 4 digits of payment method | |
*|LATE_FEE_AMOUNT|* | Late fee amount | |
*|LATE_FEE_AMOUNT_RAW|* | Unformatted late fee amount | |
*|LNAME|* | Last name |
N
Variable | What It Displays | Where It's Accessible |
*|NEXT_BILL_DATE|* | Next bill date |
P
Variable | What It Displays | Where It's Accessible |
*|PASSWORD_CREATION_TOKEN|* | Password creation token | |
*|PASSWORD_RESET_TOKEN|* | Password reset token | |
*|PHYSICAL_ADDRESS|* | Physical address |
R
Variable | What It Displays | Where It's Accessible |
*|RECURRING_SERVICE_LIST|* | Recurring service list | |
*|RECURRING_SERVICE_LIST_WITH_PRICES|* | Recurring service list with prices |
S
Variable | What It Displays | Where It's Accessible |
*|STILL_FLAPPING|* | Inventory items that are still flapping |
T
Variable | What It Displays | Where It's Accessible |
*|TOTAL_AMOUNT_DUE_PRIOR_INCLUDING_THIS_INVOICE|* | Total amount due prior to and including this invoice | |
*|TOTAL_AMOUNT_DUE_PRIOR_INCLUDING_THIS_INVOICE_RAW|* | Unformatted total amount due prior to and including this invoice |
U
Variable | What It Displays | Where It's Accessible |
*|USAGE_CAP_IN_GIGABYTES|* | Usage cap in gigabytes | |
*|USAGE_IN_GIGABYTES|* | Usage in gigabytes | |
*|USER_EMAIL_ADDRESS|* | User email address | |
*|USER_IS_SUPER_ADMIN|* | User is a super admin | |
*|USER_LANGUAGE|* | User language | |
*|USER_MOBILE_NUMBER|* | User mobile phone number | |
*|USER_REAL_NAME|* | User real name | |
*|USER_ROLE_ID|* | User role ID | |
*|USER_USERNAME|* | User username |
