+ Start a Discussion
nagachandra knnagachandra kn 

How to get translated picklist values in a formula field

Hi,

I have a picklist field on contact called function__c and each value of the picklist has translation enabled. i have another object called contact team member which is related to contact by master detail and it has a formula field which is assigned the picklist value from contact.

But when i change the language, translation value is not showing up in formula field. please help me with this ?


 
salesforce mesalesforce me
hi check this once...


I have investigated this request <br>and have found that there is no practical <br>way of returning the translated value in the <br>formula field using the standard <br>functionality of Salesforce.<br><br><br>Something you could look into <br>would be to use a trigger to return <br>the translated value by incorporating <br>the function mentioned on this page: <br><a href="http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_tolabel.htm" target="_blank" rel="nofollow">http://www.salesforce.com/us/developer/docs/api/Content/sforce_a</a>