Setting Custom Field Formatting in DetailView

[beuten]

We have several numeric custom fields in various modules. I would like to display them in the DetailViews as currency values using the default settings.

I have been able to get most of them showing correctly by updating the /sugar/custom/modules/xxxxxx/metadata/listviewdefs.php file (see below). This is generally used for the ListViews, which also has the side-effect that it updates the formatting for the DetailView as well. The problem is that not all the currency values are shown in the ListView. If 'defaul' => false is set, then it does not show up in the ListView and my formatting is wrong in the DetailView (as with DISTRIBUTIONPRICE_C below)

Any ideas??

'COST_PRICE' =>
array (
'width' => 10,
'label' => 'LBL_COST_PRICE',
'default' => true,
'align' => 'right',
'related_fields' =>
array (
0 => 'currency_id',
),
'currency_format' => true,
),

'DISTRIBUTIONPRICE_C' =>
array (
'width' => 10,
'label' => 'Distribution_Price__c',
'default' => false,
'align' => 'right',
'related_fields' =>
array (
0 => 'currency_id',
),
'currency_format' => true,
),

[beuten]

Can anyone help

[sloose]

Hi beuten,

I'm a newbie when it comes to sugarCRM and PHP, but I have done the following to get what I think you want.

In the editview.php for your module (in my case sugarcrm\modules\opportunities\editview.php) after the lines

//Add Custom Fields
require_once('modules/DynamicFields/templates/Files/EditView.php');

Add the following

$xtpl->assign("SALE_COST_PART1_C",currency_format_number ($focus->sale_cost_part1_c));

This code should probably be added as a logic_hook to make upgrades easier, but I haven't figured out to create these correctly yet.

I hope this helps.

Stuart