Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS CRM 3.0 - Lead Workflow HELP needed

Posted on 2008-10-31
6
Medium Priority
?
533 Views
Last Modified: 2013-11-24
I am trying to setup a workflow for lead entity in crm 3.0. However, I can't seem to get anything to work. When I have gotten something to work, I get stuck in a loop and the emails just keep triggering and don't stop. So I'm starting from scratch once again and here is the workflow I need to setup somehow:

After a lead is assigned to a sales person, I need to determine that they "accept" or "decline" the lead. To do so I have created a custom picklist for them to pick "accept", "decline", etc.

Parallel to this, I created a custom "due date" for them to take action on this lead. So the person entering the lead gives the lead some kind of deadline based on the customer discussion. It doesnt work to always set the deadline 3 days out from assignment due to holidays, weekends, etc.

Here is what I would like to happen:

(1) If they hit "decline", have that lead reassigned back to me
(2) However, with the "due date" in mind I mention above, I need to know by this date if the field is still null so that I can get an email and follow up with the sales person as to why they haven't "accepted/decline" the lead.

This doesnt seem hard on paper but I can't get it to work in a workflow format.

Please let me know if you have any suggestions. I don't know code, just have to use whats in CRM workflow configuration.
0
Comment
Question by:AB021
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 15

Assisted Solution

by:WilyGuy
WilyGuy earned 2000 total points
ID: 22854797
Couple of quick thoughts.  You are talking about changing the Owner?

What kind of rights do you have in the system?
0
 
LVL 15

Assisted Solution

by:WilyGuy
WilyGuy earned 2000 total points
ID: 22854822
Also, are there multiple people assigning these? (if they hit decline, it should ALWAYS come back to "you"?)
0
 

Author Comment

by:AB021
ID: 22854888
Assinging lead from sales person is essentially changing the owner, I am the owner when I create the lead and then I assign the lead to a sales person so they become the owner.

I have full admin rights. But other people will be assignging the leads as well and they won't have full admin rights.

Yes, multiple assigning and if they hit decline, it should always come back to me, only me.
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 15

Assisted Solution

by:WilyGuy
WilyGuy earned 2000 total points
ID: 22854979
OK, so first, I am not going to use NULL, so I would create a third picklist value of "Assigned" and make that the default value.

So the first workflow should be easier than the second, because you are looking for a "change event" from Assigned to Decline.

What do you want to happen to the date if it is accepted?  in other words, we have this date that is not supposed to be exceeded, so what is going to change it?  Are we blanking it out if it is accepted, or is the meter still running?  Are you making it so the user can change it or is it in some way hidden?
0
 

Accepted Solution

by:
AB021 earned 0 total points
ID: 22868453
the only probem with having "assigned" as the default is that the sales person will most likekly never change anything and never act on the lead, but meanwhile I think that they've accepted it becuase they never clicked "declined". So I am trying to force them to say "accept" or "decline".

In regards to the date, I am not 100% sure how to tackle it. Basically, I wanted there to be some kind of due date for the sales person to accept/decline or just "act" on the lead somehow. However, I just want an email/alert to trigger to me if that date passes so I can see that they have not responded to the lead being assigned to them.

If they do accept the lead and the date passes, then I dont need an email sent to me. OR it could be I get an email no matter what with just the updated status on that due date.

I hope that makes sense, I'm just not sure if I'm trying to load too much into 3.0 version or if others have figured this out. Seems like a common business process for CRM.
0
 
LVL 15

Assisted Solution

by:WilyGuy
WilyGuy earned 2000 total points
ID: 22871990
the "Assigned" gives you a few things:
1. you don't have to query against NULL
2. you can create a new default view using Assigned as the key (sort of a queue for them)
3. you could likely add some onSave script to force them to change it, definitely more out of the box.

You need 2 workflows as far as I can see.
1. checks the save of a Sales Lead for change to the Accept Decline field.
   a. changes ownership on Decline back to you
   b. if you don't employ script above, you could force the ACCEPT for any save by the owner?
   c. sends email to you either way on a change to Decline or Accept
2. queries all leads for Due Dates that are older than today
   a. sends email to you
   b. could also change ownership as well.

Is that what you have and you can't get it working?  Maybe let me see what you have (so I don't reinvent the wheel)

0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question