QWILR
Salesforce Fields
Introduction to Variable Fields
Variable fields allow you to have replaceable sections within templates.
This means that you don't have to manually replace things like CUSTOMER NAME or ADDRESS every time you create a new Quote, Proposal, Report or any other type of document.
For both the Salesforce integration and the BluePrint API we use the standard of wrapping the relevant variable in two curly brackets (AKA braces) - which are: {{}}
Variables in Salesforce
The section that you set up Qwilr into will make a big impact on how you need to structure your variables.
For example, if you set up Qwilr inside Opportunities Object (as is common) all of the Opportunities variables are accessible directly. However, to use associated variables you will have to direct Qwilr towards the relevant Object.
So direct links to native Opportunities data will work - such as:
{{Amount}}
{{CloseDate}}
{{Description}}
{{FiscalYear}}
{{LastActivityDate}}
To link to other areas you will need to direct them via {{Object.Name}} - such as:
Company Name = {{Account.Name}}
Company website = {{Account.Website}}
Sales Rep Name = {{Owner.Name}}
Sales Rep Email = {{Owner.Email}}
This can go as deep as needed - for example:
{{Account.Owner.Contact.Name}}
Other Important Notes
Any variable that does not have any relevant information is automatically defaulted to a blank.
All variable fields are case sensitive.
We have compiled a list of the more common standard Salesforce fields that you might find useful in building your templates.
For more information please see our Help Center, or reach out to a member of our team via [email protected]
Opportunities
Below is a list of commonly used fields in Salesforce's Opportunities object.
Custom fields are always in the format of the field name followed by a double underscore and lowercase c at the end - e.g. CustomField__c
Complete Salesforce Field options can be found here
Common Direct Fields:
AccountId
Amount
CloseDate
ConnectionReceivedId
ContractId
CurrencyIsoCode
Description
FiscalQuarter
FiscalYear
LastActivityDate
LastReferencedDate
LastViewedDate
Name
OwnerId
Type
Useful Related Fields:
Account:
Company Name = {{Account.Name}}
Company Address:
{{Account.BillingStreet}}, {{Account.BillingCity}}, {{Account.BillingState}}, {{Account.BillingPostalCode}}, {{Account.BillingCountry}}
Company Industry = {{Account.Industry}}
Company - Number of Employees = {{Account.NumberOfEmployees}}
Company website = {{Account.Website}}
Owner:
Sales Rep Name = {{Owner.Name}}
Sales Rep Email = {{Owner.Email}}
Sales Rep Phone = {{Owner.Phone}}
Sales Rep Title = {{Owner.Title}}
Leads
Below is a list of commonly used fields in Salesforce's Leads object.
For any custom fields always ensure that they are done in the format of {{CustomField__c}} with the double underscore and lowercase c at the end.
Complete Salesforce Field options can be found here
Common Fields:
Address
City
Company
Country
CurrencyIsoCode
Description
Division
FirstName
Industry
LastActivityDate
LastName
LastReferencedDate
LastViewedDate
MobilePhone
Name
NumberOfEmployees
OwnerId
PartnerAccountId
Phone
PostalCode
Salutation
State
Suffix
Title
Website
Useful Related Fields:
Owner:
Sales Rep Name = {{Owner.Name}}
Sales Rep Email = {{Owner.Email}}
Sales Rep Phone = {{Owner.Phone}}
Sales Rep Title = {{Owner.Title}}
Accounts
Below is a list of commonly used fields in Salesforce's Accounts object.
For any custom fields always ensure that they are done in the format of {{CustomField__c}} with the double underscore and lowercase c at the end.
Complete Salesforce Field options can be found here
Common Fields:
AccountNumber
BillingAddress
BillingCity
BillingCountry
BillingPostalCode
BillingState
Industry
IsPersonAccount (see the above link for more details on this)
LastActivityDate
LastReferencedDate
LastViewedDate
Name
NumberOfEmployees
OperatingHoursId
OwnerId
Ownership
ParentId
Phone
Salutation
ShippingAddress
ShippingCity
ShippingCountry
ShippingPostalCode
ShippingState
Site
TickerSymbol
Tradestyle
Type
Website
YearStarted
Useful Related Fields:
Owner:
Sales Rep Name = {{Owner.Name}}
Sales Rep Email = {{Owner.Email}}
Sales Rep Phone = {{Owner.Phone}}
Sales Rep Title = {{Owner.Title}}
Contacts
Below is a list of commonly used fields in Salesforce's Contacts object.
For any custom fields always ensure that they are done in the format of {{CustomField__c}} with the double underscore and lowercase c at the end.
Complete Salesforce Field options can be found here
Common Fields:
AccountId
AssistantName
Birthdate
ConnectionReceivedId
ConnectionSentId
Department
Description
FirstName
LastActivityDate
LastCURequestDate
LastCUUpdateDate
LastName
MailingAddress
MobilePhone
Name
OwnerId
Phone
ReportsToId
Salutation
Suffix
Title
Useful Related Fields:
Owner:
Sales Rep Name = {{Owner.Name}}
Sales Rep Email = {{Owner.Email}}
Sales Rep Phone = {{Owner.Phone}}
Sales Rep Title = {{Owner.Title}}
Account:
Company Name = {{Account.Name}}
Company Address:
{{Account.BillingStreet}}, {{Account.BillingCity}}, {{Account.BillingState}}, {{Account.BillingPostalCode}}, {{Account.BillingCountry}}
Company Industry = {{Account.Industry}}
Company - Number of Employees = {{Account.NumberOfEmployees}}
Company website = {{Account.Website}}