-
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
How to Properly Implement a Salesforce Deduplication Feature: 5 Tips You Need to Follow
If your company is like many others struggling with duplicates in Salesforce, you are actively looking for solutions that can solve this problem. When you…
Best Practices for Salesforce Data Migration
Conducting data migration from or into Salesforce can be time-consuming but a necessary task. Data migration is a challenge for any enterprise. You might face…
User Management and Object-level Security in Salesforce
In Salesforce, every user is at a time found with a profile, username, and password. Along with other settings, the outline decides which move a…
Popular Salesforce Videos
How to Send a Pardot Email with Multiple Line Items | Salesforce
It is impossible to send a Pardot email that has a list of related records… or is it? In this session, Adam Erstelle uncovers strategies…
What is Salesforce CRM?
What is Salesforce CRM? Join this useful group for Salesforce job & career info and learn all about Salesforce CRM.
How to Get Experience as a Fresher in Salesforce World? | The Shrey Sharma Show
Want to start your career in the Salesforce industry? Watch this video by Shrey and learn how you can get experience as a Fresher in…
