A client was using Campaigns heavily and wanted to see the Created/Last Modified fields of the members. When the request came in I thought this will be easy, I’ll just update the selected columns on the Campaign Member related list and voila!

Except… when I went to edit the Campaign page layout the Campaign Members related list had no such fields available to choose! But I was determined I could come up with a solution.

campaign_member_no_who_fields

Baffled, I employed a simple trick to expose the fields: I created formula fields whose values were the very fields I wanted to reference!

I created four custom formula fields on Campaign Member object whose values were the same as the standard fields:

Created Date =
  CreatedDate
Created By =
  TRIM( CreatedBy.FirstName & " " & CreatedBy.LastName )
Last Modified Date =
  LastModifiedDate
Last Modified By =
  TRIM( LastModifiedBy.FirstName & " " & LastModifiedBy.LastName )

Magically I was now able to add these new custom fields to the Campaign Member related list on the Campaign page layout.

campaign_member_yes_who_fields.png