Create,update and Query records using Javascript button in Salesforce

Lots of Use Cases can be achieved without Apex codes and could be done by Administrators without requiring the help of the developers. Custom Buttons can execute JavaScript on click to perform DML operations. We would be taking an example to create Contact record by clicking on a button placed on Account detail page, will also explain how to query and execute apex using JavaScript.

Step1 : Creating a custom button on Account Object. Click Setup--> Customize --> Accounts --> Buttons, Links, and Actions. Click on New Button or Link and enter information as mentioned in the screenshot below:

Javascript Code :

{!REQUIRESCRIPT("/soap/ajax/33.0/connection.js")}
{!REQUIRESCRIPT("/soap/ajax/33.0/apex.js")}

var Cont = new sforce.SObject("Contact");
Cont.AccountId = '{!Account.Id}';
Cont.lastName = prompt('Enter LastName','');

var result = sforce.connection.create([Cont]);
if(result[0].getBoolean("success"))
{
alert('Contact Created');
window.location.reload();
}
else{
alert('Error : '+result);
}

After pasting the JavaScript Code click on Save

Step 2: Add the Newly created button to the account layout. Edit account layout and drag the Create Contact button on the layout.

All set, Now click on the Button in the account detail page , enter the last name of the contact and Boom!! You would see the contact created below the account.

Querying Objects using JavaScript
Below Script can be used to query all the Contacts records.

var ContactRec = sforce.connection.query("SELECT id,LastName 
FROM Contact WHERE AccountId = '{!Account.Id}'");

records = ContactRec.getArray("records");

  for (var i=0; i< records.length; i++) {
    var record = records[i];
    alert("Contact Lastname"+ record.lastName + "Contact Id -- " + record.Id);
  }

Comments are appreciated :)