-
Give a way by which validation rule is bypassed while uploading through Salesforce Data Loader.
Is there is any way through which validation rule is bypassed while doing upload through data loader but not when user is creating record from user interface?
-
2 Replies
-
Hi saurabh,
Yes. Create a checkbox field as API upload and make this field hidden in page layout. Create a validation rule and in evaluation criteria first check if checkbox is false and then check other validation criteria.
Whenever user upload record through data loader, specify value for this checkbox as true in .csv file and then upload it to salesforce. While upload, validation rule will fire and will find checkbox value as true so it will not check other criteria and system will allow to upload records.Thanks.
- [adinserter block='9']
-
Hello,
Simply create a Custom field in your object of the type Checkbox called as "Bypass Valdiation". Then set this value to TRUE when you update the records through the dataloader and tweak your valudation rule like this. This will ensure that the validation rule is not invoked when you update/insert through dataloader.
AND(
NOT(Bypass_Validation__c),
Your existing conditions here
)That should work !
Log In to reply.
Popular Salesforce Blogs
5 Most Asked Questions for Salesforce Admin and Coding Requirements!
Salesforce is a famous CRM platform, and managing it can create confusion among the audience about what it actually is. Do we need to…
Features of Salesforce Commerce Cloud: Enhancing the Shopping Experience
Commerce Cloud is a key part of the Salesforce Customer Success Platform and offers ecommerce solutions for B2C (business-to-consumer) and B2B (business-to-business) customers. That means…
SSO Implementation between two Salesforce Orgs in Lightning and Classic view
We can implement SSO for both Lighting and Classic view with the help of SAML. There is no difference between security protocol for both. Requirement:…
Popular Salesforce Videos
Top 3 Things to See at Dreamforce 2021 | Salesforce
Three things you definitely don't want to miss at Dreamforce this year? ? #DF21 is packed with tons of educational content about your fave Salesforce…
Proven Platform Development with DevOps & Agile on Salesforce
Digital business demands and user expectations have raised the bar on how CRM solutions are utilized in the enterprise. Technical professionals developing solutions with Salesforce…
Salesforce Developer Tutorial - How and When to Use Apex Managed Sharing
In this episode, we go over what Apex Managed Sharing is in Salesforce when you should actually use apex managed sharing and how to actually…
