Page History

...

Before open/close triggers are invoked immediately before an attempt is made to open or close a table (or a view of it).

A before open trigger is invoked when a table or a view is opened and or another view has not already opened the table.

This means that if your logic is "Open View 1", then "Open View 2" (where view 1 and view 2 are both based on the same table) then the trigger would be invoked when you open view 1, but not when you open view 2.

A before close trigger is invoked when a table or a view is closed and another view still does not have the table open.

This means that if your logic is "Close View 1", then "Close View 2" (where view 1 and view 2 are both based on the same table) then the trigger would be invoked when you close view 2, but not when you closed view 1.

...

Is invoked after a record has been successfully read from a table and just before the details of the record are passed back to the invoking function. Any virtual column logic has been completed by this stage.

Before Insert

Is invoked immediately before an attempt is made to insert a new record into a table. Please note the following:

...