I have got two picklists with Field Dependencies: "CODE" & "TEXT" e.g. (Code = A99) --> (Text = "Diodes")
I like to have an automatism field filling, when a value in CODE is picked the field TEXT is filled automatically.
How do I do this?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
Sounds to me like a better way to do this would be to have a lookup to your Codes in a related object. This would work provided there is always a 1:1 relationship between the value in Codes and Text.
You could then drive the Text value using a cross-object formula field that also showed the text value.
So the steps:
There are some downsides:
But there are an upside: