You need to sign in to do that
Don't have an account?
Agathi 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
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
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.
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.