Skip to main content

We are trying to find a better way to differentiate between our products with product codes from SFDC. Is it possible to populate a custom attribute with multiple values? We have global context, but it does not define the multiple ways our products are broken down, i.e. standard, pilot, lite, etc.

If you had 3 fields, like:

Account->Product A Package

Account->Product B Package

Account->Product C Package

 

You could combine those to a single string using any sort of formatting that differentiates the keys from the values, and multiple fields from one another. So a field like Account->Product Packages might have a value like:

productA:standard,productB:lite,productC:standard

Then you can filter on that like:

Account->Product Packages CONTAINS “productB:lite”

or

Account->Product Packages NOT CONTAINS “productA:enterprise”

All that said, that combo field needs to be updated from a single source of truth. The value in the field can be a string that signifies many things, but it’s a single value nonetheless; you can not have multiple data sources append the field value. Each update will overwrite the previous value


@rschlette I like that idea! The information is being fed from Gainsight CS, so would just have to figure out how to write the rule to combine all of the relationships into one field before passing over.