Apex Code Development You need to sign in to do that
Don't have an account?
Validation rule triggered in error on insert from another object
I have created a validation rule on a field on a custom object that is part of a managed package. The validation rule simply prohibits the text length in the field from exceeding 30 characters. The actual text field the rule is on is a 255 character text field, but for our uses we need to limit the length to 30 characters. Since that field is part of a managed packaged I cannot change the field length. It works perfectly for standard inputs.
The issue arises when a record in the object is created from another custom object in the managed package. We are using Process Builder to populate the field that the validation rule is on with the text from a custom field in the originating object. It worked flawlessly until I created the validation rule. The text field in the originating object is only 30 characters long so it cannot exceed the rule limits. With the validation rule activated every time the originating object inserts a record the validation rule causes an error and prevents the insertion. And the Validation Rule fires before the Process Builder does so it cannot be the text length in the originating field causing the error.
Any ideas??
The issue arises when a record in the object is created from another custom object in the managed package. We are using Process Builder to populate the field that the validation rule is on with the text from a custom field in the originating object. It worked flawlessly until I created the validation rule. The text field in the originating object is only 30 characters long so it cannot exceed the rule limits. With the validation rule activated every time the originating object inserts a record the validation rule causes an error and prevents the insertion. And the Validation Rule fires before the Process Builder does so it cannot be the text length in the originating field causing the error.
Any ideas??
Could you share your validation rule formula , i just have doubt that null condition is not checked or something missing in Validation rule causing this.
Thanks
Shashikant
Here is a screen shot of the actual invoice number field.
Here is a screen shot of the invoice number for this record that caused the error.
AND( NOT(ISNULL(AcctSeed_Payee_Reference__c)), NOT(ISBLANK(AcctSeed_Payee_Reference__c)), LEN( AcctSeed_Payee_Reference__c ) >30 )Let me know the results if it still shows same error or not ?