Custom multiselect problem

[antoinebelmont]

Good day to all:

I'm doing a custom multiselect within the meetings module, it display a list of available accounts from accounts module, i made the list within the view.edit.php file, the field already saves and display selected values very well, but, i don't know how to display the values within the detail view, i seek around the google and forums, but i dont know how to do it, may you help me please, any kind of help its welcome, thanks for advanced

[jmertic]

Why not use the OOTB multiselect?

[antoinebelmont]

Why not use the OOTB multiselect?

thanks for your answer, i don't know about the OOTB (that means out-of-the-box right?), but searching, i found many of your post's talking about things like my problem, following this post solution Accessing Field Data on Current Record, i made the steps related by Bcdev but my field is still taking the values from the static list instead the dynamic list made with the function, this is my code:

[sugarcrm]\custom\include\utils.php:

 function getAccountsName($focus){
    $query = "SELECT id, name FROM accounts WHERE deleted = 0";
    $result = $GLOBALS['db']->query($query, false);
    $list = array();
    $list[''] = '';
    
    while(($row = $focus->db->fetchByAssoc($result)) != null){
        $list[$row['id']] = $row['name'];
    }
    return $list;
} 
  

[sugar]\custom\Extension\modules\Meetings\Ext\Vardefs\sug arfield_cuentas_c:

 <?php
 // created: 2012-07-30 16:52:03
     unset($dictionary['Meetings']['fields']['cuentas_c']['options']);
    $dictionary['Meetings']['fields']['cuentas_c']['function']='getAccountsName';
 ?>  

i'm loosing any step? thanks for your help.

[jmertic]

The second file needs a .php extension, but otherwise doing a Quick Repair and Rebuild afterwards should solve it.

[antoinebelmont]

The second file needs a .php extension, but otherwise doing a Quick Repair and Rebuild afterwards should solve it.

Ups, a finger error, already that have it, searching for another solution, i made a custom view.edit.php within
[sugarcrm]\custom\modules\Meetings\views\
with this code:

 $cuentas = array();
        $db =  DBManagerFactory::getInstance();
        $query = "SELECT id, name FROM accounts WHERE deleted = 0";
        $result = $db->query($query, true, 'Error');
        
        while($row = $db->fetchByAssoc($result)){
            $cuentas[$row['id']]=$row['name'];
        }
        $this->ss->assign('myOptions', $cuentas);
        $query = 'SELECT cuentas_c FROM meetings_cstm WHERE id_c="'.$this->bean->id.'"';
        $result = $db->query($query, true, 'Error');
        $cuentas = $db->fetchByAssoc($result);
        $cuentasSeleccionadas = $cuentas['cuentas_c'];
        $cuentasSeleccionadas = explode("^",$cuentasSeleccionadas);
        $this->ss->assign('mySelect',$cuentasSeleccionadas);
        $handle = fopen("pruebaCuentas.txt","a+");
        fwrite($handle, $cuentasSeleccionadas[0]."\n"); 
  

and then put customCode within the field definition:

 'customCode' =>'<select multiple = "multiple" id="cuentas_c[]" name="cuentas_c[]">
                                <option value="null">-- none --</option>
                                {html_options options=$myOptions selected=$mySelect}
                            </select>', 
  

that works!:

But within the detail view a don't know how to made it:

What of this posible solutions are easier? thanks for the help

[jmertic]

Check out this blog post for some help....

SugarCRM Developer Blog » Blog Archive » HOWTO: Have a dropdown field that get’s it’s options from a function.

[antoinebelmont]

Check out this blog post for some help....

SugarCRM Developer Blog » Blog Archive » HOWTO: Have a dropdown field that get’s it’s options from a function.

thanks, i already try that solution, in fact its my first code snippet posted here, but when i do quick rebuild don't do nothing, by now i gonna modify the detail view with javascript until i found a solution, thanks for your time and your help

[newroseji]

thanks, i already try that solution, in fact its my first code snippet posted here, but when i do quick rebuild don't do nothing, by now i gonna modify the detail view with javascript until i found a solution, thanks for your time and your help

Did you fix that problem? I am also having more or less similar problem.

My problem is - I have created multiselect dropdown that gets filled via database call on the fly. I am not able to save that to database (I get it that I do not have database that can shore all one-to-many relationship data). But, I want to show all selected field (from multiselect dropdown) as a field in detailView.
How to do that?
Need help.
Thanks in advance.

[xfasfdsfg]

i already try that solution, in fact its my first code snippet posted here, but when i do quick rebuild don't do nothing, by now i gonna modify the detail view with javascript until i found a solution, thanks for your time and your help