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
AbAb 

Update one of the picklist value depending on other value

Hello,

I have picklist A, Piclkist B with below values
picklist_A__C
  1
  2

Picklis_ B__C
 A
 B

When the value is 1 then A is selected automatically and when the value is 2 then the value B is selected by default

thanks for suggestion !
Best Answer chosen by Ab
Maharajan CMaharajan C
Hi Sandrine,

We have two options:

1) If you use the workflow then you have to create two workflows.

Workflow->new rule->choose the object->Evaluate the rule when a record is created, and every time it's edited->rule criteria : picklist_A__C Equals 1->save & next

Add WF action -> Field to update->Object->Picklis_ B__C->specific Value ->A->Done->Activate.

Repeat the same things for second WF but change the criteria picklist_A__C Equals 2 and Field to update->Object->Picklis_ B__C->specific Value->B.

2) Otherwise Use the single Process builder.

Setup->Process Builder->new->Choose Object->Start the process(When a record is created or Edited)

Add Criteria->Condition are met->Choose the field(picklist_A__C) Operator(Equals) Type (Picklist) Value 1
Immediate Action->Action Type (Update Record)->RecorType(First Option)Select the record that stareted your process->No Criteria->Field( Picklis_ B__C),Type(Picklist),Value choose as A ->Save

Add Criteria->Condition are met->Choose the field(picklist_A__C) Operator(Equals) Type (Picklist) Value 2
Immediate Action->Action Type (Update Record)->RecorType(First Option)Select the record that stareted your process->No Criteria->Field( Picklis_ B__C),Type(Picklist),Value choose as B ->Save

Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj

All Answers

D-CoderD-Coder
check this :

https://developer.salesforce.com/docs/atlas.en-us.fundamentals.meta/fundamentals/adg_simple_app_adv_field_dependencies_try_it_out.htm
D-CoderD-Coder
If this answers your query please mark this question as a solved so that we can filter it out from unsolved questions.
AbAb
I dont want to do it with dependent list, i am looking a slution with workflow field update
D-CoderD-Coder
It can not be done using workflow field update.

"When the value is 1 then A is selected automatically and when the value is 2 then the value B is selected by default"
There has to be some mapping between 1 & A , 2&B in order to achieve it without dependent picklist. Could you share details about it ?
Maharajan CMaharajan C
Hi Sandrine,

We have two options:

1) If you use the workflow then you have to create two workflows.

Workflow->new rule->choose the object->Evaluate the rule when a record is created, and every time it's edited->rule criteria : picklist_A__C Equals 1->save & next

Add WF action -> Field to update->Object->Picklis_ B__C->specific Value ->A->Done->Activate.

Repeat the same things for second WF but change the criteria picklist_A__C Equals 2 and Field to update->Object->Picklis_ B__C->specific Value->B.

2) Otherwise Use the single Process builder.

Setup->Process Builder->new->Choose Object->Start the process(When a record is created or Edited)

Add Criteria->Condition are met->Choose the field(picklist_A__C) Operator(Equals) Type (Picklist) Value 1
Immediate Action->Action Type (Update Record)->RecorType(First Option)Select the record that stareted your process->No Criteria->Field( Picklis_ B__C),Type(Picklist),Value choose as A ->Save

Add Criteria->Condition are met->Choose the field(picklist_A__C) Operator(Equals) Type (Picklist) Value 2
Immediate Action->Action Type (Update Record)->RecorType(First Option)Select the record that stareted your process->No Criteria->Field( Picklis_ B__C),Type(Picklist),Value choose as B ->Save

Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj
This was selected as the best answer