-
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.
-
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 Ways Salesforce CPQ can Transform Your Sales Process
You understand the value of streamlining your sales process as a salesman. You can spend more time completing business if you spend less time making…
Comprehensive Guide on Salesforce Web-to-Case
For any organization or business, growth depends on how they provide service(s) to the customer. Getting comprehensive details of customers’ problems is one of the most…
All About Salesforce Customer Service Management
Every business must always strive to give the best customer service possible. It's not just about being all smiles in front of them, but also…
Popular Salesforce Videos
Difference between B2B, B2C and B2B2C Salesforce Commerce Cloud?
There is a lot of buzz about the Salesforce commerce cloud and its effective offerings. Let’s dive deep into the world of Salesforce and the…
Escalation Rule in Salesforce
In this video, Shrey is not only teaching but also demonstrating Escalation Rule in Salesforce. 1. What are Escalation Rules in Salesforce? 2. What is…
Salesforce Apps: Managed vs. UnManaged Package Importance from Lederhosen Salesforce
Salesforce has Two Types of Packages ( Tabs, Objects, Software ) you can load: Managed & UnManaged. This video describes both. The advantage of a…
