According to this article (https://help.salesforce.com/articleView?id=custommetadatatypes_validation_rules.htm&type=5) we can use Custom Metadata in a formula now. What I'd like to know is how extract the value based on the field label? This article seems to suggest we can only use the field name, not a specific record of the metadata (if there is more than one record).
My Custom Metadata needs to contain different text data to be used based on some criteria ie 'if fieldx = 'ABC' use the text value from the field 'Next Steps' where label = 'Funds Due', else use text from where label = 'Default'. I want to use this for an email template. This is my Custom Metadata, with currently only the 1 custom field for the text.
This is in my records (Manage metadataRecordNameFields)
Should I instead be creating multiple fields (ie 'Next Steps Default', 'Option1', 'Option2'...)and have only 1 record, or should I have multiple records where the field label identifies the value in 'Next Steps' (as I have now)?
If I try and create a formula field, my 'Next Steps' field does not show up - why not? I have set the Field Usage to 'Public'.