Salesforce Pack Documentation
Share
Explore

icon picker
Fields

Find the unique API accessible name of a field
info

Fields that can be used with pack formulas from your Salesforce instance

A Salesforce install might have thousands of fields. To avoid overrunning the sync table with rows you likely won’t need, you need to state each object for which you want fields synced in. You can do this by clicking on the “Edit” link when you hover on the Fields table below. Then “Add another sync”.
This template is set up with all objects we have formulas for, but feel free to add any additional ones you may need.
image.png
Fields
0
Not synced yet
Object
Label
Name
Data Type
Type
Coda Formula
Search
Object
Details
Field
Name
Data Type
Type
Account
38
Billing Street
BillingStreet
textarea
Standard
Billing City
BillingCity
string
Standard
Billing State/Province
BillingState
string
Standard
Billing Zip/Postal Code
BillingPostalCode
string
Standard
Billing Country
BillingCountry
string
Standard
Billing Latitude
BillingLatitude
double
Standard
Billing Longitude
BillingLongitude
double
Standard
Billing Geocode Accuracy
BillingGeocodeAccuracy
picklist
Standard
Billing Address
BillingAddress
address
Standard
Shipping Street
ShippingStreet
textarea
Standard
Shipping City
ShippingCity
string
Standard
Shipping State/Province
ShippingState
string
Standard
Shipping Zip/Postal Code
ShippingPostalCode
string
Standard
Shipping Country
ShippingCountry
string
Standard
Shipping Latitude
ShippingLatitude
double
Standard
Shipping Longitude
ShippingLongitude
double
Standard
Shipping Geocode Accuracy
ShippingGeocodeAccuracy
picklist
Standard
Shipping Address
ShippingAddress
address
Standard
SIC Code
Sic
string
Standard
Ticker Symbol
TickerSymbol
string
Standard
Jigsaw Company ID
JigsawCompanyId
string
Standard
Account Source
AccountSource
picklist
Standard
SIC Description
SicDesc
string
Standard
Account Number
AccountNumber
string
Standard
Ownership
Ownership
picklist
Standard
Account Site
Site
string
Standard
D-U-N-S Number
DunsNumber
string
Standard
Tradestyle
Tradestyle
string
Standard
NAICS Code
NaicsCode
string
Standard
NAICS Description
NaicsDesc
string
Standard
Year Started
YearStarted
string
Standard
Operating Hour ID
OperatingHoursId
reference
Standard
Customer Priority
CustomerPriority__c
picklist
Custom
SLA
SLA__c
picklist
Custom
Active
Active__c
picklist
Custom
Upsell Opportunity
UpsellOpportunity__c
picklist
Custom
SLA Serial Number
SLASerialNumber__c
string
Custom
SLA Expiration Date
SLAExpirationDate__c
date
Custom
Campaign
17
Start Date
StartDate
date
Standard
End Date
EndDate
date
Standard
Expected Revenue in Campaign
ExpectedRevenue
currency
Standard
Budgeted Cost in Campaign
BudgetedCost
currency
Standard
Actual Cost in Campaign
ActualCost
currency
Standard
Expected Response (%)
ExpectedResponse
percent
Standard
Num Sent in Campaign
NumberSent
double
Standard
Active
IsActive
boolean
Standard
Leads in Campaign
NumberOfLeads
int
Standard
Converted Leads in Campaign
NumberOfConvertedLeads
int
Standard
Contacts in Campaign
NumberOfContacts
int
Standard
Responses in Campaign
NumberOfResponses
int
Standard
Opportunities in Campaign
NumberOfOpportunities
int
Standard
Won Opportunities in Campaign
NumberOfWonOpportunities
int
Standard
Value Opportunities in Campaign
AmountAllOpportunities
currency
Standard
Value Won Opportunities in Campaign
AmountWonOpportunities
currency
Standard
Record Type ID
CampaignMemberRecordTypeId
reference
Standard
Case
26
Case Type
Type
picklist
Standard
Contact ID
ContactId
reference
Standard
Last Viewed Date
LastViewedDate
datetime
Standard
Last Referenced Date
LastReferencedDate
datetime
Standard
Master Record ID
MasterRecordId
reference
Standard
Parent Case ID
ParentId
reference
Standard
Case Number
CaseNumber
string
Standard
Name
SuppliedName
string
Standard
Email Address
SuppliedEmail
email
Standard
Phone
SuppliedPhone
string
Standard
Company
SuppliedCompany
string
Standard
Case Reason
Reason
picklist
Standard
Case Origin
Origin
picklist
Standard
Closed Date
ClosedDate
datetime
Standard
Escalated
IsEscalated
boolean
Standard
Contact Phone
ContactPhone
phone
Standard
Contact Mobile
ContactMobile
phone
Standard
Contact Email
ContactEmail
email
Standard
Contact Fax
ContactFax
phone
Standard
Internal Comments
Comments
textarea
Standard
Asset ID
AssetId
reference
Standard
Source ID
SourceId
reference
Standard
Engineering Req Number
EngineeringReqNumber__c
string
Custom
SLA Violation
SLAViolation__c
picklist
Custom
Product
Product__c
picklist
Custom
Potential Liability
PotentialLiability__c
picklist
Custom
Contact
30
Other Street
OtherStreet
textarea
Standard
Other City
OtherCity
string
Standard
Other State/Province
OtherState
string
Standard
Other Zip/Postal Code
OtherPostalCode
string
Standard
Other Country
OtherCountry
string
Standard
Other Latitude
OtherLatitude
double
Standard
Other Longitude
OtherLongitude
double
Standard
Other Geocode Accuracy
OtherGeocodeAccuracy
picklist
Standard
Other Address
OtherAddress
address
Standard
Mailing Street
MailingStreet
textarea
Standard
Mailing City
MailingCity
string
Standard
Mailing State/Province
MailingState
string
Standard
Mailing Zip/Postal Code
MailingPostalCode
string
Standard
Mailing Country
MailingCountry
string
Standard
Mailing Latitude
MailingLatitude
double
Standard
Mailing Longitude
MailingLongitude
double
Standard
Mailing Geocode Accuracy
MailingGeocodeAccuracy
picklist
Standard
Mailing Address
MailingAddress
address
Standard
Home Phone
HomePhone
phone
Standard
Other Phone
OtherPhone
phone
Standard
Asst. Phone
AssistantPhone
phone
Standard
Reports To ID
ReportsToId
reference
Standard
Department
Department
string
Standard
Birthdate
Birthdate
date
Standard
Last Stay-in-Touch Request Date
LastCURequestDate
datetime
Standard
Last Stay-in-Touch Save Date
LastCUUpdateDate
datetime
Standard
Is Email Bounced
IsEmailBounced
boolean
Standard
Assistant's Name
AssistantName
string
Standard
Level
Level__c
picklist
Custom
Languages
Languages__c
string
Custom
Lead
46
Full Name
Name
string
Standard
Lead Source
LeadSource
picklist
Standard
Last Activity
LastActivityDate
date
Standard
Phone
Phone
phone
Standard
Website
Website
url
Standard
Photo URL
PhotoUrl
url
Standard
Industry
Industry
picklist
Standard
Annual Revenue
AnnualRevenue
currency
Standard
Employees
NumberOfEmployees
int
Standard
Data.com Key
Jigsaw
string
Standard
Last Name
LastName
string
Standard
First Name
FirstName
string
Standard
Salutation
Salutation
picklist
Standard
Fax
Fax
phone
Standard
Email
Email
email
Standard
Title
Title
string
Standard
Email Bounced Reason
EmailBouncedReason
string
Standard
Email Bounced Date
EmailBouncedDate
datetime
Standard
Jigsaw Contact ID
JigsawContactId
string
Standard
Individual ID
IndividualId
reference
Standard
Company
Company
string
Standard
Street
Street
textarea
Standard
City
City
string
Standard
State/Province
State
string
Standard
Zip/Postal Code
PostalCode
string
Standard
Country
Country
string
Standard
Latitude
Latitude
double
Standard
Longitude
Longitude
double
Standard
Geocode Accuracy
GeocodeAccuracy
picklist
Standard