Querying Distinct Values in SOQL: Approval Process Work Items

User Story We want to get a list of approval processes that have work items that are dependent on a user that is no longer active, and we want to do it without using Apex. Background There is no DISTINCT function in SOQL, so we’re going to have to do some Aggregate Query magic. SolutionContinue reading “Querying Distinct Values in SOQL: Approval Process Work Items”

Creating Dynamic Charts with Chart.JS – Part Two: Creating a Truly Dynamic Dashboard

User Story We have some information on our objects that we want to view in dynamic charts. These charts will update based on the object that is created by inputting a sentence into a Lightning Web Component. Background In the previous post, we started on our Lightning Web Component. We are going to use Chart.jsContinue reading “Creating Dynamic Charts with Chart.JS – Part Two: Creating a Truly Dynamic Dashboard”

Creating Dynamic Charts with Chart.JS – Part One: Palindromic Sentences

User Story This is a pretty basic Intro to JavaScript problem (and common interview and homework problem!) that we will be solving via Salesforce. We want to input a sentence or phrase and determine whether or not what we have entered is a palindrome. For kicks and giggles, we also want to count the numberContinue reading “Creating Dynamic Charts with Chart.JS – Part One: Palindromic Sentences”

Memphis Salesforce Saturday

I have a brief announcement to make. We will be starting our Memphis Salesforce Saturday on Saturday, February 27th! We will meet on the fourth Saturday of the month to start and adjust as necessary. Find more information about the event on EventBrite here. Check out the event on LinkedIn here.

Javascript I Exam Overview

This is a long awaited post, as I passed the Javascript Developer I certification in October, and it is now January! What can I say, sometimes life gets in the way. Much to my surprise and delight, I passed the exam on the first try. Due to COVID restrictions, a lack of testing resources, andContinue reading “Javascript I Exam Overview”

Lightning Web Components Specialist Superbadge (Partial) Walkthrough

This is a partial walkthrough of the Lightning Web Components Specialist Superbadge on Trailhead. This Superbadge is required for the Salesforce Javascript Developer I certification, and requires familiarity with writing code for Salesforce in Visual Studio Code. Disclaimer: this is not meant to be a full solution. I merely collected the resources I used asContinue reading “Lightning Web Components Specialist Superbadge (Partial) Walkthrough”

Creating Child Objects Using Apex REST API

User Story We have an external application that collects Account and Contact information. The application sends information in JSON format. Previously, our sales team input this information manually. Let’s automate the process! Background The Apex REST API allows us to expose our Apex classes and methods to external applications via REST architecture. The Salesforce RESTContinue reading “Creating Child Objects Using Apex REST API”

Displaying Captured Geolocation on a Google Map

Introduction Today I’ll be expanding on my previous post, Capturing Geolocation Using Lightning Components. If you don’t need to capture your device’s geolocation for a lead, that’s okay! This tutorial can be used on any object that has a geolocation field. User Story We are selling cookies door to door, and we want to keep trackContinue reading “Displaying Captured Geolocation on a Google Map”

Capturing Geolocation Using Lightning Components

User Story We are selling cookies door to door, and we want to keep track of the houses we’ve hit! We are going to capture the geolocation of each house on a lead object using our phones so that we know who in the neighborhood we talked to. Background Geolocation Custom Fields are available onContinue reading “Capturing Geolocation Using Lightning Components”

Setting Up a Chromebook for Salesforce Development

Disclaimer: I am not affiliated with Google or any other brand mentioned, and I am making no money for this post. If you would like to give me money for this (or any other!) post, you can go to my contact page and make a donation. So you’ve decided to buy a Chromebook. Me too!Continue reading “Setting Up a Chromebook for Salesforce Development”