You need to sign in to do that
Don't have an account?
Trigger for round robin lead assignment rule on inbound lead sources
Hi All,
I've created a round robin lead assignment rule on inbound lead sources (see Steps taken so far: below).
However when a lead is entered with a non-inbound lead source (i.e. Conference or Networking) the rule skips a sales rep so it is not fairly distrbuted (see Example of the fail:
below).
I was wondering if anyone has create a Read Only Number field and a trigger that updates it +1 only if the Lead Source is one of the desired inbound ones.
Anyone have any thoughts on this?
_____________________
Example of the fail:
Auto-number: 0000 - Lead Source: Facebook Ads - Goes to Rep 1
Auto-number: 0001 - Lead Source: Conference - Would go to rep 2 but does not because of lead source
Auto-number: 0002 - Lead Source: Networking - Would go to rep 3 but does not because of lead source
Auto-number: 0003 - Lead Source: LinkedIn Ads - Goes to Rep 4
Steps taken so far:
1. Created an AutoNumber custom field on Lead (e.g.,"Lead Number").
2. Created a formula custom field on Lead (e.g.,"Round Robin ID"), data type number, formula =
IF(ISPICKVAL(LeadSource, "Facebook Ads"), 1 +MOD(VALUE({!Lead_Number__c}), 7),
IF(ISPICKVAL(LeadSource, "LinkedIn Ads"), 1 +MOD(VALUE({!Lead_Number__c}), 7),
IF(ISPICKVAL(LeadSource, "Display Ads"), 1 +MOD(VALUE({!Lead_Number__c}), 7),
null)))
3. Created an assignment rule on the Round Robin ID field, whose values will vary between 1 and 7.
- Round Robin ID 1 assign to Rep #1
- Round Robin ID 2 assign to Rep #2
- Round Robin ID 3 assign to Rep #3
- Round Robin ID 4 assign to Rep #4
- Round Robin ID 4 assign to Rep #5
- Round Robin ID 4 assign to Rep #6
- Round Robin ID 4 assign to Rep #7
I am facing a similar problem and I can't find any answer online. Have you managed to find a solution?