I have an application object which can have a number of related tasks assigned to different people. When the status of an application changes, I want to load 5-10 tasks which come from predefined templates. Here are the steps; 1. The user changes the status of an application. 2. The system goes to a 'tasks templates' table, and look for any task templates that are applicable for the new status. 3. The system will also filter these templates based on other criteria like "loan type=purchase", so that only the relevant templates are used. 4. The system uses these templates to generate tasks for the application, assigned to various users. I'm just wanting some help about the best way to approach this technically?
This can be done by Object Script trigger. You can implement all your business logic there.
For more on object script capabilities in Triggers, see Chapter 6 here:
http://www.rollbase.com/support.html?pcURL=support/rollbaseInAction.html