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

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"

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  ...

Building Dynamic Question-Answer Functionality with Visualforce Code

Introduction: In this blog post, we will explore how to implement dynamic question-answer functionality using Visualforce code. Visualforce is a powerful framework provided by Salesforce that allows developers to build custom user interfaces and extend the functionality of their Salesforce applications. By leveraging Visualforce, we can create a dynamic and interactive question-answer feature that enhances the user experience and improves data collection. Let's dive into the implementation details! 1. Setting up the Visualforce Page: First, create a Visualforce page by navigating to Setup in your Salesforce org and selecting "Develop" > "Pages." Click on "New" to create a new Visualforce page. Give it a name and specify the standard controller or custom controller for the object you will be working with.    Start by creating a Visualforce page where you will display the questions and capture user input.    <apex:page controller="Questi...

Salesforce Classic to LWC: Your Roadmap to a Modern Org

Are you thinking about finally making the jump from Salesforce Classic to Lightning Web Components ( LWC ) ? Honestly, that’s a smart move. While Classic served us well for years, LWC offers the kind of speed, flexibility, and modern interface that today's users actually expect. But let’s be real for a second—migrating isn't just about flipping a switch. It’s a project that needs a plan.

Adding Buttons in LWC DataTable Salesforce

Introduction: In Salesforce Lightning Web Components (LWC), the DataTable component provides a powerful way to display tabular data. However, at times, we may need to enhance the functionality of the DataTable by adding buttons to perform custom actions on the data. In this blog post, we will explore how to add buttons to a DataTable in Salesforce LWC and handle the corresponding button click events.

Building Lazy Loading in LWC Lightning Datatable: A Full Dynamic Working Code

Introduction: In this blog post, we will explore how to implement lazy loading functionality in Lightning Web Components (LWC) using the Lightning Datatable component. Lazy loading is a technique that loads data dynamically as the user scrolls, resulting in improved performance and reduced initial load time. We will provide a step-by-step guide along with a full working code example to help you understand and implement this functionality in your LWC projects.

LWC Full Dynamic Working Code for Useful JavaScript Methods in LWC

Introduction: Welcome to Part 1 of our blog series on useful JavaScript methods in Lightning Web Components (LWC). In this article, we will explore some dynamic working code examples that showcase the power and flexibility of JavaScript in LWC development. These methods will help you enhance the functionality and user experience of your LWC applications. So, let's dive in!