Thanks, Martin!
Is it creating 5 different records? Usually it’ll be one record created with 5 contacts attached so you should be able to summarise by meeting id?
Yes, exactly, it's creating 5 unique records. We have the Salesforce to outlook integration turned on so it "autologs" but it isn't helpful if it logs a bunch of duplicates
if i grouped by unique event id
it still doesn't help i'm afraid
since it's generating unique ones
Hi Tessa T., on the Event Report, filter for IsChild = False. That should clear out all the other records and show only the primary event record. So, it does create child records for each additional contact you add to the meeting, that way if one person cancels it doesn't cancel the meeting for everyone. Those child records aren't seen in UI, only the parent with the 5 contacts. The IsChild parameter MAY NOT be accessible in UI so you'd need to create an IsChild__c formula field on the Activity object and reference the standard IsChild function in the formula. Then you could filter the report on the new custom formula field.
Zach S. That definitely helped, thank you! I see there are still some duplicates even when I have IsChild is false if two team members are assigned to the meeting. For example the subject is the same, the contact is the same but the assigned team member is different and activity ID is different. Do you have any advice on that?
Its a different activity/Event record because it's tied to a different internal user. Unfortunately, this is a limitation of Event and Task Object architecture in Salesforce. Activity reporting is difficult sometimes...
