-
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
Case Study: Salesforce Pharma Order Management System Transformation
Key steps are taken to optimize operational efficiency and Salesforce integration in the pharmaceutical industry. Managing orders across diverse markets presents challenges that demand innovative…
RemedyForce Can be Your ITSM Solution: Here’s How | Salesforce Guide
IT is changing the scene in all major professional fields, and its partnership with business management is helping enterprises in scaling and managing businesses, IT…
Details About Separation of Concerns | Salesforce Developer Guide
At the point when You Don't Need SOC on Force.com One critical advantage of Force.com is its definitive improvement model that allows you to make…
Popular Salesforce Videos
Salesforce Development Master Training | Salesforce Development Course
Shrey Finally launched the most awaited Salesforce Development Master Training. Features of the course are: Learn Salesforce Development from Scratch with more than 100 on-demand…
How Admins Can Improve Salesforce Data Quality
Learn how to diagnose the accuracy of your data and build a plan to maintain and enhance its’ quality using Salesforce tools. Follow along to…
AMPscript Firstname Personalisation in Salesforce Marketing Cloud
Cameron Robert from Datarati demonstrates how to use Subscriber Data such as First Name or Preferred Name in your emails using AMPscript in Salesforce Marketing…
