[SalesForce] Custom Settings – Validation Rule

We have a custom setting (AllowableCombinations__c) that has the following fields

Queue,Type,Name,Area

It has 10 records containing the different allowable combinations of Queue/Type/Area and Sub Area.

We want to know whether it is possible to create a validation rule that can throw error if the record to be saved does not contain any of the combinations using the combinations from the custom setting.

I know we can accomplish this via trigger or via hierarchial picklist.(.but that helps only when the record is created from UI ) but we really want to know whether it is possible to enforce this lookup validation via custom settings.

Best Answer

Nope. Only Hierarchy settings can be accessed using $Setup global in validation formula context.

Related Topic