Skip to main content


Send WhatsApp and Save Chat using Lightning Component Salesforce | Salesforce Tutorials

Recent posts

Sort Picklist Values in Lightning Component Salesforce | #Salesforce Tutorials

In this article you will learn to sort the values in Picklist in Lightning Component. You just have to add an additional line to your controller or helper of your Lightning Component.
In below code I am getting my Picklist values by "fetchPicklistValues" function. In the picklist I am having numeric values from 1 to 12.
Without sorting the result will be 1,10,11,12,2,3,4,5,6,7,8,9 but after sorting the result will be 1,2,3,4,5,6,7,8,9,10,11,12
Please check below code line number 18 for sorting.
Controller 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34fetchPicklistValues:function(component, fieldName, elementId, plType) { var action = component.get("c.getselectOptions"); action.setParams({ "objObject": component.get("v.objInfo"), "fld": fieldName }); var opts = []; action.setCallback(this, function(response) { if…

Formula to get time zone based on Area Code in Salesforce

In this article you will learn to create a formula to get the time zone based on Area Code in the phone number field in Salesforce.
Please follow below formula code :
if( ISBLANK(Phone),"--",

if( CONTAINS("206:209:213:253:310:323:360:408:415:425:503:509:510:530:559:562:604:619:626:650:661:702:707:714:760:775:778:805:818:831:858:867:909:916:925:949:951:971:236:250:604:778:867", left(SUBSTITUTE( Phone , "(", ""),3)),"UTC-8 Pacific",

CONTAINS("208:250:303:307:385403:406:435:480:505:520:602:623:719:720:780:801:928:970:403:587:780", left(SUBSTITUTE( Phone , "(", ""),3)),"UTC-7 Mountain",


APEX Trigger and Test Class to Prevent Account Deletion | #Salesforce Tutorials

In this article you will learn to create a Before Delete Trigger and Test Class to prevent Account deletion based on a field's value condition.
Please follow below code : 
Trigger 1 2 3 4 5 6 7 8trigger beforeAccDeletion on Account (before delete) { for(Account acc : trigger.old){ if(acc.myField__c !=null){ acc.adderror('Can not delete the Account if myField is available'); } } }
Test Class 1 2 3 4 5 6 7 8 9 10 11 12 13 14@isTest privateclass beforeAccDeletionTest { static testmethod void testAccDelete(){ Account acc =new Account(); acc.Name='Acc1'; acc.myField__c='AnyValue'; insert acc; try{ delete acc; }catch(DMLexception e){ system.assert(e.getMessage().contains('Can not delete the Account if myField is available'),'Can not delete the Account if myField is available'); } } }
Check other p…

Change Background Color in Lightning Data Table Salesforce

In this Article you will learn how you can apply some custom CSS in Lightning Data Table and change the Background and Text Colors.
Please follow below code : I have applied some custom css to below Lightning Data Table to change the Background Color, Text Color and Hover Color.
Note : You have to override default hover CSS.
Component.cmp 1 2 3 4 5<lightning:datatablekeyField="id"data="{! v.recordList}"class="myCss"columns="{! v.columns}"hideCheckboxColumn="true"/>
Style.css 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20.THIS { } .THIS .myCss thead th span{ background-color:#3258a8; color: white; } .THIS .myCss td { background-color:#fffbdb; color: black; } .THIS .myCss tr { background-color:#fffbdb; color: black; } .THIS .myCss td:hover { background-color:#ffed63 !important; color: black !important; font-weight:bold !important; }

Check other posts as well !

Please check below links also…

Trigger Assignment Rules on Update or Upsert using Data Loader | #Salesforce Tutorials

Hello guys,
In this Article we will do some work around Assignment Rules. As you are aware Assignment Rule can be trigger on Insert actions. Either it could be manually or through an Automation process.
What if you have to reassign list of records ? 
Export all the records then delete them, then insert them using the new assignment rule is not sounds like a good idea 😑 
To get rid of this solution you have to use data loader. 
Yes, using data loader we can trigger the Assignment Rule on update & upsert also.
Follow below steps to add the Assignment Rule Id in Data Loader : 
Find the Assignment Rule IDNavigate to the assignment rule that you want triggered for this import/updateIn the address bar for your browser, copy the 15 digit ID that starts with "01Q"Add the Assignment Rule ID to the Data Loader SettingsOpen the Data LoaderPress the "Settings" drop down menu, and click "Settings"In the "Assignment rule" text box, paste the Assignment Ru…