Decoding Salesforce

Decoding Salesforce

The hows and whys of Salesforce.com

Posts Tagged ‘IDs’

How to obtain a field ID

Often people ask me how to get fields IDs in order to build their custom links. I thought it would have been helpful to write a post about this. Let’s see how to get a field ID for custom and standard fields.

Custom Fields

In order to get the ID of a custom field proceed this way:

  • Click on Setup, then on Customize, select the Object you desire (e.g.: Leads) and click on Fields;
  • Click on the name of the custom field you previously created
  • Look at your browser’s address bar, you’ll see something like:
    https://emea.salesforce.com/00N20000000thpj
  • The 15 digit code that appears immediately after https://emea.salesforce.com/ is the ID of that custom field; in this case the ID of the custom field I selected is 00N20000000thpj

Easy enough, isnt’t it :)

Standard Fields

Salesforce.com provides a list of the field’s name for its standard fields, which can be found attached to the solution “How do I create custom links?” and that I decided to paste here as a quick reference:

EVENTSField TypeID
Assigned ToIDevt1_lkid
Textevt1_lkold
Subjectevt5
WhoPicklistevt2_mlktp
IDevt2_lkid
Textevt2

WhatPicklistevt3_mlktp
IDevt3_lkid
Textevt3
PrivateIsPrivate
Activity Currencyevt9
Locationevt12
Dateevt4

Timeevt13
All Day Eventevt15
Typeevt10
Show Time AsShowAs
Descriptionevt6
TASKSField TypeID
Assigned ToIDtsk1_lkid
Texttsk1
Subjecttsk5
Due Datetsk4
Statustsk4
WhoPicklisttsk2_mlktp
IDtsk2_lkid

Texttsk2
WhatPicklisttsk3_mlktp
IDtsk3_lkid
Texttsk3
Commentstsk6
Notify by Emailemail
CAMPAIGNSField TypeID
Campaign Namecpn1
Typecpn2
Statuscpn3
Start Datecpn5
End Datecpn6
Expected Revenuecpn8

Budgeted Costcpn9
Actual Costcpn10
Expected Response %cpn11
Campaign Currencycpn7
Number Sentcpn13
Activecpn16
Descriptioncpn4

LEADSField TypeID
SalutationPicklistname_salutationlea2
First Namename_firstlea2
Last Namename_lastlea2
Companylea3
Titlelea4

Lead Sourcelea5
Industrylea6
Annual Revenuelea7
CampaignIDlea20_lkid
Textlea20_lkold
Descriptionlea17
Phonelea8

Mobilelea9
Faxlea10
Emaillea11
Websitelea12
Lead Statuslea13
Ratinglea14
# of Employeeslea15

Email Opt Outlea22
Streetlea16street
Citylea16city
State/Provincelea16state
Zip/Postal Codelea16zip
Countrylea16country
Use Assignment Rulelea21

ACCOUNTSField TypeID
Account Nameacc2
Account Siteacc23
Account Numberacc5
Typeacc6
Industryacc7

Annual Revenueacc8
Account Currencyacc24
Ratingacc9
Phoneacc10
Faxacc11
Websiteacc12
Ticker Symbolacc13

Ownershipacc14
Employeesacc15
SIC Codeacc16
Billing Streetacc17street
Billing Cityacc17city
Billing State/Provinceacc17state
Billing Zip/Postal Codeacc17zip

Billing Countryacc17country
Shipping Streetacc18street
Shipping Cityacc18city
Shipping State/Provinceacc18state
Shipping Zip/Postal Codeacc18zip
Shipping Countryacc18country
Descriptionacc20

CONTACTSField TypeID
SalutationPicklistname_saluatationcon2
First Namename_firstcon2
Last Namename_lastcon2
AccountIDcon4_lkid
textcon4_lkold

Titlecon5
Departmentcon6
Birthdatecon7
Reports ToIDcon8_lkid
Textcon8_lkold
Lead Sourcecon9
Contact Currencycon21

Phonecon10
Home Phonecon13
Mobilecon12
Other Phonecon14
Faxcon11
Emailcon15
Assistantcon16

Asst. Phonecon17
Email Opt Outcon23
Mailing Streetcon19street
Mailing Citycon19city
Mailing State/Provincecon19state
Mailing Zip/Postal Codecon19zip
Mailing Countrycon19country

Other Streetcon18street
Other Citycon18city
Other State/Provincecon18state
Other Zip/Postal Codecon18zip
Other Countrycon18country
Descriptioncon20
OPPORTUNITIESField TypeID
Nameopp3
AccountIDopp4_lkid
Textopp4_lkold
Typeopp5
Lead Sourceopp6
Forecast CategoryForecastCategory

Opportunity Currencyopp16
Amountopp7
Close Dateopp9
Next Stepopp10
Stageopp11
Probabilityopp12
Campaign SourceIDopp17_lkid

Textopp17_lkold
Descriptionopp14
CONTRACTSField TypeID
AccountIDctrc7_lkid
Textctrc7_lkold
Customer Signed ByIDctrc16_lkid
Textctrc_lkold
Customer Signed TitleCustomerSignedTitle
CustomerSignedTitlectrc6
Contract CurrencyCurrencyIsoCode
Price Bookctrc17

Statusctrc15
Contract Start Datectrc5
Contract Terms(months)ctrc40
Owner Expiration Noticectrc13
Company Signed ByIDCompanySigned_lkid
TextCompanySigned_lkold
Company Signed DateCompanySignedDate

Billing Streetctrc25street
Billing Cityctrc25city
Billing State/Provincectrc25state
Billing Zip/Postal Codectrc25zip
Billing Countryctrc25country
Special TermsSpecialTerms
DescriptionDescription

CASESField TypeID
ContactIDcas3_lkid
Textcas3_lkold
Typecas5
Case Reasoncas6
Case Currencycas24

Statuscas7
Prioritycas8
Case Origincas11
Visible in Portalcas27
Subjectcas14
Internal CommentsCas15
Assignment Rulescas21

Send notification to Contactcas22
SOLUTIONSField TypeID
NameSolutionName
DetailsSolutionNote
PRODUCTSField TypeID
NameName
Product CodeProductCode
Quantity Scheduling EnabledCanUseQuantitySchedule
Product CurrencyCurrencyIsoCode
DescriptionDescription
ActiveIsActive
Product FamilyFamily

Revenue Scheduling EnabledCanUseRevenueSchedule
Quantity Schedule TypepQST
Quantity Installment PeriodpQSI
Number Of Quantity InstallmentspQSN
Revenue Schedule TypepRST
Revenue Installment PeriodpRSI
Number Of Revenue InstallmentspRSN

DOCUMENTSField TypeID
NameName
Internal Use Onlyiuo
Externally Available Imagepub
Folderpid
Descriptiondesc

Keywordskey

Questions? ;)