![\"Odd](\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2016\/05\/Odd-Even-Assignment-179x300.png\")
Have you encountered the requirement where you want to assign all Even numbered records to one person and all Odd records to another? Here is a simple solution using the workflow rules that can help. You can use this on custom objects or even on objects that do not have Assignment rules. The requirement can also mean assigning the alternate records to two persons. This is similar to Round Robin assignment to two persons using workflow rules.<\/p>\n
Lets define the requirement as:<\/p>\n
Assign all records of an object that are of even number to “Joe” and odd number records to “Mary”. The odd or even number can come from a custom field “Record Number”.<\/em><\/strong><\/p><\/blockquote>\n
<\/h4>\n
<\/p>\n
Step 1: Auto Number field<\/h4>\n
Create an auto number field with the format {0}. While creating also give number to existing records (although this will not work on existing records unless you update a field used in workflow criteria). This autonumber field will help us identify a record as Odd or Even.<\/p>\n
Lets assume this field is called “Record Number” with an API name as<\/p>\n
Record_Number__c<\/pre>\nStep 2: Formula field<\/h4>\n
Create a Formula field that can give an indication if the record is Odd or Even. Lets name this field as “Odd\/Even” (or you give any name you want). This field will check of our “Record Number” is Odd or Even.<\/p>\n
MOD(value(Record_Number__c),2) +1<\/pre>\nStep 3: Workflow rules<\/h4>\n
Create two workflows – one for assigning Odd records and one for assigning Even records.<\/p>\n
Even\u00c2\u00a0assignment workflow<\/h5>\n
Evaluation Criteria <\/strong><\/p>\n
Evaluate the rule when a record is created<\/p>\n
Note here we have only considered these rules to run only when created. However even if you want you can also use “Every time it is created or updated …” if your requirement is such.<\/p>\n
Rule Criteria<\/strong><\/p>\n
(Name NOT EQUALS ) AND (Odd\/Even EQUALS 1)<\/pre>\nNote here we have used ‘Name’ NOT Equals as Null in the criteria. Since Name is a mandatory field on this object this workflow will fire each time a new record is created.<\/p>\n
Action<\/strong><\/p>\n
Field Update:\u00c2\u00a0Record owner (Even):\u00c2\u00a0Joe<\/p>\n
Odd\u00c2\u00a0Assignment workflow<\/h5>\n
Evaluation Criteria <\/strong><\/p>\n
Evaluate the rule when a record is created<\/p>\n
Rule Criteria<\/strong><\/p>\n
(Name NOT EQUALS ) AND (Odd\/Even EQUALS 2)<\/pre>\nAction<\/strong><\/p>\n
Field Update:\u00c2\u00a0Record owner (Odd):\u00c2\u00a0Mary<\/p>\n
Expanding Odd \/ Even Assignment<\/h4>\n
This rule can be expanded further by having multiple fields in the rule criteria. We can also have a custom checkbox “Assign using an active workflow rule” if you want users to manually select a checkbox on record to assign. Make sure you uncheck the checkbox as a workflow action. You can also expand this to assign to more than two persons – however you will need to create as many workflows.<\/p>\n","protected":false},"excerpt":{"rendered":"
Have you encountered the requirement where you want to assign all Even numbered records to one person and all Odd records to another? Here is a simple solution using the workflow rules that can help. You can use this on custom objects or even on objects that do not have Assignment rules. The requirement can […]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66,128],"tags":[141,117,50,51,142],"class_list":["post-366","post","type-post","status-publish","format-standard","hentry","category-declarative-customization","category-sales-cloud","tag-assignment-rules","tag-sales-cloud","tag-salesforce","tag-salesforce-com","tag-workflow-rules","entry"],"_links":{"self":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts\/366","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/comments?post=366"}],"version-history":[{"count":0,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts\/366\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}