I have picklist fields Level 1 and Level 2, with Level 2 being dependent on Level 1. In total there are probably 100 possible combinations of Level 1/Level 2. I now need, based on the concatenated value of Level 1/Level 2, to bring in another value. I thought about another dependency (Lev 2 controls Lev 3), but there are values in the Level 2 picklist that are common to Level 1...for instance, 'Other'. If I create a formula field, it would be one giant Case formula. And I can't use a concatenation formula field as a controlling field. How can I, in excel terms, perform a vlookup based on the concatenation of Level 1/Level 2 and return the correct value?
Thanks!
6 answers
Thanks All!
So I think I get what Vamsi is saying - create the object and fields. Load data as records into Level 1, Level 2, Value, and also a field that concatenates Level 1 and Level 2.
But how can I pull the Value field from the conv=catenated object over to my main Case object?
Thanks!
