Calculate Sum Of 2 Fields

[DanBrown]

Hi All,

I want to automatically calculate a sum of 2 fields and this to be automatically entered into a third field.
the calculation is as follows: Credit Limit - Balance = Credit Available. But obviously i need this in PHP.

I have seen this done for older versions like version 4.5 and 5.0 but not for 5.1.0b which is what im running.

many thanks

[andopes]

Hi All,

I want to automatically calculate a sum of 2 fields and this to be automatically entered into a third field.
the calculation is as follows: Credit Limit - Balance = Credit Available. But obviously i need this in PHP.

I have seen this done for older versions like version 4.5 and 5.0 but not for 5.1.0b which is what im running.

many thanks

Hi Dan

Do you want to calculate it on EditView after changing one of the fields "Credit Limit" and "Credit Available" or when saving a record?

If your needs is the first one you need a javascript function, otherwise you need a logic_hook before_save.
Let us know exactly your needs.

[DanBrown]

its not necessary to do it in editview, but if it will calculate it in the detail view thats good

[andopes]

A logic_hook before_save function would be great!
You can find documentation over it on the sugar wiki.

[DanBrown]

Hi andre,

would i need to do something similar to what youve said in this thread

http://www.sugarcrm.com/forums/showt...culated+fields

thanks

[andopes]

OK.

What is the big deal?
This thread explains what to do...
Is the big deal the portuguese language?

[DanBrown]

There is no big deal im just asking if the information in the thread is still valid and up to date, as i am not a PHP programmer and have no idea where to even begin with a logic_hook.

By the way there is such a thing as a Google Translator so the language isnt an issue.

Thanks...

[andopes]

You are right.
This thread explain how to implement.
If you follow all tips you will be able to implement that.

Best regards

[DanBrown]

Many Thanks Andre

[DanBrown]

Hi Andre,

I have one last favour to ask...

The fields that you enter the numbers into, what type of field do they need to be, textfield, decimal or something else?

Also i have attempted to create some Logic_hooks. Can you have a quick look and see if they look good to you.

AccountLogicHook.php...

 <?php
//prevents directly accessing this file from a web browser
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
class AccountLogicHook {
function calculateField(& $focus, $event, $arguments){
$focus->test = $focus->alpha + $focus->bravo;
  }
}
?>  

logic_hook.php...

 <?php
// Do not store anything in this file that is not part of the array or the hook version. This file will
// be automatically rebuilt in the future.
$hook_version = 1;
$hook_array = Array();
// position, file, function
$hook_array['before_save'] = Array();
$hook_array['before_save'][] = Array(1, 'calculatedField', 'modules/Accounts/AccountLogicHook.php ','AccountLogicHook', 'calculateField');
?>  

Many Thanks Again!