Currently i am creating custom settings to store some configuration values. But, i wrongly entered some data in that and the data is invalid. Is there any mechanism like validation rule kind of thing available for this, so that the data entered into it is validated before it saves to database.?
Attribution to: Bforce
Possible Suggestion/Solution #1
List type of custom settings are not available in validation rules where as Hierarchy type of custom settings are available in validation rules.
Please find the documentation and link
Attribution to: sfdc
Possible Suggestion/Solution #2
There is no way , you can create a validation rule on the Custom settings.To ensure the data entered is correct in your production Org, You need to migrate the custom setting values using Data loader.
If you really want to build a validation rule then the only workaround is to use a custom object but that means the advantages of the Custom Setting is lost (e.g. SOQL call burning)
Attribution to: varun guruvugari
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/33029