+ Start a Discussion
jonathanrico.jonathanrico. 

Formula Fields Translated Values

Hello Everyone,

 

Does anyone know if its possible to bring the translated value of a Picklist field in a Text Formula Field.

 

I currently have a status picklist field in Object A. Object B is a detail of Object A and I need to display the value of the status field in Object B.

 

I need to support multiple languages, however, when using translations the picklist label translates perfectly at the Object A level but the child records of Object B display the original value.

 

I guess formula fields always retrieve the master labels, is there anyway to get around this in order to get the translated value?

 

Thanks in advance!

Best Answer chosen by Admin (Salesforce Developers) 
Ispita_NavatarIspita_Navatar

I think this is an idea for this type of problem faced by another person. You can go and promote the idea and may be in the subsequent releases this may be released as a feature.

 

The following was the response to such a post:-

 

I have investigated this request 
and have found that there is no practical
way of returning the translated value in the
formula field using the standard
functionality of Salesforce.


Something you could look into
would be to use a trigger to return
the translated value by incorporating
the function mentioned on this page:
http://www.salesforce.com/us/developer/docs/api/Content/sforce_a

 

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.

All Answers

Ispita_NavatarIspita_Navatar

I think this is an idea for this type of problem faced by another person. You can go and promote the idea and may be in the subsequent releases this may be released as a feature.

 

The following was the response to such a post:-

 

I have investigated this request 
and have found that there is no practical
way of returning the translated value in the
formula field using the standard
functionality of Salesforce.


Something you could look into
would be to use a trigger to return
the translated value by incorporating
the function mentioned on this page:
http://www.salesforce.com/us/developer/docs/api/Content/sforce_a

 

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.

This was selected as the best answer
jonathanrico.jonathanrico.

Thanks Ispita,

 

I'll vote for the idea right away, I guess I'll need to work with triggers to get around this.

 

Thanks again for your quick response!

Ispita_NavatarIspita_Navatar

anytime.. happy to help