I have created a custom app called 'Projects'. The app is linked with a Master-Detail field called Account which looks up an Account name and then links the Project to it. Then I create an Event which is related to the Project using the Related To field. Now, what I need to do is create 2 custom fields in the Event which will bring in the Account Name and Postcode of the Account linked in the Project. I know this is a bit tricky because of the Related To field. I've found this post about creating a before insert Trigger in a Task, and I wonder if this will work for an Event.
I've tried adapting it to work for a Event, but can't seem to get it to work. Is it possible to create a before insert Trigger on an Event?