+ Start a Discussion
BabluBablu 

When an agent changes the lead status to Unqualified we need to capture the Name of the user who changed the status to Unqualified and date also

When an agent changes the lead status to Unqualified we need to identify the Name of the user who changed the status to Unqualified and date also in two dieffernt fields (Unqualified by , Unquliafied date)

1. Unqualified by : we need to disply the user name who unqulaified the Lead
2. Unqualified Date : We need to disply the date/time of the Unqualification 

Thanks in advance.
Bablu
Beer NutthawanBeer Nutthawan
Hi Bablue

Did you mean to get the Agent name, which is a person who changes the Status and the Date? 
Are these 2 fields in Opportunity object? 

If so, then you can create the following actions(no coding):
1. Create 2 files
  • Unqualified by    ===>> Text field
  • Unqualified date === >> DateTime field
2. Create a new workflow rules, Rule Criteria Opportunity: Stage EQUALS Unqualified
I just assume  that the status "Unqualified" is a new one item added in Status field of Opportinity. 

3. Create 2 fields updates for these 2 fields, which when the Agent change status to "Unqualified" it will update these 2 fields: 
  • Unqualified by     >>  Formula Value will be : LastModifiedBy.FirstName + ' ' + LastModifiedBy.LastName
  • Unqualified date  >> Formula Value will be :  LastModifiedDate
So, here is my workflow rule, 

User-added image

Hope this will help you!! 

Nutthawan.Beer