User Story We want to create a table with search, sort, and pagination functionality. Over the course of the next several posts, we are going to look at two possible ways to achieve this, with either server-side or client-side functionality. We will start with the basics of searching: writing our queries. If you would likeContinue reading “Regular Expression to Escape SOQL/SOSL Inputs”
User Story We want to create a lightning__RecordPage component that displays a table that looks different whether it is in a main region or a sidebar, which means that, by default, the component is responsive and mobile friendly. For this example, we will be using the relationship between the Account and Contact objects in SalesforceContinue reading “Width-Aware Collapsible Table”
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”
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”
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.
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”