I'm trying to work out a way to trigger a script that will set the values in various fields to a default value, even though they can be quite rightly changed by people through the course of general interaction. I'm essentially looking for an OnRecordLeave or Exit trigger.
The reason I'm asking is that in my DB, various options that affect summary fields can be set for a record. The problem is that those options are then saved with the record which affects other related records... you may then say "then your relationship is wrong". But for reasons I wont bother with, these relationships can't be altered.