Is Process Builder the right solution to update multi-select picklist based on checkbox selection? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Chris NiyorkChris Niyork 

Is Process Builder the right solution to update multi-select picklist based on checkbox selection?

I have a 4 check boxes on the Account page.
Also have a multi-select picklist, "Products" on the same Assount page with the same values.

Example: Hamburger check box, Hot Dog check box, Fries check box and Cola check box.

I built 1 PB with 4 individual decisions for each Product. (when a record is created or edited)

Example:
Hamburger equals true - Update record, Products, multi select picklist, Hamburger >  Evaluate the next

Hot Dog equals true - Update record, Products, multi select picklist, Hot Dog >  Evaluate the next

Fries  equals true - Update record, Products, multi select picklist, Fries > Evaluate the next

Cola equals true - Update record, Products, multi select picklist, Cola > Stop

When I check Hamburger and Cola in the same save operation, only Cola is displayed in the Products multi select section.

I've tried the PB with Advanced > Recursion... on and off. No difference.

* the Products picklist (Multi-Select) Options are set to # Visible Lines10

Then I made another edit (leaving Hamburger and Cola checked) but added one additional check to Fries, then only Fries displayed in the Products picklist (wipes away Cola from the multi-selct picklist but hamburger, cola and fries are still checked).


TIA for thoughts.
 
Josh HumphreyJosh Humphrey
To begin with, I would advice you to convince your client to not to use the Multi Picklist. Working with Multi-select picklist fields can be a difficult as they have a lot many restrictions and considerations including reporting, validation, mass updates, etc.

Coming back to your problem, you can update the Multi picklist using process builder, but then you will have to include all the possible combinations in your process for different values of checkboxes.
A better solution would be to write a trigger in this case. I would consider moving away from Mult-select picklists.