function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
nickfs92840nickfs92840 

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

 

 

 

 

@anilbathula@@anilbathula@

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.

 

 

DarrellDDarrellD

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.