can integers field be auto incremented through studio sugarcrm

Question

can integers field be auto incremented through studio

Raj Kashyap · Accepted Answer

I solved it using a LogicHook that called a function to autoInc for me. It looks like this First, in Studio I added a new integer field to the ProjectTask module called 'project_task_id' Then, in custom/modules/ProjectTask/logic_hooks.php I added the following: $hook_version = 1; $hook_array = Array(); // position, file, function $hook_array['before_save'] = Array(); $hook_array['before_save'][] = Array(1, 'auto_inc_pt', 'custom/include/autoIncProjectTaskId.php','IncProjectTaskId', 'updateProjectTask'); Finally, I created a file 'custom/include/autoIncProjectTaskId.php' that looks like : <?php class IncProjectTaskId { function updateProjectTask(&$bean, $event, $arguments) { if ( !isset( $bean->project_task_id ) || '' == $bean->project_task_id ) { $query = "SELECT MAX(project_task_id) AS max_project_task_id FROM project_task pt "; $results = $bean->db->query($query, true); $row = $bean->db->fetchByAssoc( $results ); $pt_id = isset( $row ) ? $row['max_project_task_id'] + 1 : 1 ; //Change project_task_id value on Project Task $bean->project_task_id = $pt_id; } } } Let me know if this helps.