Skip to main content
Solved

Question. Listing 'External Recipients' or 'Internal Recipients' as Single Line Entries, rather than Comma Separated?

  • January 29, 2021
  • 2 replies
  • 137 views

sagan_sherlin
Forum|alt.badge.img+5

Hello!

 

This recently came up as a report request to me, to be able to populate a report based on the ‘External Recipients’ field.  However, with it being a comma separated field - moving them to singe lines to get graph type reporting...isn’t a thing.

 

Looking up another post, I came across “Ability to Report on Internal Attendees from Activity Timeline” in which @HollySimmons asked the same and gave an awesome example!

 

@sai_ram the results of these fields are comma separated strings, if I wanted to split by internal attendees but only have one person on each row how can I do that? 

 

Example:

X attended 3 meetings on their own
Y attended 2 meetings on their own
X & Y both attended 1 together. 

Current output: 

X - 3
Y - 2
X, Y - 1

Desired output:
X - 4 
Y - 3

 

Thank you all!

 

[It would also be wonderful if on the pivot function in Rules Engine, if we could pivot based on comma-separated fields]

Best answer by heather_hansen

@sagan_sherlin you should have an Activity Attendees object that will split them up into separate lines.

2 replies

heather_hansen
Forum|alt.badge.img+14
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • Answer
  • January 29, 2021

@sagan_sherlin you should have an Activity Attendees object that will split them up into separate lines.


sagan_sherlin
Forum|alt.badge.img+5
  • Author
  • Helper ⭐️⭐️
  • February 4, 2021

@heather_hansen New rabbit hole time! Thank you!! =)