It is not possible for triggers to ignore validation rules without adding custom logic.
If the request to save a record originates outside of a Standard UI edit page, any before
triggers you've defined will run prior to the execution of validation rules.
Unfortunately, once all the before
triggers are finished, Salesforce will run, without exception, the System validation rules (ie. required fields, max length, etc.) and User-Defined validation rules (ie. the formula-based rules you've defined).
Here is one strategy to bypass this behavior:
- Add a "Skip Validation" Checkbox field to the object
- Set the "Skip Validation" field to
TRUE
in abefore
trigger. - Add logic to your validation rules so that they do not execute if "Skip Validation" is set to
TRUE
.