Layer 1

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

Email

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

Email

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}}

QWILR