-
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.
- [adinserter block='9']
-
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
Guide to CPQ Tools in Salesforce: Find the Perfect Fit for Your Business
Ever spent hours crafting a quote in Salesforce, only to realize you forgot a discount or made a pricing error? You're not alone. Manually building…
Automating Campus Parking and Transit Permits: Unconventional Education Cloud Use Cases
Modern university campuses operate like small cities, managing housing, dining, safety, and transportation. However, disconnected parking and transit systems often create administrative inefficiencies and require…
How to Choose a Cloud Platform for Your Business App? | Salesforce Guide
Using cloud technologies has become a common thing for businesses. But before starting with that, the need is to find the right cloud platform for…
Popular Salesforce Videos
How to Setup Salesforce Customer Community?
Step by step Salesforce tutorial for quickly setting up a Customer Community with Customer Service (Napili) Template.
Spring '21 Release - Time-dependent Action in Salesforce Flows
If you’re familiar with scheduled actions in Process Builder or time-dependent actions in workflow rules, know that scheduled paths on record-triggered flows can accomplish the…
Schedule-Triggered Flow to Update Cases at the End of the Day | Schedule a Flow in Salesforce
A schedule-triggered flow starts at the specified time and frequency for a batch of records. Configure the schedule trigger in the Start element of your…