-
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
In-house vs. Offshore Salesforce Developers: Who to Choose in 2021?
CRM systems are prevalent in most organizations, particularly those that deal directly with customers. To be exact, 91% of companies with the size of at…
REST API in Salesforce | The Ultimate Guide
What is REST API? REST stands for Representational State Transfer, which is a web architecture that uses HTTP protocols to access and manipulate resources. REST…
How to Integrate Salesforce and NetSuite Effectively?
Salesforce is the worldwide leader in making revolutionary business applications, served from the cloud and are designed to help generate leads for an organization. Also, it…
Popular Salesforce Videos
LWC Interview Questions -1 ( Freshers)
In this video, Kumar Salesforce provides a list of LWC Interview Questions that may be helpful for those who are just starting out. Watch this…
4 Salesforce Report Formulas To Enhance Your Sales Process
Salesforce is a highly effective tool that can help businesses manage their customer relationships and sales processes. In this video, you will learn 4 helpful…
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…
