Benjamin Regler - 10 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!
Dan Schumacher - 10 months ago
Totally agree with others that this request should be given a higher priority in the Salesforce backlog. With many companies moving to the Salesforce platform, we still have legacy systems in tow that still require data to be synced. Having the ability to reference a picklist field's API Names vs. Labels would be very helpful in preventing unnecessary coding and in streamlining formulas.
Justin Slagle - 1 year ago
Having the same issue that others have described:
Has anyone here come up with a workaround for this issue? I've considered the following options (though neither is really what I'd call acceptable):
Hadi Uppal - 1 year ago
This is a bug, not a feature. Why would any user every want to see the API Name of a picklist value? SF introduced API Names on picklist values for integration purposes knowing that API Names would be a code.
This requires additional effort to achieve the solution and additional overhead which will be in vain when Salesforce decides to fix this bug.
Peter Rizol - 1 year ago
This would be a useful capability. In my use-case, I need to get a queue ID and a queue name. It would have been easy if Salesforce allowed a lookup field to reference a queue. However, since that's not a current feature, I was hoping to use a picklist field with label = Queue Name and API name = Queue ID, and just reference that information via a formula, but can't get the label through formula :-(