- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
01-16-2013 09:16 AM
I need to assign a value of picklist to another picklist. But those two picklists are same, picklist name is Status with values 'Open', 'Close'.
These two picklists are in different places, if one picklist value modifies, automatically another picklist value should update.
Note: Both fields must be picklists.
I tried field update with workflow rules using the below formula, but it doesnot work.
IF(Picklist1_Value__c <> Picklist2_Value__C, Picklist2_value__c, false)
IF(Picklist2_Value__c <> Picklist1_Value__C, Picklist1_value__c, false)
01-17-2013 04:32 AM
If the picklists are on the same object, you could run into a WF order of execution problem. Since you can't control which WF runs first, when you change Picklist_1, if the WF that checks it runs first, it will just reset the value back to Picklist_2. You could try adding the ISCHANGED(Picklist_1) and ISCHANGED(Picklist_2) to each of the WF so either will only apply to the edit if the correct field changed.
01-17-2013 08:30 PM
Ok, as you said i can put a rule in WF with ISCHANGED(Picklist1__c). If Picklist1 changes the value, then i need to assign that value to antoher picklist. But how do i know which value selected Picklist1__c and how can i assign that value to Picklist2.
Using 'Immediate Workflow Action -> Field Update Type ' i can't update same value of Picklist1 to Picklist2.
Because i dont know which value selected in Picklist1.
How to resolve this problem.