We're trying to do this in the Quote Line Items (QLI) module but it doesn't really matter which module.
We added a custom multiselect field to the QLI. When a sales person creates a quote, they pick a product from the product catalog and it shows up on the quote. They pick the quantity, add a discount, AND they can select product attributes from a multiselect. This multiselect was originally a dropdown.
When the quote is saved, we want to populate the QLI "Description" field with a concatenation of the product catalog description field and the multiselect. If the Product Catalog "Description" is "Compact drill press with feet controls" and the multiselect choices are "Blue", "6ft", and "Turbine", we want to concatenate them to "Compact drill press with feet controls, Blue, 6ft, Turbine."
When the attributes field was a drop-down, the formula was:
concat(related($product_templates_link,"description")," ",getDropdownValue("xxxx_product_attributes_list",$xxxx_product_attributes_c))
However, now that we've changed the attributes to a multiselect, we can't find the correct formula(s) to retrieve its values. I've looked in the documentation and searches but can't find anything. I'm sure it's easy and right in front of my face, but I've hit a wall.
I always appreciate all of your help in solving my (usually easy) problems.
Thank you!
