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 | Contract Templates |
*|ACCOUNT_NAME|* | Account name | Canned Replies, Contract Templates, Email Messages |
*|ACCOUNT_NUMBER|* | Account number | Canned Replies, Contract Templates, Email Messages, Mass Email |
*|AMOUNT|* | Amount | Email Messages |
*|AMOUNT_DUE|* | Amount due | Canned Replies, Email Messages, Mass Email |
*|AMOUNT_DUE_ON_INVOICE|* | Amount due on invoice | Email Messages |
*|AMOUNT_DUE_ON_INVOICE_RAW|* | Unformatted total amount due on this invoice | Email Messages |
*|AMOUNT_DUE_RAW|* | Unformatted amount due | Email Messages |
*|AUTO_PAY_DATE|* | Autopay date | Email Messages |
*|IF:AUTOPAY_ENABLED|* | CONDITION: Whether autopay is enabled or not | Email Messages, Mass Email |
*|IF:AUTOPAY_RUNS_ENTIRE_AMOUNT_DUE|* | CONDITION: Whether or not autopay runs the entire amount due | Email Messages |
B
Variable | What It Displays | Where It's Accessible |
*|BAD_ITEMS|* | Inventory items that are in a "Down" or "Warning" state | Email Messages |
C
Variable | What It Displays | Where It's Accessible |
*|COMPANY_NAME|* | Company name | Email Messages, Mass Email |
*|CONTACT_EMAIL_ADDRESS|* | Contact email address | Email Messages |
*|CONTACT_NAME|* | Contact name | Contract Templates, Email Messages, Mass Email |
*|CONTACT_ROLE|* | Contact role | Email Messages |
*|CONTRACT_SIGNING_URL|* | URL to sign contract | Email Messages |
*|CUSTOM_MESSAGE|* | Custom message (i.e. contracts, invoices) | Email Messages |
*|CUSTOMER_PORTAL_URL|* | Customer portal URL | Email Messages |
*|IF:CUSTOMER_PORTAL_URL|* | CONDITION: If the customer portal is enabled in the instance | Email Messages |
D
Variable | What It Displays | Where It's Accessible |
*|DATE|* | Date | Contract Templates |
E
Variable | What It Displays | Where It's Accessible |
*|EXPIRING_SERVICE_LIST|* | Expiring service list | Contract Templates |
*|EXPIRING_SERVICE_LIST_WITH_PRICES|* | Expiring service list with prices | Contract Templates |
F
Variable | What It Displays | Where It's Accessible |
*|FLAPPING|* | Inventory items that are flapping | Email Messages |
*|FNAME|* | First name | Contract Templates, Mass Email |
G
Variable | What It Displays | Where It's Accessible |
*|GOOD_ITEMS|* | Inventory items that are healthy (in a "Good" state) | Email Messages |
I
Variable | What It Displays | Where It's Accessible |
*|INSTANCE_URL|* | Instance URL | Email Messages |
*|INVOICE_DUE_DATE|* | Invoice due date | Email Messages |
*|INVOICE_NUMBER|* | Invoice number | Email Messages |
J
Variable | What It Displays | Where It's Accessible |
*|JOB_SCHEDULED_DATETIME|* | Job scheduled date and time | Email Messages |
*|JOB_TYPE|* | Job type | Email Messages |
L
Variable | What It Displays | Where It's Accessible |
*|LAST_4_DIGITS|* | Last 4 digits of payment method | Email Messages |
*|LATE_FEE_AMOUNT|* | Late fee amount | Email Messages |
*|LATE_FEE_AMOUNT_RAW|* | Unformatted late fee amount | Email Messages |
*|LNAME|* | Last name | Contract Templates, Mass Email |
N
Variable | What It Displays | Where It's Accessible |
*|NEXT_BILL_DATE|* | Next bill date | Email Messages |
P
Variable | What It Displays | Where It's Accessible |
*|PASSWORD_CREATION_TOKEN|* | Password creation token | Email Messages |
*|PASSWORD_RESET_TOKEN|* | Password reset token | Email Messages |
*|PHYSICAL_ADDRESS|* | Physical address | Canned Replies |
R
Variable | What It Displays | Where It's Accessible |
*|RECURRING_SERVICE_LIST|* | Recurring service list | Contract Templates |
*|RECURRING_SERVICE_LIST_WITH_PRICES|* | Recurring service list with prices | Contract Templates |
S
Variable | What It Displays | Where It's Accessible |
*|STILL_FLAPPING|* | Inventory items that are still flapping | Email Messages |
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 | Email Messages |
*|TOTAL_AMOUNT_DUE_PRIOR_INCLUDING_THIS_INVOICE_RAW|* | Unformatted total amount due prior to and including this invoice | Email Messages |
U
Variable | What It Displays | Where It's Accessible |
*|USAGE_CAP_IN_GIGABYTES|* | Usage cap in gigabytes | Canned Replies |
*|USAGE_IN_GIGABYTES|* | Usage in gigabytes | Canned Replies |
*|USER_EMAIL_ADDRESS|* | User email address | Email Messages |
*|USER_IS_SUPER_ADMIN|* | User is a super admin | Email Messages |
*|USER_LANGUAGE|* | User language | Email Messages |
*|USER_MOBILE_NUMBER|* | User mobile phone number | Email Messages |
*|USER_REAL_NAME|* | User real name | Email Messages |
*|USER_ROLE_ID|* | User role ID | Email Messages |
*|USER_USERNAME|* | User username | Email Messages |
