You need to sign in to do that
Don't have an account?
1 + 1 = Picklist Value :)
I need your help, looking to see how I can make this work.
When a user selects picklist item 1 (Provider_Type__c) + picklist item 2 (Region_Name__c), the third picklist item (Analyst__c) should be default to a specific item (Jamie Smith)
There are currently 20 items in the third picklist (Analyst__c), however, I would like to specifically only have 1 item be chosen when the specific items chosen from picklist item 1 and picklist item 2 are selected:
So when:
Provider Type = Practitioner
and
Region Name = West
then
Analyst should only equal = Jamie Smith
If user choses picklist item 1 and picklist item 2, then Jamie Smith should be automatically be auto populated into the Analyst__c field prior to saving the record.
I hope this makes sense.
API Names:
Provider_Type__c
Region_Name__c
Analyst__c
Picklist item names:
Practitioner
West
Jamie Smith
Hi,
If u want to populate the third field value before saving the record.
Then it cant happen with formula or workflow rule.
You need to go for a VF page with a controller.
There u can write ur own logic and can populate the thirdfield value before saving.
But since you didn't say that it had to be before save of record, a workflow and fild update should work. If has to be before save, then I agree With other post.