I am looking for solution to enable formula reading for Custom Setting List.I know that for Custom Setting Hierarchy we able to read it from formula.
The only work around is using trigger/apex to read custom setting list which I always think better I include the setting inside object instead of custom setting.
Recently in Salesforce Release: they enable feature Employ Validation Rule Formulas with Custom Metadata Types (Pilot) which give me hope that this will be solution for custom setting list.
Unfortunately when I try, I am not able to implement it.
Scenario : to retrieve different email address for different business unit.
Business Unit ---> Email Address
Account Management -->[email protected]
Business Dev -->[email protected]
I created custom meta data named BusinessUnitEmail with field email . So I inserted Custom Metadata Name and Email with corresponding value but when I try to retrieve I noticed that it bind value with API Name example
$CustomMetadata.BusinessUnitEmail__mdt.AccountManagement.Email , which already specify that this is email for AccountManagement instead of enable me to check if the business unit is 'Account Management'
Is this custom metadata feature only support feature like custom setting hierarchy but not custom setting list?
