-
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
What Is The Salesforce CRM and How It Enhances FinTech Industry
How Salesforce Sales Cloud can be a boon to FinTech industry? Sales Cloud is part of the CRM system that Salesforce is offering. Sales Cloud…
Salesforce Dynamic Forms: How to Get Started?
Salesforce Dynamic Forms improves the productivity of organizations and provides users only what they require, transforming static data entry into an intuitive experience. Plus, dynamic…
CRM for FinTech: Why Choose Salesforce For Fintech Companies?
Recently German specialists of information technologies published the article “What determines FinTech success?—A taxonomy-based analysis of FinTech success factors”. They provided insights into the potential determinants…
Popular Salesforce Videos
What is Validation Rule in Salesforce? Explain in details
Validation Rule will check the data entered by user during insert or update the operation and as per that it will actually take the action.…
How to Create Opportunity Teams | Salesforce Tutorial
Want to give all the people who help out on your opportunities easy access to the opportunity record in Salesforce? Or maybe you've got an…
Extend your Reporting Strategy with AppExchange | Reports & Dashboards | Salesforce
This Salesforce Tutorial is ideal for both beginners as well as professionals who want to master Salesforce Cloud. Below are the topics covered in this…
