calculations

[chris.marsden]

Hi Guys,

How do I do this?

I have 2 custom fields which we will call X & Y. i want X & Y to perfiom this calculation X*Y/100=Z.

here is the triky part, i want the value of this calculation (Z) to be outpit into another field as a currency format...

Is this possible?

[ashokinsugar]

Hi chris.marsden,

Its possible, just fetch and write few custom code in save and display.

If issue just google it you will get some help.

[garciasanchezdaniel]

The best way you can do it is through logic hook.
This is a tool of sugar that allow the developers to do some actions when you create, modify or delete any record.
In this link there is an example (in spanish) but you can look for more googling.
good luck

[chris.marsden]

None of the logic hook makes logical sence to me atm lol as it all seems relevant to adding tasks and auto creationg of call logs (this will be very useful however)... will keep reading but all help appriciated with the below:

basicly what i want it to do is take the value of one custom field called EAC (textfield holding a number) (eg 12000) and multiply by another custom field called uplift (eg 1) (textbox holding a number). then devide to put decimal in correct place then output this as currency.

Eg 12000 * 1p = £120
the user will input it a a 1 however not 0.01 which is what it should be written as so i will need to devide by 100 to give correct output.

[garciasanchezdaniel]

I'd do the next:

1. Create in /custom/modules/yourmodule/ the file logic_hooks.php only with this code:
   

   $hook_version = 1;
   $hook_array['before_save'][] = Array(1,"calculations","custom/modules/yourmodule/calculations_Hook.php","calculations_Hook","calculations");

2. Create in /custom/modules/yourmodule/ the file calculations_Hook.php with this code:

 require_once("include/modules/yourmodule/yourmodule.php");
class calculations_Hook{
    function calculations(&$bean, $event, $arguments){
        global $current_user;
        $oldOpp = new yourmodule.php();
        $oldOpp->retrieve($bean->id); 
                if (empty($bean->fetched_row['id'])){ //if is true is because it is a new record
                     $bean->fielddestination =  $bean->EAC * $bean->uplift;
                      //here I'd do calculations on depending of other field that I create of kind dropdown list
                     //with all kinds of currencies that the user can choose
                       if($bean->currency == 'pound') {
                           //calculations for currency 'pound'
                       }   
                }
    }
} 
  

• This will do the calculations in your module every time a new record of the module is created (not if is modified, only when is created)
• As you can see at the code, I'd create other field for the currency chosen by the user.

good luck chris

[rafael.q.g@hotmail.com]

You can create a non-db field which value is camputed based in a php function.
Take a look at this example: http://developers.sugarcrm.com/tutor...AgingField.pdf

Then I have sure you easialy will be able to realize that.

[Kupido]

Hello

the pdf is not bad, but my problem is the function.

I need a simple calculation from 6 fields.
I had field a, b,c,d,e,f and from this fields i want the sum in another field.(after save)

Is that possible?

[kirstyobrien]

Couldn't you create a new field "Z" and have the calculation on this field so when there are values in fields X & Y the output appears in field Z?

[garciasanchezdaniel]

Hello

the pdf is not bad, but my problem is the function.

I need a simple calculation from 6 fields.
I had field a, b,c,d,e,f and from this fields i want the sum in another field.(after save)

Is that possible?

A simple and easy way to do it is through logic hooks as I have explained in my previous post.

[Kupido]

Hello garciasanchezdaniel

thx for your answer.

But i understand not were you get the variables &$bean, $event, $arguments
Who can i change this for my "problem"
Where can get this variables


thx a lot