function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
svpsvp 

Custom settings in formula fields.

Hi
Can someone give some workaround on how to use custom setting in formula fields. Any help is highly appreciated.


Thanks,
svp

Laxman RaoLaxman Rao

You can only access hierarchy custom settings in formula field and validation rules.

Here is the generic syntax: {!$Setup.CustomSettingName__c.CustomFieldName__c}

 

You can refer this :

http://blog.jeffdouglas.com/2010/02/08/using-hierarchy-custom-settings-in-salesforce-com/

Praful GadgePraful Gadge

Hi,

 

We can use custome setting in formula field. Under the header "Simple Formula" you can "Select Field Type" i.e. Field Type starting with "$Setup" are nothing but custome setting objects. Like:  $Setup.LinkForce_Settings__c.Base_URL__c.

 

Note: You can add only Hierarchy TypeCustom Setting.

 

Let me know your feedback.

 

Sincerely,
Praful G.

svpsvp

Thank you (both of you) reply.

 

Im using List Type Custom setting, is it possible list types in formula filed ?.

 

 

Regards,

svp

Laxman RaoLaxman Rao

You cann't use list custom setting in formula fields.

svpsvp

Thank you Laxman Rao.