Adding a new user drop down in studio

[REByers]

I am using Sugar 5.0.0f, and want to add a new field inthe opportunities module to track a salesperson.

I cannot see how to create a field that looks up the user list, from within Studio. Is this possible? Tried using relate, but it won't show connections to the user list anywhere. Also I cannot clone the assigned to field as this does not appear in the fields list.

What I then want to do is to trigger a workflow when a field changes to a certain value to write in the assigned to name into this new field at that point.

Can anyone help?

[andopes]

Hi, REByers

You have to create a text custom field into Opportunities module.
After that you have to create the file modules/Opportunities/controller.php and create 2 functions just like these one:

     function action_editview(){
        global $app_list_strings, $iash_optional_inventory_checked, $iash_standard_inventory_checked, $iash_warrantied_checked;
        $this->view = 'edit';
        $GLOBALS['view'] = $this->view;
 
        $array = array();
        $result = $this->bean->db->query("SELECT a.id, a.name FROM accounts a INNER JOIN accounts_cstm ac ON a.id = ac.id_c WHERE a.deleted = 0 AND ac.organisation_type_id_c = '3'");
    
        while($row = $this->bean->db->fetchByAssoc($result)) {
            $array[$row['id']] = $row['name'];
        }
 
        $publisher_id = explode("^,^", @$this->bean->fetched_row['publisher_id']);
        
        $this->bean->publisher_id = get_select_options_with_id($array, $publisher_id);
 
    }
 
    function action_detailview(){
        global $app_list_strings, $iash_optional_inventory_checked, $iash_standard_inventory_checked, $iash_warrantied_checked;
        $this->view = 'detail';
        $GLOBALS['view'] = $this->view;
 
        $ids = str_replace("^,^", "','", @$this->bean->fetched_row['publisher_id']);
        $result = $this->bean->db->query("SELECT a.name FROM accounts a INNER JOIN accounts_cstm ac ON a.id = ac.id_c WHERE a.deleted = 0 AND ac.organisation_type_id_c = '3' AND a.id IN ('{$ids}')");
    
        $this->bean->publisher_id = '';
        
        while($row = $this->bean->db->fetchByAssoc($result)) {
            $this->bean->publisher_id.= "<LI>{$row['name']}";
        }
    } 
  

This is an example of populating a multienum field.

In the file detailviewdefs.php you add this customCode for the field:

             'customCode' => '{$fields.publisher_id.value}', 
  

And in the file editviewdefs.php you add this customCode:

         'customCode' => '<select id="publisher_id[]" title="" style="width: 150px;" size="6" multiple="true" name="publisher_id[]">{$fields.publisher_id.value}</select>', 
  

Cheers

[webnetin]

Hello Andre,

Thanks for the code.

I tried same way in Accounts. Unfortunately, the moment i create file controller.php at <<sugar_root>>/modules/Accounts/ and save the file, it gives Error 500 on loading the Account modules list view. All other modules works fine at this stage, but clicking on Accounts gives the error.

I am using Sugar 5.0.0f on Windows,IIS, MSSQL, PHP

Thanks in advance.

regards
webNETin

[saradhinc]

I am also unable to generate the field with the code Andre has posted above. But I think the controller.php is not complete.. like the php tag, class declaration, etc are missing.. you may want to try by putting those in the controller.php. Sample code is given below:

<?php

class OpportunitiesController extends SugarController{
function OpportunitiesController(){
parent::SugarController();
}

/* Andre's code */
..
..


}
?>

After doing these changes, and modifying the queries, I was able to see the screen with an empty dropdown field.

I am actually looking for generating a custom field similar to 'Assigned to' user field. I am using Sugar 5.0.0c CE. I couldn't find any solution for this version of Sugar in forums till now..

Sugar Gurus:
Any pointers in this regard would be of great help. Thanks!!!

[andopes]

Hi all

saradhinc, the code is not complete at all. I posted the piece of code related to the tricks to get it working. You really need to complete the code accordingly to your needs.

webnetin, do you have access to the error log of IIS? It should contain some important error which can guide you to the light.

Did you modify the query in the controller functions accordingly to your needs?? This example I post AS IT IS only works for some specific situation. The query and the fields MUST BE modified based on your real system.

Cheers