Skip to main content
Topics#FormulasMax Paquin 的问题
Max Paquin 提问于 #Formulas
2015年1月12日 22:39

Validation rule and data load.

Hello everyone,

We are running into a weird problem in our Salesforce org. We have some code that run on a child object and update the parent object and everything seemed to be working just fine. However, today, when trying to insert records via dataloader.io our insert failed because of a validation rule being triggered on the parent object. But here is the fun part, the validation rule should not have been triggered! I checked it and everything was fine, I deactivated it and then another validation rule was triggered on the parent object (also should not have triggered). And when manually inserting a child record everything worked just fine.

Am I missing something in regard to validation rules and triggers?

Thank you for your help.
2 个回答
  1. Max Paquin
    2015年1月12日 23:02

    Thanks for the quick reply:

    The two validation rules that fire are this one:

    Making sure we are allowed to track this data point (credit)

    (!INCLUDES( Period__r.Building__r.LEED_Credit_Checklist__c,"MRc7") && (ISPICKVAL(LEED_Credit__c,"MRc7") 

    && !ISPICKVAL( Data_Provided__c ,"NONE"))) 

    And this one:

    To make sure people enter a start date that is before the end date

    if(and(isblank(End_Date__c), isblank(Start_Date__c)),False, 

    End_Date__c < Start_Date__c)

    What weirds me out a little more is let say record A is the child of record B, I insert record A via a loader but it returns an error because of Record C triggered a validation rule. Shouldn't I get an error for record C but Record A & B should be totally fine?
撰写回答...
0/9000