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
    ) +
    IF(
        NOT(ISBLANK(SecondName__c)),
        SecondName__c + ", ",
        NULL
    ) +
    IF(
        NOT(ISBLANK(ThirdName__c)),
        ThirdName__c + ", ",
        NULL
    ) +
    IF(
        NOT(ISBLANK(FourthName__c)),
        FourthName__c + ", ",
        NULL
    ) + ".",
    ", .",
    NULL)


Comments

Post a Comment

Popular posts from this blog

Syncing And Unsyncing Quote With Opportunity Using Flow And Process Builder

Image
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...
Read more
Image
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...
Read more
Image
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...
Read more