automatic assignment to creator user

[mikrob35]

Hi all,

I want the account to be automatically assigned to the user who created it (therefore, I don't want to give my users the possibility to choose the assigned_user of the account they create).

In this post , I found a way to eliminate the "assigned to" field from the create form, but then it won't assign the account to anybody...and I want the record to be automatically assigned to its creator.


Would anybody have a solution?

Thanks a lot in advance.

[andopes]

Hi mikrob35

After removing the assigned_user_name from the form you need to create a logic_hook before save for the modules you had removed the assigned_user_name. In this logic_hook you set the assigned_user_name as the user who created ($current_user).

code for custom/modules/Accounts/logic_hooks.php:

 $hook_version = 1;
$hook_array = Array();
 
$hook_array['before_save'] = Array();
$hook_array['before_save'][] = Array(1, 'setAssignedUserName', 'custom/modules/Accounts/AccountLogicHook.php', 'AccountLogicHook', 'setAssignedUserName'); 
  

code for custom/modules/Accounts/AccountLogicHook.php:

 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
class AccountLogicHook {
    function setAssignedUserName(&$focus, $event, $arguments) {
        $query = "SELECT * FROM accounts WHERE id = '{$focus->id}'";
        $result = $focus->db->query($query, true);
    
        if($focus->db->getRowCount($result) == 0) {
            global $current_user;
        
            $focus->assigned_user_id = $current_user->id;
        }
    }
} 
  

Best regards

[mikrob35]

It worked like a charm.

New to Sugar, I'm gonna learn more about logic hooks in the wiki.

Thanks a lot Andopes for your precious and precise help