I'm in higher education, and we use our org to manage the admissions process. Emails, reporting, all of that is a breeze, but we also send out some essential information by way of our postal fulfillment center. We communicate with the fulfillment center by sending reports so that they know what to send to whom. That's also going swimmingly.
The problem is that for customer service reasons, I need to have other users be able to see a list of reports that contained the contact they are viewing, and the date that they were included in the report.
How can I log a new activity or update a field on the contact object when a contact appears in a report?