Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
dinesh abcdinesh abc 

How to auto populate field with concatanate firstname lastname and multiselect picklist

I have case object firstname and lastname and city multiselect picklist i need to auto populate combination of above 3 fields.
Leon ThanikalLeon Thanikal
Hello Dinesh

You can use a formula field(tesx) to concatenate the different fields that you want.
Below is a sample formula that you can use as a base to solve your problem: 
IF((FirstName__c != NULL), FirstName__c + ' ', '') +  
IF((LastName__c != NULL), LastName__c +';', '') +
IF(INCLUDES( MultiSelect__c  , "1"), "1;", NULL) +
IF(INCLUDES( MultiSelect__c  , "2"), "2;", NULL) +
IF(INCLUDES( MultiSelect__c  , "3"), "3;", NULL) +
IF(INCLUDES( MultiSelect__c  , "4"), "4;", NULL) +
IF(INCLUDES( MultiSelect__c  , "5"), "5;", NULL) +
IF(INCLUDES( MultiSelect__c  , "6"), "6;", NULL) +
IF(INCLUDES( MultiSelect__c  , "7"), "7;", NULL)

The only thing is that you have to enter the different multiselect values in the section that has the includes.

Hope this helps!
Mosh HamedaniMosh Hamedani
Our web scraping Service provides high-quality structured data to improve business outcomes and enable intelligent decision making,Our Web scraping service allows you to scrape data from any websites and transfer web pages into an easy-to-use format such as Excel, CSV, JSON and many others.