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
sana240sana240 

How to validate pick values which creating records using data loader

Hi All,

I have defined some pick values on campaign object and when I create campaign manually I am forced to use only the defined pick values. But i have seen record where some values do not match the defined pick values. Are there records created using data loader? I created a record using data loader and found we can insert values which are not part of pick values/own values. In that case how to restrict this like while creating it should be validated the values getting inserted with the pick values and for a mismatch, it should error out. Can anyone please suggest?

Thanks!!!

 
Best Answer chosen by sana240
Maharajan CMaharajan C
Hi Sana,

Go to the that picklist field and Edit that field and check the box like below:

User-added image

Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj 

All Answers

Rahul KumarRahul Kumar (Salesforce Developers) 
Hi Sana,
 The best way to upload values to a picklist field by using data loader.May I request you to please refer the below link for reference. I hope it will be helpful.

Best Regards
Rahul Kumar
 
Maharajan CMaharajan C
Hi Sana,

Go to the that picklist field and Edit that field and check the box like below:

User-added image

Can you please Let me know if it works or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
​Raj 
This was selected as the best answer