0

I need a field on my contacts that will have the name of all of the opportunities concatenated. Rollups do not seem to work, because they only do numbers. Formula fields do not work.

1 Answer 1

1

There might be a better solution, but I used Process Builder to create a visual workflow to run whenever an Opportunity is created.

The Steps in the flow go thusly:

  1. Lookup Opportunity to get ContactID. (might be able to pass this in through process builder)
  2. Fast lookup to create collection of the relevant opportunities.
  3. Loop through collection. I use LoopVariable1
  4. Assignment action - add LoopVariable1.Name to another variable (varAllOppNames)
  5. After loop, record update contact with that variable.

For bonus to make it look nicer, I added a decision element inside of the loop so that it would point to two different assignment actions. The one mentioned above, and another that would include a ", " before the second opportunity name. I created another variable called varIteration and the assignments add 1 to it. The decision checks if varIteration =0 and will point it accordingly.

1
  • 1
    I'm just posting to say that I found this when googling for the same problem, and it's very helpful. I love the tweak that only adds commas when needed. Thanks!
    – user3515
    Mar 5, 2018 at 17:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.