How to connect my customized Field to another DB?

[ptctaji]

Hi Best Developers!.
I have created new fields in Contacts Module and I want to connect my new fields to SQLServer DB instead of default mysql db.
Can I do this a how?

Thanks a lot.

[letrium]

Hi!

I think it is better to define function for new fields in vardefs.

Do you know something about this.

I may post an example if you need. Just ask!


Best regards,

[ptctaji]

Hi.
Please give me an example of this.

Thanks a lot

[letrium]

Hi!

1.First of all you need to define field:

 'my_field' =>
  array (
    'required' => true,
    'name' => 'my_field',
    'vname' => 'LBL_MY_FIELD',
    'type' => 'varchar',
    'len' => '100',
   [B] 'function' =>
    array (
      'name' => 'getMyRez',
      'returns' => 'html',
      'include' =>'custom/MyFunc/func.php',
 
    ),[/B]
  ), 
  

so, new for you is:

'function' =>
array (
'name' => 'getMyRez', - this function will return value
'returns' => 'html', - type of result
'include' =>'custom/MyFunc/func.php', - file whitch contain this function

),

2. Add to all layouts that you need

simply:

 array('my_field'), 
  

3.create file 'custom/MyFunc/func.php'

 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
function getMyRez($focus,$name,$value,$view){
 
if($view == 'DetailView' ){ 
 
   $rez = your script result for detail view.
 
}elseif($view == 'EditView' ){
 
   $rez = your script result for edit view.
 
}if($view == 'ListView' ){
 
   $rez = your script result for  list view.
 
}
 
return $rez;
} 
  

there :

$focus - object
$name - field name
$value - field value
$view ( editview, listview, detailview)


That's all!

[mvngti]

letrium - THANKS!

Finally a good example of using a function to render a field in the forums.
Would you consider posting the example and some comments to the Wiki?
(In respond to SugarDev.net's request to help with the Wiki)


M

[letrium]

Ok!

I will write after understanding how to work in WIKI.

[ptctaji]

Hi!
Thank you for this information.