I'm try to build a formula using the Formula Builder to capture the Product Family Name of every Opportunity Product and populate that in a custom text field at the Opportunity level.
For example, if there are three Opportunity Products (having Product Family Names as P1, P2 and P3) for an Opportunity, then I would like to add these names as "P1, P2, P3" in the custom text field of Opportunity. But when I'm trying to do this, it is replacing the existing value with new value (if P1 is stored in that text field and I'm adding a new product, then it is replacing P1 with P2)
Could anyone please help me out with this? I would really appreciate it!