+ 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!