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


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.


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

  • Maybe if the Hierarchical custom setting had 4 fields x 10 combinations = 40 fields on it? – Jeremy Nottingham May 24 '14 at 16:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.