function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Indoberto LermaIndoberto Lerma 

Multiple fileds assignment rule

im using an assignment rule for one accont and im trying to use the same one for another account but in the first account i have all the formulas like this

AND( ISNEW(), AccountId = "0011800000AAo4x",
CASE (Case_Code__c,

"AS400 Unavailability", "1",
"AS400 access", "1",
"AS400 Standard change", "1",
"AS400 Change", "1",
"AS400 Support", "1",

"0" ) = "1" )

this include only one fields, but on the second account i will need 3 fields but i dont know how to combine the CASE's ,how can i do this ?

instead of case_code_c i will have 

case_categorization_c
product_c
Type_c

thanks!
Andy BoettcherAndy Boettcher
Keeping in mind formula size limits, you may want to look at using a formula field to concatenate those three fields together and use them in the same CASE statement.  Something to the tune of:

case_categorization_c = 'value1'
product_c = 'value2'
Type_c = 'value3'
Assignment_Formula_field = 'value1value2value3'

Then you can use that "Assignment_Formula_Field" in the case statement above with appropriate values.