This article teaches all about basic Salesforce Admin stuff.

The Basics

Intro

Salesforce is a CRM (Customer Relation Management) software made to improve business sales, customer service, and marketing automation. It helped pioneer SaaS and uses an Oracle-powered relational database to help gather, create, delete, and analyze corporate data. Recall that SaaS is a software-first cloud delivery model (unlike IaaS where admins need to control the server's inner works like the operating system).

Note: This article is based on this trailhead course.

For Salesforce Admins, there are many things to take note of:

• It's not just a database that holds client data, you can also use it to automate marketing tasks (Marketing Cloud Engagement).
• Apex is the server-side language that Salesforce runs on. It is a variant of the Java language used by advanced admins.
• The database relies on a dialect of SQL called SOQL (Salesforce Object Query Language) designed for Salesforce.
• If you want to customize the frontend of your corporate web page apps, you can use Lightning Web Components (LWC) to customize the layout to your liking.
• The client-side runs on ECMAScript 7 while the server-side runs on Apex

Note: VisualForce is an older framework for building UI components. LWC can offer all of VisualForce's functionality with new and upgraded features.

Furthermore, depending on your business model, you can have each department meet their specific needs. For example, for the finance department, you can customize its dashboard to display budget/contract management and pricing.

For the sales executives:

• 
• 
• 
• 

Ok, now we get on the juicy stuff. We'll start creating our own Salesforce sandbox to experiment and commit changes for testing purposes.

To create a sandbox for the course (or you just want to make sure if it is there), go to Salesforce Trailhead and create an account. From there, create/launch your org in "Hands-on Org". You can find it by clicking on your profile then you can create one from there.

There are some important terms to remember:

1. App: A set of objects, fields and other functionality to support a business process. You can find them by clicking on the App Launcher icon beside the word "Dreamhouse".
2. Object: SQL Table in Salesforce-speak
3. Record: SQL rows in Salesforce-speak
4. Field: SQL columns in Salesforce-speak
5. Org (Not highlighted in the picture): It is the implementation of a Salesforce instance. You're in an org in order to use Salesforce.

Note: A Salesforce instance is also called Point of Delivery (POD). It is a container in a running server that holds everything that Salesforce is required to run i.e. application server, database server, search and file system, and the database itself (read here for more info).

Custom Objects, Fields, and Relationships

Creating a Custom Object and Field

Custom objects in Salesforce are data that we need to track. Examples include "Invoices", "Job Postings", "Accounts", "Opportunities" etc. They are all nouns and need to broad as much as possible.

In this example, we can add "Job Posting" as an object:

1. In our default Homepage, Click on the gear icon, then click "setup"
2. Under "Quick Find", type "Object Manager". Click on it.
3. Click "Create" beside "Schema Builder". Then click "Custom Object".
4. For this example, we type in the Label "Job Posting". This will be the name for our custom object.
5. Click on "Allow Search". We enable this for testing purposes.
6. It is important not to ignore clicking on "Launch New Custom Tab Wizard after saving this custom object.". If you ignored this after creating the object, you will have to create the tab manually. Otherwise, it wouldn't be accessible from the client:
   1. Type "Tabs" in the Quick Find box in the Setup menu.
   2. Select Tabs under the User Interface section.
   3. Look for the Custom Object Tabs section and click New.
   4. Select "Job Posting" from the Object dropdown menu.
   5. Choose a Tab Style (the icon that will represent your object).
   6. Click Next, choose which profiles should see the tab, and click Save.
7. Everything else can be left as default.

For terminal enjoyers, here's a link. This can help you make changes to your org directly from your terminal.

Now go back to the sandbox. When you are about to add a new "Job Posting" custom object. This is what it should look like:

The "Job Posting Name" comes from the "Enter Record Name Label and Format" during the creation process. This needs to be treated like a high-level unique field to ease search results.

We can go back to our custom object we've created, click on "Fields & Relationships", click the record "Job Posting Name", then proceed changing the values like so:

Alright! Now we'll add a field in our object.

1. Go back to Object Manager in Setup if you're not there.
2. Find the custom object you've just created "Job Posting". Make sure its API name ends with "__c" (so "Job_Posting__c"). Double underscore c helps Salesforce identify custom metadata with all its methods and properties pre-set.
3. You should now see this:

4. Click on "Fields and Relationships"
5. Click "New"
6. You'll find several data types. For now, we can click on "Text Area" ("Text" requires you to specify the legnth while "Text Area" has the max length to 255).
7. Type in the Field Label "Job Title". This record is intended to be our actual title of the job post.

Note: Field Name is the API/server name of the field. Field Label is the front-end name of the field. It's good for both to have the same name.

8. Click on "Always require a value..." then click "Next"
9. If you're into adding more fields and saving this field, click "Save and Next". Otherwise, just click "Save".

You're free to add more objects. Try to create a scenario that looks like this:

Note: In case you added a field but it's not visible when you're trying to add a record, you have several options:

• Best method: Go to Setup, type in "Session Settings" in Quick Find, disable "Enable and persistent browser caching to improve performance", go back to the home page, type ctrl+f5 to hard refresh then let it reload. This should make the new field visible. Do know that this cannot be disabled in production, only in sandbox.

• Go to "Page Layouts", click on "Job Posting Layout", click "Save", then refresh the Salesforce home page (either a soft refresh ctrl+r, hard refresh ctrl+shift+r, or clear cache with ctrl+f5).

• Remove the new field from the information section in the "Page Layouts" page, Save it, refresh the page/clear the cache, put the new field back again, then refresh it again.

Relationships

In order to create relationships in Salesforce, we need to ensure the right attributes are selected for a particular field. The two attributes are:

External ID Attribute: This makes a field in your local org correspond to the same field in an external org.

For example, say we have two records and both have the field "email". If you try to modify the "email" field in your local org, the corresponding external "email" field will automatically be updated.

As of writing this article, one object can have a maximum of 25 external ID. This includes in account to fields with either or both unique attributes and External ID attributes. Basically, unique attributes + External ID >= 25 in one object.

Unique ID Attribute: By enabling this attribute, we force the field have unique entries (we can either make it case-sensitive or insensitive). This attribute is commonly checked alongside the External ID attribute in order to avoid duplicates records when querying and ensure consistency for both the external and the local objects.

there are three main types of relationships (summary of this and this):

• Lookup Relationship:
  • Two linked objects can exist independently. They are loosely coupled.
  • Can be self-joined (self-relationship): Can link an object with itself (except for the user object). For example, you can link a custom object "Bug" to itself to show how two different bugs are related to the same problem (identical to SQL's self join).
• Master-Detail Relationship:
  • Two linked objects cannot exist independently. They are connected tightly.
  • The child record inherits whatever security settings you chose for the parent record.
  • Cannot be self-joined.
• External Relationship: An object that references another object outside the local Salesforce org. There are three variants:

  • External Lookup: Links a Salesforce object to a external object.

    • Parent Object: External object
    • Child Object: Salesforce standard, custom or external object.
    • Parent Matching Key: External ID (a.k.a Foreign Key of the parent object)

  • Indirect Lookup: Similar to an External Lookup, but it's almost the opposite

    • Parent Object: Salesforce standard or custom object
    • Child Object: External object
    • Parent Matching Key: ANY CUSTOM FIELD with both Unique and ExternalID attributes enabled.

  • Standard Lookup: Links an external child object to a Salesforce standard or custom parent object.

    • Parent Object: Salesforce standard or custom object.
    • Child Object: External object.
    • Parent Matching Key: Salesforce record ID (a.k.a Primary Key of the parent object)

From the official source, you can find a table that summarizes the external relationship like so:

Relationship	Allowed Child Objects	Allowed Parent Objects	Parent Field for Matching Records
Lookup	Standard, Custom, External	Standard, Custom	The 18-character Salesforce record ID
External lookup	Standard, Custom, External	External	The External ID standard field
Indirect lookup	External	Standard, Custom	A custom field with the External ID and Unique attributes

We'll get into the External Relationship more later. But for now, it's good to mostly digest on the Lookup Relationship and the Mater-Detail Relationship.

All about List Views

List view is a Lightning Experience components that lets admins edit, create and delete records of an object. It's really no different from querying rows from a particular table with SQL.

We can create custom list views and add filters to narrow down our query.

To create a custom list view:

1. Click on the App Launcher and type "Accounts" (or click on "Account" button on context bar, click "More" if you can't find it)
2. Click on "Recently Viewed" then select "All Accounts" under "All Other Lists"
3. You'll find all the accounts records in your org. Now in order to create a query to your liking, you need to create a list view. Click on the small gear icon besude "Search this list..." then click "New".
4. Name the list "Channel Customers" under "List Name".
5. Select "All users can see this view".
6. Click Save.

You should now see this:

This helps us find the correct "snapshots" of our object instead of dealing with filters every time.

To add a filter:

1. We click on the funnel icon beside the pie chart icon, then we can "Add Filter".
2. I'll let you play around with this filter. It's quite intuitive from here.