[alisoroush7]

hello guys,
i have created a process which requester fills a form and choose his department. After that i want to assign the next task to the department manager that was chosen in previous task. how could it be possible?
thanks for your consideration.

[kirkwg]

Hi,

Step 1 > Use a trigger put it to "After Dynaform", trigger code is as follows:

Code: Select all

	//--------- locate the DepMgrId given the DepName
        $DEP_NAME = @@user_dept;       //e.g. @@user_dept is <field-id or field variable of user's department> in the form
	$query= "SELECT DEP_MANAGER,DEP_MANAGER FROM DEPARTMENT WHERE ".
		    "DEP_TITLE = '$DEP_NAME'";	
	$result = executeQuery($query);	
	if (is_array($result) and count($result) > 0) {
	   @@dep_mgr_id = $result[1]['DEP_MANAGER'];		//hidden var dep_mgr_id e.g. 656789123..... (uid)
        }	

Step 2 > Put the Uid @@dep_mgr_id into the assignment rule for routing.
Wish you are clear now, cheers.