At a Glance; Introduction; Chapter 1: The Salesforce.com Data Model: Objects, Fields, and Relationships; Salesforce.com Fields; Standard vs. Custom Fields; Attributes; Custom Field Types; Auto Number; Formula; Checkbox; Numeric Fields; Date Fields; Email; Geolocation; Phone; Picklist; Text Fields; URL; Additional Field Types; Creating a Custom Field Step by Step; Salesforce.com Objects; Salesforce.com Relationships; Relationship Field Types; Lookup Relationship; Master-Detail Relationship; Roll Up Summary; Junction Objects; Some Perspective on the Data Model; Recap.
Chapter 2: Formula Functions: Your Building Block in Salesforce.com FormulasAnatomy of a Salesforce.com Function; Name; Arguments; Optional Arguments; Salesforce.com Development Using Functions; The Function Selector; Inserting a Field; Inserting Text; Checking Your Syntax; Using the Simple and Advanced Formula Editors; Salesforce.com Formula Functions: A Deep Dive; ABS; Format; Application Scenarios; Usability; Other Considerations; AND; Format; Application Scenarios; Usability; Other Considerations; BEGINS; Format; Application Scenarios; Usability; BLANKVALUE; Format; Application Scenarios.
UsabilityOther Considerations; CASE; Format; Application Scenarios; Usability; Other Considerations; CONTAINS; Format; Application Scenarios; Usability; DATE; Format; Application Scenarios; Usability; DATEVALUE; Format; Application Scenarios; Usability; DAY, MONTH, and YEAR; Format; Application Scenarios; Usability; FIND; Format; Application Scenarios; Usability; HYPERLINK; Format; Application Scenarios; Usability; Other Considerations; IF; Format; Application Scenarios; Usability; IMAGE; Format; Application Scenarios; Usability; INCLUDES; Format; Application Scenarios; Usability; ISBLANK.
FormatApplication Scenarios; Usability; Other Considerations; ISCHANGED; Format; Application Scenarios; Usability; ISNEW; Format; Application Scenarios; Other Considerations; Usability; ISNULL; ISPICKVAL; Format; Application Scenarios; Usability; LEFT, MID, RIGHT; Format; Application Scenarios; Other Considerations; Usability; LEN; Format; Application Scenarios; Usability; MID; MOD; Format; Usability; NOW, TODAY; Format; Application Scenarios; Usability; OR; Format; Application Scenarios; Usability; Other Considerations; PRIORVALUE; Format; Application Scenarios; Usability; REGEX; Format.
Application ScenariosUsability; RIGHT; SUBSTITUTE; Format; Application Scenarios; Usability; TEXT; Format; Application Scenarios; Usability; TODAY; TRIM; Format; Application Scenarios; Usability; VALUE; Format; Application Scenarios; Usability; Recap; Chapter 3: All About Formula Fields; Preparing to Build Your Formula Fields; The Structure of Formula Fields; Static Values; Derived Values; Using Lookup or Related Fields; Functions; Statements and Operators; Add, Subtract, Multiply, and Divide; Exponentiation; Opening and Closing Parentheses; Result:; Result:; Equal To and Not Equal To.