We have field Country__c on Contact object.
- This is a picklist field with the 'Restrict picklist to the values defined in the value set' option checked as true.
- Also, we have another old validation rule on same field to restrict invalid as well as null values through vlookup on custom setting list for countries.
Problem: When inserting contacts through data loader, blank value is allowed for this field. This is something weird as either of the two, i.e. restrict picklist option or validation rule didnot return an error to this. Also, another observation is that only if I uncheck the restrict picklist option, then the validation rule triggers and doesnot allow the blank value. This test was done through developer console.
Can someone help me understand this behaviour.
Thanks,
Surabhi
5 respuestas
It looks like a longer way of writing the same thing. Why would the OR way's return true? It should only return true if your vlookup condition is true, or if the country is empty.
