Our workflow:

  • The Account Rep creates an opportunity.
  • At the appropriate time, they 'request' a Consultant. This is done in SFDC with a checkbox "Consultant Requested"
  • This checkbox triggers an email to a Team Lead who would assign a specific Consultant, based on a number of factors.
  • The Team Lead goes to the SFDC Opportunity and adds the chosen Consultant to the Opportunity Team.
  • Upon addition to the Opportunity Team, an email is fired to the Consultant to inform them they are assigned.

The Problem:

  • Our Account Reps have access to add Team Members to their opportunity (to add executives to their sales opportunity), and will occasionally assign a Consultant to the Opportunity as well.
  • Even if it is the correct Consultant, the issue with this is that the Team Lead has to monitor and report assignments.

Some ideas for a solution:

  • Can we see who added a team member to the opportunity in some report?


  • Can we include in the triggered email some variable that indicates who has added them?

It currently says:

The following opportunity has a request for a Consultant and has been assigned to you. Please review.

XYZ Account Name

XYZ Opportunity Name


Can we make it say:

The following opportunity has a request for a Consultant, and has been assigned to you. Please review.

XYZ Account Name

XYZ Opportunity Name

Added to Opportunity Team by [Joe Smith]


  • Are you currently tracking the team lead in a lookup on the Opportunity, per chance?
    – Adrian Larson
    Commented Nov 3, 2016 at 1:58

1 Answer 1


Are you trying to Add a Team Member in Opportunity related list Or A field(Lookup to User Or simply a Text field) is being updated for Consultant?

-> If it is adding a Team Member you can get details from CreatedBy/LastModifiedBy from Opportunity Team Member Object

->If you are Updating a field(say lookup to user) you enable History Tracking for this field which will keep track of "who changed the value" & "From what to what it has been changed".

  • I needed history tracking. This was the value change that I needed to see. Thank you so much. Commented Nov 10, 2016 at 19:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .