Administrator Admin - 6 months ago
For those looking for a solution to display the label vs the api using a formula field here is a solution.
[ Picklist ]
Field Label API Name
Stage 1 API_1
Stage 2 API_2
Stage 3 API_3
Stage 4 API_4
[ Custom Label ]
Short Description. Name. value.
Stage 1 LB_API_1 Stage 1
Stage 2 LB_API_2 Stage 2
Stage 3 LB_API_3 Stage 3
Stage 4 LB_API_4 Stage 4
Here is the formula I put in for a custom field in the related object.
IF(ISPICKVAL( Contact.contact_status__c , "API_1"), $Label.LB_API_1,
IF(ISPICKVAL( Contact.contact_status__c , "API_2"), $Label.LB_API_2,
IF(ISPICKVAL( Contact.contact_status__c , "API_3"), $Label.LB_API_3,
IF(ISPICKVAL( Contact.contact_status__c , "API_4"), $Label.LB_API_4, null))))
Karen Plaskon - 7 months ago
This gap has significant negative impacts when working across integrated systems in which one expects the API abbreviation but another requires the label. The inability to meet these competing requirements without custom code is disappointing, particularly given the idea has been out there for 3 years.
Menno Egbers - 8 months ago
From a developer point of view something basic like this should be a standard out of the box supported functionality. Most of the time Salesforce blows my mind by the amount of powerfull options. BUT, everyone now and then... POEF! They unpleasantly surprise me by some seemingly obvious shortcomings...
Benjamin Regler - 9 months ago
very bad implementation. Once again, endless and ridiculous workarounds are required to reach the "obviously easy and should be a no brainer out of the box" target. Who in the world would care about the API name in formula fields, which are mostly created to concatenate field values for UI display purposes only? This missing feature, along with the lack of having translated values from the translation workbench in formulas is really a very frustrating thing.
It would be very helpful to get some function like LABEL(<PicklistField>) or TRANSLATE(<PicklistField>). I assume it would not be rocket science. You got my vote!