Salesforce Pack Documentation

Explore

Pages

Fields

Find the unique API accessible name of a field

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.

⁠

Fields

Fields

Object

Label

Name

Data Type

Type

Coda Formula

Object

Details

Field

Name

Data Type

Type

Billing Street

BillingStreet

Billing City

BillingCity

Billing State/Province

BillingState

Billing Zip/Postal Code

BillingPostalCode

Billing Country

BillingCountry

Billing Latitude

BillingLatitude

Billing Longitude

BillingLongitude

Billing Geocode Accuracy

BillingGeocodeAccuracy

Billing Address

BillingAddress

Shipping Street

ShippingStreet

Shipping City

ShippingCity

Shipping State/Province

ShippingState

Shipping Zip/Postal Code

ShippingPostalCode

Shipping Country

ShippingCountry

Shipping Latitude

ShippingLatitude

Shipping Longitude

ShippingLongitude

Shipping Geocode Accuracy

ShippingGeocodeAccuracy

Shipping Address

ShippingAddress

SIC Code

Sic

Ticker Symbol

TickerSymbol

Jigsaw Company ID

JigsawCompanyId

Account Source

AccountSource

SIC Description

SicDesc

Account Number

AccountNumber

Ownership

Account Site

Site

D-U-N-S Number

DunsNumber

Tradestyle

NAICS Code

NaicsCode

NAICS Description

NaicsDesc

Year Started

YearStarted

Operating Hour ID

OperatingHoursId

Customer Priority

CustomerPriority__c

SLA

SLA__c

Active

Active__c

Upsell Opportunity

UpsellOpportunity__c

SLA Serial Number

SLASerialNumber__c

SLA Expiration Date

SLAExpirationDate__c

Start Date

StartDate

End Date

EndDate

Expected Revenue in Campaign

ExpectedRevenue

Budgeted Cost in Campaign

BudgetedCost

Actual Cost in Campaign

ActualCost

Expected Response (%)

ExpectedResponse

Num Sent in Campaign

NumberSent

Active

IsActive

Leads in Campaign

NumberOfLeads

Converted Leads in Campaign

NumberOfConvertedLeads

Contacts in Campaign

NumberOfContacts

Responses in Campaign

NumberOfResponses

Opportunities in Campaign

NumberOfOpportunities

Won Opportunities in Campaign

NumberOfWonOpportunities

Value Opportunities in Campaign

AmountAllOpportunities

Value Won Opportunities in Campaign

AmountWonOpportunities

Record Type ID

CampaignMemberRecordTypeId

Case Type

Type

Contact ID

ContactId

Last Viewed Date

LastViewedDate

Last Referenced Date

LastReferencedDate

Master Record ID

MasterRecordId

Parent Case ID

ParentId

Case Number

CaseNumber

Name

SuppliedName

Email Address

SuppliedEmail

Phone

SuppliedPhone

Company

SuppliedCompany

Case Reason

Reason

Case Origin

Origin

Closed Date

ClosedDate

Escalated

IsEscalated

Contact Phone

ContactPhone

Contact Mobile

ContactMobile

Contact Email

ContactEmail

Contact Fax

ContactFax

Internal Comments

Comments

Asset ID

AssetId

Source ID

SourceId

Engineering Req Number

EngineeringReqNumber__c

SLA Violation

SLAViolation__c

Product

Product__c

Potential Liability

PotentialLiability__c

Other Street

OtherStreet

Other City

OtherCity

Other State/Province

OtherState

Other Zip/Postal Code

OtherPostalCode

Other Country

OtherCountry

Other Latitude

OtherLatitude

Other Longitude

OtherLongitude

Other Geocode Accuracy

OtherGeocodeAccuracy

Other Address

OtherAddress

Mailing Street

MailingStreet

Mailing City

MailingCity

Mailing State/Province

MailingState

Mailing Zip/Postal Code

MailingPostalCode

Mailing Country

MailingCountry

Mailing Latitude

MailingLatitude

Mailing Longitude

MailingLongitude

Mailing Geocode Accuracy

MailingGeocodeAccuracy

Mailing Address

MailingAddress

Home Phone

HomePhone

Other Phone

OtherPhone

Asst. Phone

AssistantPhone

Reports To ID

ReportsToId

Department

Birthdate

Last Stay-in-Touch Request Date

LastCURequestDate

Last Stay-in-Touch Save Date

LastCUUpdateDate

Is Email Bounced

IsEmailBounced

Assistant's Name

AssistantName

Level

Level__c

Languages

Languages__c

Full Name

Name

Lead Source

LeadSource

Last Activity

LastActivityDate

Phone

Website

Photo URL

PhotoUrl

Industry

Annual Revenue

AnnualRevenue

Employees

NumberOfEmployees

Data.com Key

Jigsaw

Last Name

LastName

First Name

FirstName

Salutation

Fax

Title

Email Bounced Reason

EmailBouncedReason

Email Bounced Date

EmailBouncedDate

Jigsaw Contact ID

JigsawContactId

Individual ID

IndividualId

Company

Street

City

State/Province

State

Zip/Postal Code

PostalCode

Country

Latitude

Longitude

Geocode Accuracy

GeocodeAccuracy

Address

Mobile Phone

MobilePhone

Rating

Converted

IsConverted

Converted Date

ConvertedDate

Converted Account ID

ConvertedAccountId

Converted Contact ID

ConvertedContactId

Converted Opportunity ID

ConvertedOpportunityId

Unread By Owner

IsUnreadByOwner

Current Generator(s)

CurrentGenerators__c

Clean Status

CleanStatus

D&B Company ID

DandbCompanyId

Number of Locations

NumberofLocations__c

Company D-U-N-S Number

CompanyDunsNumber

SIC Code

SICCode__c

Product Interest

ProductInterest__c

Primary

Primary__c

Stage

StageName

Amount

Probability (%)

Probability

Close Date

CloseDate

Next Step

NextStep

Won

IsWon

Forecast Category

ForecastCategory

Forecast Category

ForecastCategoryName

Campaign ID

CampaignId

Has Line Item

HasOpportunityLineItem

Price Book ID

Pricebook2Id

Fiscal Quarter

FiscalQuarter

Fiscal Year

FiscalYear

Fiscal Period

Fiscal

Has Open Activity

HasOpenActivity

Has Overdue Task

HasOverdueTask

Opportunity History ID

LastAmountChangedHistoryId

Opportunity History ID

LastCloseDateChangedHistoryId

Private

IsPrivate

Quantity

TotalOpportunityQuantity

Delivery/Installation Status

DeliveryInstallationStatus__c

Tracking Number

TrackingNumber__c

Order Number

OrderNumber__c

Main Competitor(s)

MainCompetitors__c

Activity ID

Deleted

IsDeleted

Account ID

AccountId

Description

Closed

IsClosed

Assigned To ID

OwnerId

Created Date

CreatedDate

Created By ID

CreatedById

Last Modified Date

LastModifiedDate

Last Modified By ID

LastModifiedById

System Modstamp

SystemModstamp

Status

Subject

Priority

Name ID

WhoId

Related To ID

WhatId

Due Date Only

ActivityDate

High Priority

IsHighPriority

Archived

IsArchived

Call Duration

CallDurationInSeconds

Call Type

CallType

Call Result

CallDisposition

Call Object Identifier

CallObject

Reminder Date/Time

ReminderDateTime

Reminder Set

IsReminderSet

Recurrence Activity ID

RecurrenceActivityId

Create Recurring Series of Tasks

IsRecurrence

Recurrence Start

RecurrenceStartDateOnly

Recurrence End

RecurrenceEndDateOnly

Recurrence Time Zone

RecurrenceTimeZoneSidKey

Recurrence Type

RecurrenceType

Recurrence Interval

RecurrenceInterval

Recurrence Day of Week Mask

RecurrenceDayOfWeekMask

Recurrence Day of Month

RecurrenceDayOfMonth

Recurrence Instance

RecurrenceInstance

Recurrence Month of Year

RecurrenceMonthOfYear

Repeat This Task

RecurrenceRegeneratedType

Task Subtype

TaskSubtype

Completed Date/Time

CompletedDateTime

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.