Activity Forums Salesforce® Discussions Give a way by which validation rule is bypassed while uploading through Salesforce Data Loader.

  • Manpreet

    Member
    April 27, 2018 at 11:28 am

    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.

  • Avnish Yadav

    Member
    September 30, 2018 at 1:13 am

    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

Popular Salesforce Videos