@mattdahse User even triggered on create / edit of estimate
As part of this it creates / updates a custom record.
Further to this, new requirements expect that on create or change of certain fields on the custom record various further code needs to run.
The problem, as I see it, is I need to be able to ascertain the old rec / new rec to establish changes have happened to the custom record if it's updated.
Potentially a user could open the custom record and edit / save it or even directly create a record.
Further to this, if the custom record has a flag on it and on create / edit this is set and a scheduled script runs to update certain fields too and some of those fields are fields I'm interested in if they have changed.
It's a bit of a minefield and I'm battling in my head the cleanest approach without stepping on the toes of the various scripts running.