You need to sign in to do that
Don't have an account?
sana240
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!!!
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!!!
Go to the that picklist field and Edit that field and check the box like below:
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
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.
- https://success.salesforce.com/answers?id=90630000000h1syAAA
- https://success.salesforce.com/answers?id=90630000000gkKJAAY
- https://success.salesforce.com/answers?id=90630000000gntbAAA
I hope it will be helpful.Best Regards
Rahul Kumar
Go to the that picklist field and Edit that field and check the box like below:
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