Skip to main content

Latest Post

The Ego in the Machine: Is Our Need for Validation Creating an Existential Threat?

Technology has always been a bridge, but today, it feels more like a mirror. With the rapid rise of AI , we are seeing things enter our lives and leave them at a pace we can barely track. To understand where this is going, we first have to understand how technology actually impacts the core of who we are. The Survivalist vs. The Ego Our minds are biologically wired for one thing: survival . We are designed to handle the worst-case scenario, an ancient instinct gifted to us by nature. We consider ourselves conscious decision-makers, but a critical question remains: Who is really making the call?

LWC Code Sample for Database Insert in Salesforce

Introduction:

In this blog post, we will explore how to use Lightning Web Components (LWC) in Salesforce to perform a database insert operation. We'll walk through a step-by-step code sample that demonstrates how to create a form in LWC, capture user input, and insert the data into a Salesforce database using Apex.

Database Insert



Prerequisites:


Before proceeding with the code sample, make sure you have the following:

  1. A Salesforce developer account
  2. Basic knowledge of Salesforce development, including Apex and LWC
  3. Salesforce CLI installed and configured

Step 1: Set Up the Project

To begin, create a new LWC project using the Salesforce CLI. Open your terminal or command prompt and run the following command:


sfdx force:project:create -n LWCDatabaseInsert


Navigate to the project directory:


cd LWCDatabaseInsert


Step 2: Create an Apex Class


Next, let's create an Apex class that will handle the database insert operation. Create a new file named "DatabaseInsertController.cls" in the "force-app/main/default/classes" directory. Add the following code to the file:


public with sharing class DatabaseInsertController {

    @AuraEnabled

    public static void insertRecord(String name, String email) {

        // Create a new record

        Account account = new Account();

        account.Name = name;

        account.Email__c = email;

        

        // Insert the record into the database

        insert account;

    }

}


Step 3: Create the LWC Component


Now, let's create the Lightning Web Component that will contain the form and handle user input. Create a new file named "databaseInsertForm" in the "force-app/main/default/lwc" directory. Add the following code to the file:


<template>

    <lightning-card title="Database Insert Form">

        <div class="slds-p-horizontal_medium slds-p-vertical_small">

            <lightning-input label="Name" value={name} onchange={handleNameChange}></lightning-input>

            <lightning-input label="Email" value={email} onchange={handleEmailChange}></lightning-input>

            <lightning-button label="Submit" onclick={handleSubmit}></lightning-button>

        </div>

    </lightning-card>

</template>


Step 4: Add JavaScript Logic


Create a new file named "databaseInsertForm" in the same directory. Add the following code to the file:


import { LightningElement, track } from 'lwc';

import insertRecord from '@salesforce/apex/DatabaseInsertController.insertRecord';


export default class DatabaseInsertForm extends LightningElement {

    @track name = '';

    @track email = '';

    

    handleNameChange(event) {

        this.name = event.target.value;

    }

    

    handleEmailChange(event) {

        this.email = event.target.value;

    }

    

    handleSubmit() {

        insertRecord({ name: this.name, email: this.email })

            .then(() => {

                // Success message or any additional logic

                console.log('Record inserted successfully.');

            })

            .catch((error) => {

                // Error handling

                console.error(error);

            });

    }

}


Step 5: Deploy and Test


Deploy the project to your Salesforce org using the following command:


sfdx force:source:deploy -p force-app/main/default


Once the deployment is successful, you can add the LWC component to a Lightning page or app using the Lightning App Builder.


Conclusion:


In this blog post, we learned how to create a Lightning Web Component in Salesforce and perform a database insert operation using Apex. By following the provided code sample and steps, you should now have a working LWC form that allows users to enter data and inserts that data into a Salesforce database. Feel free to modify the code and explore additional functionalities to enhance your LWC component further. 

Happy coding!

Popular Posts

How to Save Quote PDF, Send PDF, Preview PDF in salesforce with custom functionality

Want to develop custom pdf viewer, save pdf in quote pdf related List and Send quote to customer on button click when quote is custom in salesforce . These functionality are standard from salesforce. but you can develop these functionality custom in salesforce. Here is the solution:- Custom button to save Quote PDF and send PDF  Step 1:-  First Create Two custom button. which will used for PDF preview and Save quote pdf in quotes pdf related list.                               1. PDF preview Button                              2. Save & Send Quote Button Replace "Your VF page here" to Your quote PDF cuatom page. Step 2:-  PDF preview button   pdf preview button will display the pdf's preview in standard format of salesforce. So you need to set the  following configuration (In picture). After that you have ...

Generating CSV in Lightning Web Components (LWC) - A Step-by-Step Guide

Introduction: Lightning Web Components (LWC) is a powerful framework provided by Salesforce for building modern and efficient user interfaces in the Lightning Experience. In this blog, we will explore how to create a full-fledged LWC application that generates and exports data as a CSV (Comma-Separated Values) file. CSV files are commonly used for data exchange and can be opened and manipulated with various spreadsheet software.

Building a Dynamic Device Form Factor in LWC for Salesforce

Introduction: In today's rapidly evolving digital landscape, creating user-friendly and responsive interfaces is crucial. Salesforce Lightning Web Components (LWC) provide a powerful framework for building interactive and efficient applications. In this blog post, we will explore how to develop a dynamic device form factor in LWC, allowing your application to adapt seamlessly across various screen sizes and devices.

Artificial Intelligence Fundamentals in Salesforce

Introduction: Artificial Intelligence (AI) has revolutionized various industries, and Salesforce, a leading customer relationship management (CRM) platform, has embraced AI to enhance its capabilities. Salesforce leverages AI to provide personalized customer experiences, automate tasks, and gain valuable insights. In this blog post, we will explore the fundamentals of AI in Salesforce, highlighting its key components and benefits. 1. Understanding Artificial Intelligence: Artificial Intelligence refers to the simulation of human intelligence in machines, enabling them to perform tasks that typically require human intelligence. AI encompasses various technologies such as machine learning, natural language processing, and computer vision, among others. 2. AI in Salesforce: Salesforce has incorporated AI into its platform through its AI-powered product called Einstein. Einstein brings intelligent features to Salesforce, empowering businesses to make data-driven decisions, automate ...

LWC Full Dynamic Working Code for Useful JavaScript Methods in LWC

Introduction: Welcome to Part 3 of our blog series on building Lightning Web Components (LWC) with full dynamic working code. In this installment, we will continue exploring some useful JavaScript methods that can enhance the functionality and interactivity of your LWC applications. By the end of this article, you'll have a solid understanding of how to leverage these methods to create dynamic and efficient LWC components. So let's dive in!

Building Mixed Shadow Mode Components in LWC Salesforce: A Comprehensive Guide with Example Code

Introduction: In Salesforce Lightning Web Components (LWC), the mixed shadow mode allows you to leverage the benefits of both the Shadow DOM and the Light DOM. It enables you to encapsulate your component's styles and prevent CSS clashes while still maintaining the flexibility to interact with elements outside the component's boundary. In this blog post, we will explore the concept of mixed shadow mode in LWC and provide you with a step-by-step guide on how to build components using this mode. Additionally, we will include example code snippets to help you grasp the implementation process more effectively. Table of Contents: 1. What is Mixed Shadow Mode? 2. Advantages of Mixed Shadow Mode 3. Building Components in Mixed Shadow Mode    a. Enabling Mixed Shadow Mode    b. Styling in Mixed Shadow Mode    c. Interaction with Elements Outside the Component 4. Example Code: Building a Custom Button Component    a. HTML Markup  ...

Streamlining Business Processes with Salesforce Flow

Introduction: Salesforce Flow is a powerful automation tool that empowers businesses to streamline and automate their complex business processes within the Salesforce platform. With its intuitive visual interface, robust functionality, and seamless integration capabilities, Salesforce Flow revolutionizes the way organizations manage and optimize their workflows. In this blog post, we will explore the features, benefits, and potential of Salesforce Flow in driving operational efficiency and enhancing user productivity. 1. Visual Process Automation: Salesforce Flow offers a visual interface that allows users to design and automate processes using a drag-and-drop approach. Business users can easily create workflows, define decision points, and automate repetitive tasks without the need for extensive coding knowledge. This visual approach simplifies process automation and reduces reliance on IT resources. 2. End-to-End Process Automation: Salesforce Flow enables end-to-end process a...

Uninstall all Windows 10 default apps using Powershell

Here is script to uninstall all windows 10 default modern apps. This script uninstalls xbox, xbox Game bar, Xbox App,Xbox Gaming Overlay, Get started etc from your computer. No need to run one by one commands Just copy below script, run  powershell as administrator and paste script and press enter . It will automatically uninstall all default programs.  If you do not  want to uninstall some apps than just remove " "  line from script. $packages = @( "7EE7776C.LinkedInforWindows" "C27EB4BA.DropboxOEM" "Microsoft.3DBuilder" "Microsoft.Microsoft3DViewer"