I want to create a logic hook that, when an account's tumclienttype_c is changed, it will automatically update ALL the account's assigned contacts tumclienttype_c field to the same. Let's use this as the scenerio, even though it's most likely more difficult. I've created some code that would accomplish my goal using tumclienttype_c in contacts_cstm table I've also created a custom field also called 'tumclienttype_c' in contacts which is the same as the field by the same name in accounts.Įither would work, although lead source needs less querying than tumclienttype_c as it's in the contacts table rather than the contacts_cstm There is an existing field in contacts 'lead source' i've added the 4 values from the accounts custom field i created to lead source I have created a custom field in accounts 'tumclientstatus_c' drop down with 4 values. I'll need 2 hooks, i'm going to talk about 1 for the time being. Here's the object, excuse this as it's going to be a long description. ProjectJerel - SEO Marketing Tactics Decemat 3:09 PM $row = $bean->db->fetchByAssoc($results) $results = $bean->db->query($query, true) $query = 'SELECT accts.assigned_user_id FROM accounts accts ' That is the file that SugarCRM will examine for the custom code that needs to be executed when the appropriate conditions are met.Ĭreate a PHP file by that name and store it in the /custom/modules/Cases directory.

Notice the reference to the file autoUserAssignment.php. The logic_hooks.php file described above provides the parameters necessary for SugarCRM to know not only when the custom code should execute, but also where the code can be found. Make sure to save the file to the /custom/modules/Cases directory. $hook_array = Array(1, 'assignUser', 'custom/modules/Cases/autoUserAssignment.php', 'UserAssignment', 'updateCase') First we'll need to create a file called logic_hooks.php and put the following PHP code in it:

Suitecrm logic hooks not being called