UtkarshaPravin SFDC BlogSpot

Concatenation using formula field I want to concatenate four fields in formula field with comma separated value. This is not possible as with normal concatenation you will see additional comma if one of the value is blank. You have to use different combination to achieve this but it will be lengthy process. Suppose, FirstName__c = Utkarsha                  SecondName__c = Pravin ThirdName__c = Raj FourthName__c = Rutuja Then I want if all are blank then show null value else Utkarsha, Pravin, Raj, Rutuja Suppose ThirdName__c is blank then it will show Utkarsha, Pravin, Rutuja I have used SUBSTITUTE functionality to achieve this. IF( AND(ISBLANK(FirstName__c),ISBLANK(SecondName__c),ISBLANK(ThirdName__c),ISBLANK(FourthName__c)),  NULL, SUBSTITUTE(     IF(         NOT(ISBLANK(FirstName__c)),         FirstName__c+ ", ",         NULL...

Run BatchClass To Test Only One Record From Anonymous Window Batch Class Name : updateAccountBatch Record Id for which we want to run batch class : 0010K00001k4YIo Create instance of batch class. Pass parameters to execute method in batch class. Pass null to first parameter Database.BatchableContext BC Pass soql with hardcoded record id to second parameter List<sObject> scope Solution 1: updateAccountBatch updateBatch = new updateAccountBatch(); updateBatch.excute(null,[SELECT Id,name from Account Where Id = '0010K00001k4YIo']) Solution 2: new updateAccountBatch().execute(null,[SELECT Id,name from Account Where Id = '0010K00001k4YIo']);

Open Report in New Window on Record Page In Lightning We can open report in new window from record page in lightning Experience. We will pass report id 00O0K00000B0Egn from ShowReport.cmp. In NavigateToReport.cmp we will get record details of current page. We can fetch any fields on record using force:recordData. In controller, we can form url to navigate and pass paramters to filter values. We can open report in new window using, window.open(url ,'_blank','toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width='+ w +'px,height='+ h +'px,top=50px,left=100px'); After this we will close modal using force:closeQuickAction. We need to create quick action to call ShowReport.cmp on record page button. Don't forget to add quick action in Mobile & Lightning Actions section in page layout . Loading Records - Make a record available for your UI components is to load it. Load the record by inclu...

URL Hack Button In Lightning Experience To Show Report URL Hack button in Salesforce- Classic: In this example, create a list button in Account object. When we click custom button on account detail page, it will redirect to the custom report. You can add URL parameter to the link that represents the report filter. Go to Setup -> Account-> Buttons, Links, and Actions-> New Button or Link. Create a New  button and add to the Buttons in Account layout. /00Ot0000000VeqV?pv0={!Account.ParentId }&pv1={! Account.Id)} Here, 00Ot0000000VeqV : Report Id pv0   :   The “pv” in pv0 stands for “parameter value”, where “0” is the location of the value you want to set. pv1 :  “1” is the location of the value you want to set . URL Hack button in Salesforce- Lightning: Go to Setup -> Account-> Buttons, Links, and Actions-> New Button or Link. Create a New  button and add to the   Salesforce Mobil...

Auto Sync And Unsync Accepted Quote with Opportunity Using Flow And Process Builder Synced Quote is field on opportunity object. This field is lookup field with Quote object.  IsSyncing field on Quote object is not a writable field. As we can not perform any action on IsSyncing field of Quote object. We have to make IsSyncing checkbox true using lookup filed (Synced Quote) on opportunity object.  To automate Quote Sync Process, you have to populate the value in the  Synced Quote field .   1 . Click on   Name | Setup | App Setup | Create | Workflows & Approvals | Flows 2 . Click on   New Flow , it will open flow canvas for you, now create one   Text   variable   VarT_QuoteId  to pass the Quote ID. We will use this variable in the flow, as shown in the following screenshot. Likewise, create one more   Text   variable  VarT_OpportunityId  to pass the Opportunity Id. 3 . The next st...