+ Start a Discussion
Agathi TsatsaniAgathi Tsatsani 

Auto populate picklist values based on multi-picklist selection

Hello, 

I have a multi-select picklist in Object A, and I need the user's selections to be auto-populated in another picklist in Object B.

For example, if user selects values a,b,c from multi select picklist in Object A, then picklist in object B should be auto-populated with values a,b,c and then the user to be able to select among these. 

I'm aware that picklists cannot be that way dynamic, but is there any idea/ workaround of how this could be deployed?

Thank you, 
Agathi
ANUTEJANUTEJ (Salesforce Developers) 
Hi Agathi,

I don't think this could be possible with standard functionality you need implement your custom solution that you need.

You will have to keep in mind the governer limits while implementing this custom implementation of yours.

Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.  

Thanks.
Malika Pathak 9Malika Pathak 9

Hi Agathi,

IF(ISBLANK( Account__r.Multi_Picklist_1__c ), NULL,
SUBSTITUTE(
IF(INCLUDES(Account__r.Multi_Picklist_1__c, "Industry Type 1"), "Industry type 2; ", NULL) +
IF(INCLUDES(Account__r.Multi_Picklist_1__c, "Industry Type 1"), "Industry type 2; ", NULL) +
IF(INCLUDES(Account__r.Multi_Picklist_1__c, "Industry Type 1"), "Industry type 2; ", NULL) +
IF(INCLUDES(Account__r.Multi_Picklist_1__c, "Industry Type 1"), "Industry type 2; ", NULL) + ".", "; .", NULL))

 

If you find this answer is helpful so mark it as the best answer.