• mdc300664
  • 0 Points
  • Member since 2008

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 0
When loading data via data loader into fields that are picklist fields I want records to be rejected if they don't match items from the Pick List for that field. This would help data quality on data loads. If this can be done, I assume it would be via Data Validation rules, but I cannot find any answers as to how it can be achieved. Rather than key in the values manually within the validation rule, it would be desrable for the rule to dynamically lookup up the picklist items - so that the rule wouldn't have to be amended every time a new picklist item was added for the relevant field.