I have dimensions on Contacts in a multiple checkbox drop down associated with a Company. I would like a property on the Company that contains a union of the values of all the Contacts on the Company. The best way to do this SHOULD be with a rollup.
Like this:
- Contact A
- Positions: Center Field, Right Field, Second Base
- Contact B
- Positions: Short Stop, Third Base
- Contact C
- Positions: Third Base, Second Base
Given that (and the contacts associated), the rollup on the Company would be:
- Rollup Positions: Center Field, Right Field, Second Base, Short Stop, Third Base
Workflows are not a great solution because of the logic required to consider the permutations and this is WAY overkill for spending credits on an agent or custom action etc.