- Print
- DarkLight
OnValidate events run:
after an insert
after an edit
when boaStatus changes
Determine which of these are actually relevant to the business logic and what can be done to ensure complex logic only runs when necessary.
Refer to Create Events for general information.
Minimize Work by using Keys or Drill column values
Never perform “Global” operations using OnValidate. The OnValidate event must run on the current record being validated only, and not on all records on a page. If an event must run on every record in the page, you can create a button in the toolbar that executes against all records when clicked.
There are use cases where a child record affects a parent record, but it is still utilizing data from the child row for that manipulation. That operation should only affect one record (the parent) by filtering the affecting SQL with column values passed through the navigation of pages.