Mass Updating Multi-Select Picklists

A multi-select picklist field is a specific type of field where multiple values can be stored in that field as an array, or list. For example, in a "Contact Role ID" Field, one contact record can have multiple contact roles associated with it (Billing Contact, Mailing Contact, Organization Contact, etc.). In contrast, a standard picklist field can only store one value in the record. 

Because a multi-select picklist field allows for multiple values, the mass update feature within Rhythm allows you to make a range of updates to the records selected in your query or file instead of a "standard" mass update, which replaces or adds one value to the data field. When mass-updating a multi-select picklist, you can:

1. Replace or add values for the first time to a multi-select picklist
2. Add a new value to the Beginning of the multi-select picklist
3. Add a new value to the End of the multi-select picklist
4. Remove a value from the multi-select picklist

Medium of Update

1. Please see this knowledge base article for where to conduct mass updates
2. If you are conducting your mass update in a query or through a quick search you will be presented with a screen to enter your new values for the multi-select picklist field chose
3. If you are conducting your mass update through a file, you will need to put the values in a column in the desired format below

Helpful Hint: If the values you are updating have commas in them, you can use (d|) before the expression. This will make the | the separator of values in your expression. For example, + (d|) [BILLING-CONTACT|PRIMARY-CONTACT].