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

Salesforce LWC Code for Multi-Select Lookup

Introduction: In Salesforce Lightning Web Components (LWC), implementing a multi-select lookup field can enhance the user experience and provide greater flexibility for selecting multiple related records. In this blog post, we will walk through the process of creating a multi-select lookup field using LWC. We will cover the required code snippets and provide step-by-step instructions to help you implement this functionality in your Salesforce org.

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

LWC Code Sample for Global List View Component

Introduction: In this blog post, we will explore how to create a Global List View component using Lightning Web Components (LWC). List views are a powerful feature in Salesforce that allow users to filter and display records based on specific criteria. By creating a custom Global List View component, we can extend this functionality and provide a more tailored experience for our users. We will walk through the steps of creating the component and provide a sample code that you can use as a starting point for your own implementation.

Insert formatted data (HTML) in Rich Text Area

Here I am going to show you, How  to insert formatted data (table, colorful text etc) in rich text area field salesforce. We can directly use updated rich text area in our email templates without doing any extra code for email template. Here is sample code. //Heading for rich text area content. string body='<h3 style=\"color: #2e6c80;\">your heading :</h3>\n              <ol style=\"list-style: none; font-size: 12px; line-height: 32px; \">\n'; body += '<li style=\"clear: both;\"><b>'+Your Label Name+'  : </b> '+                     yourValue.replaceAll(';',' , ') +'</li>';  body +='</ol>'; yourRichTextAreaField=body; Below code is for table:-

Download JSON File in LWC: Code Examples

Introduction: In Lightning Web Components (LWC), there are times when you may need to download JSON files from your Salesforce application. Whether you're working on a data export feature or need to provide a JSON file for external integrations, being able to generate and download JSON files is a valuable skill. In this blog post, we will explore some code examples that demonstrate how to download JSON files in LWC.  Let's get started!

Full, to Reset Lightning Input Fields in LWC

Introduction: In this blog post, we will explore how to create a full dynamic solution to reset Lightning input fields in Lightning Web Components (LWC). The ability to reset input fields is a common requirement in web applications, and having a reusable and efficient approach can greatly enhance user experience. We will be leveraging the power of LWC and JavaScript to achieve this functionality. So let's get started!

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"