While creating date templates, emails/letters, and email/letter templates you will utilize merge field codes to pull the correct information from the transaction. In this article, it will explain how to use merge field codes and provide merge field code lists.
NOTE: letter case IS important in the code to pull/reference the correct information!
TABLE OF CONTENTS
- Using Merge Field Codes
- Default Date Merge Field Codes
- User Role Merge Field Codes
- Participant Role Merge Field Codes
- Transaction Merge Field Codes
- General Merge Field Codes
Using Merge Field Codes
Emails
When creating an email, using merge field codes can save a lot of time and effort. Merge field codes allow you to personalize the email by automatically populating information into the email. To use merge field codes, simply insert them into the email template or email directly & it will populate the information specific to the transaction or contacts you are creating the email for. The merge field codes can pull different information, such as contact information, transaction date template dates, transaction information cells, and auto-attach attachments. For AFrame merge field codes, use the format: $CustomMergeCode.
Related Articles: Email/Letter Templates, Email Tab
Dates
Each date entry has a custom merge field code associated with it. With this code, you can define what it will be and you can reference it in email templates or even use it within due date formulas for other date entries or tasks.
Related Articles: Date Templates, Dates Tab
Tasks
When creating tasks there are two options for due dates: no due date or due date formulas. When choosing the due date formula you have the option to select a referenced date. The reference date is a date entry or standard date (such as list date, effective date, template start date, closing date, or any custom date made) that will have its unique merge field code associated with it.
Related Articles: Task Templates, Task Tab
Attachments
Each attachment entry has a unique custom merge field code associated with it. This code allows you to define a placeholder for the attachment and reference it within email templates. When you include the merge field in an email template, the corresponding file will automatically be attached, as long as a file has been uploaded to that specific placeholder. This streamlines the process and ensures relevant documents are included in communications.
Related Articles: Attachment Templates, Attachments Tab
Default Date Merge Field Codes
These are the date entries in the default date template for each account. You can always create custom dates with their own custom merge field codes within the date templates. There are optional suffixes for the date merge field codes to help with more conversational formats for emails.
Standard Transaction Dates | |
---|---|
Date | Merge Code |
List Date | $ListDate |
On Market Date | $OnMarketDate |
Expire Date | $ExpireDate |
Effective Date | $EffectiveDate |
Closing Date | $ClosingDate |
Contract Date Template | |
---|---|
Date | Merge Code |
Earnest Money Due | $EarnestMoneyDue |
Inspection Period | $InspectionPeriod |
Survey Date | $SurveyDate |
Finance Date | $FinanceDate |
Title Date | $TitleDate |
Possession Date | $PossessionDate |
ProTip: You can create multiple date templates in your account with custom dates to apply to your transactions, which is beneficial when you cover multiple states/areas with different contract dates. You can learn more with our Date Templates article.
Optional Suffixes for Date Merge Codes (above chart) | ||
---|---|---|
Data | Suffix On Merge Code | Format |
No Suffix | Sep 23, 2023 (Sat) from 9:00 am - 12:00 pm | |
Due Date Formula | -Formula | 7 Calendar Days |
Starting Date | -StartDate | Sep 8, 2023 (Fri) |
Starting Date Order | -StartDateOrd | Friday, September 8th |
Starting Time | -StartTime | 9:00 AM |
User Role Merge Field Codes
Add the Prefix (including -) and Suffix together to pull the correct information (i.e. $UserAssistant1-FirstName)
Prefix | Suffix | ||
---|---|---|---|
User Role | Merge Code | Data Reference | Merge Code |
Primary Agent | $UserPrimaryAgent- | First Name | FirstName |
Co-Agent | $UserCoAgent- | Last Name | LastName |
TC/Assistant 1 | $UserAssistant1- | Full Name | FullName |
TC/Assistant 2 | $UserAssistant2- | Mobile | Mobile |
Portal Link | PortalLink | ||
All Info Card | Card |
Participant Role Merge Field Codes
Add the Prefix (including -) and Suffix together to pull the correct information (i.e. $UserAssistant1-FirstName). You can add custom participant roles with their own custom Merge Field Code Prefixes under Admin > Lists > Transactions Participant Roles.
Participant Lists | |
---|---|
Data | Merge Code |
All Participants | $TransactionParticipants |
Agent Portal Visible Participants | $TransactionParticipants-AgentPortal |
Buyer/Seller Portal Visible Participants | $TransactionParticipants-BuyerSellerPortal |
All Participants + Agent/TC Roles | $TransactionParticipantsAndUsers |
Agent Portal Visible Participants + Agent/TC Roles | $TransactionParticipantsAndUsers-AgentPortal |
Buyer/Seller Portal Visible Participants + Agent/TC Roles | $TransactionParticipantsAndUsers-BuyerSellerPortal |
Prefix | Suffix | ||
---|---|---|---|
Participant Role | Merge Code | Data Reference | Merge Code |
Buyer | $Buyer- | First Name | FirstName |
Seller | $Seller- | Last Name | LastName |
Primary Agent | $UserPrimaryAgent- | Full Name | FullName |
Agent (Other Side) | $AgentOtherSide- | Spouse First Name | SpouseFirstName |
TC/Assistant 1 | $UserAssistant1- | Spouse Last Name | SpouseLastName |
TC/Assistant 2 | $UserAssistant2- | Spouse Full Name | SpouseFullName |
Closer | $Closer- | First Names | FirstNames |
Closer (Other Side) | $CloserOtherSide- | Last Names | LastNames |
Attorney | $Attorney- | Full Names | FullNames |
Attorney (Other Side) | $AttorneyOtherSide- | Phone | Phone1 |
Lender | $Lender- | Spouse Phone | SpousePhone1 |
Lender (Other Side) | $LenderOtherSide- | ||
Inspector | $Inspector- | Spouse Email | SpouseEmail |
Surveyor | $Surveyor- | All Emails | AllEmails |
Brokerage | BrokerName | ||
All Contact Info | Card | ||
Salutation Letter | SalutationLtr | ||
Salutation Envelope | SalutationEnv | ||
Mailing Full Address | FullMailingAddress | ||
Mailing Street Address | MailingAddress | ||
Mailing Address - City, State, Zip | MailingCSZ |
Note: You can customize your list of transaction participant roles under Admin > Lists > Transactions > Participant Roles.
Related Articles: Lists :: Participant Roles
Transaction Merge Field Codes
These merge codes will pull the data from the transaction.
General Field Codes | |
---|---|
Data | Merge Code |
Transaction Side | $TransactionSide |
Contract Price | $ContractPrice |
List Price | $ListPrice |
Property Full Address | $PropertyFullAddress |
Property Street Address | $PropertyAddress |
Property Address - City, State, Zip | $PropertyCSZ |
Transaction Dates | $TransactionEvents |
Dates Visible in Agent Portal | $TransactionEvents-AgentPortal |
Dates Visible in Buyer/Seller Portal | $TransactionEvents-BuyerSellerPortal |
Information Sidebar Field Codes | ||||
---|---|---|---|---|
Collection | Group | Field | ||
Name | Merge Code | Name | Merge Code | |
Transaction Info | Listing Details | $fg_ListingDetails | MLS Id | $f_MlsId |
Lockbox Id | $f_LockboxId | |||
Lockbox Info | $f_LockboxInfo | |||
Security | $f_Security | |||
Occupancy | $f_Occupancy | |||
Remarks | $f_Remarks | |||
Instructions | $f_Instructions | |||
Listing Other Info | $f_ListingOtherInfo | |||
Transaction Source | $f_TransactionSource | |||
Property Details | $fg_PropertyDetails | Property Type | $f_PropertyType | |
Subdivision | $f_Subdivision | |||
County | $f_County | |||
Tax Id | $f_TaxId | |||
Beds | $f_Beds | |||
Baths | $f_Baths | |||
Year Built | $f_YearBuilt | |||
Sqft | $f_Sqft | |||
Sqft Source | $f_Sqft | |||
Lot Desc | $f_LotDesc | |||
Schools | $f_Schools | |||
HOA Info | $fg_HOAInfo | HOA Fee | $f_HOAFee | |
HOA Frequency | $f_HOAFrequency | |||
Contract Info | Contract Details | $fg_ContractDetails | Escrow Number | $f_EscrowNumber |
Earnest Money | $f_EarnestMoney | |||
Due Diligence Fee | $f_DueDiligenceFee | |||
Other Party | $f_OtherParty | |||
Financing | $f_Financing | |||
Concessions | $f_Concessions | |||
Special Provisions | $f_SpecialProvisions | |||
Possession | $f_Possession | |||
Contract Other Info | $f_ContractOtherInfo | |||
Commission Note | $f_CommissionNote |
Note: You can customize your Information Fields area by moveing or adding more custom fields. You can learn more with our Field Definitions Templates article.
Payout | |
---|---|
Data | Merge Code |
Commission Percentage | $PercentageCommission |
Referral Payout | $ReferralPayout |
Actual Payout | $ActualPayout |
Broker Payout | $BrokerPayout |
Broker Payable | $BrokerPayable |
Team Lead Payout | $TeamLeadPayout |
Team Lead Payable | $TeamLeadPayable |
Primary Agent Payout | $PrimaryAgentPayout |
Primary Agent Payable | $PrimaryAgentPayable |
Co-Agent Payout | $CoAgentPayout |
Co-Agent Payable | $CoAgentPayable |
Assistant 1 Payout | $Assistant1Payout |
Assistant 1 Payable | $Assistant1Payable |
Assistant 2 Payout | $Assistant2Payout |
Assistant 2 Payable | $Assistant2Payable |
Related Articles: Field Definitions Templates, Information Fields, Payout Tab
General Merge Field Codes
These general merge field codes can be used in emails or email templates.
Data | Merge Code | Note/Format |
---|---|---|
Company Name | $CompanyName | The AFrame account's company name |
Team Phone | $TeamPhone | The AFrame account's phone number |
Current Date | $CurrentDate | October 25, 2023 |
$CurrentDateLong | Wednesday, October 25, 2023 | |
$CurrentDateShort | 10/25/2023 | |
Managed Agent Portal | $ManagedAgentPortalLink | Main portal login URL. Agent specific portal can be searched by email. |
The use of these general merge field codes within emails or email templates will pull the available information that coordinates with the transaction side that you represent. For example: If you have a buyer side transaction, then the $FirstLastNames Merge Feild Code will pull the buyer(s) participant's first and last name(s) - John & Jane Smith.
Data | Merge Code | Format |
---|---|---|
First Name | $FirstName | John |
Last Name | $LastName | Smith |
First & Last Name | $FullName | John Smith |
First Names | $FirstNames | John, Jane |
First & Last Names | $FullNames | John Smith & Jane Smith |
Last Names | $LastNames | Smith / Doe & Smith |
Salutation Letter | $SalutationLtr | John & Jane |
Salutation Envelope | $SalutationEnv | John & Jane Smith |
Card | $Card | All contact info for main & partner |