Calculated Fields

[alexbloom]

I am trying to create a calculated field either in a report or in the opportunity module. Currently I would like to just multiply the probability by the amount.

I have seen many programmatic methods, and custom hooks etc. Unfortunately I do not have the ability to modify the .php etc. at this time.

Is there anyway to set a datatype to "calculated" within the module builder for simple mathematical calculations? I have searched fairly extensively and can not seem to find anything. If not, are there any future plans for 5.5?

Thank you,

Alex
Version 5.2.0e (Build 5626)

[ishaan]

Hi Alex ,

I dont know about the future plans but rite now you can write a logic hook for it that can be implemented on after/before save event.
For dynamically multiplying fields you will have to write a javascript code.

If u need assistance in writing such code , feel free to ask me

Cheers,
Ishaan

[Monkeyman]

For dynamically multiplying fields you will have to write a javascript code.

Could you be more specific on that? I too need to create a calculating fields and can do some JS scripting, but I have no idea where to put it.

I have very simple form with 3 fields: Item Type, Quantity and Sum. When I choose type and enter quantity, total amount in Sum field should appear. It's a super simple JS script.

Should I just put in header a link to script.js file with corresponding function? Is it enough?

[ishaan]

Hi,

Here u go.....

go to custom/modules/<your module>/metadata/editviewdefs.php

add

'includes' => 
      array (
        0 => 
        array (
          'file' => 'custom/modules/<your module>/yourjavascriptfunction.js',
        ),
      ),

into the 'templateMeta'

put your javascript file in custom/modules/<your module> directory.


add the following custom code to both the fields which u want to multiply

'customCode' => '<input id="field_1" type="text" tabindex="0" title="" value="{$fields.field_1.value}" size="30" name="field_1" onchange="yourJavascriptFunction();"/>',

may this help u


Cheers,
Ishaan

[Monkeyman]

Hi,
Here u go.....

Quite clear, except that I don't have "my module" :-)

I am going to create a simple layout for Opportunity or Sales page. So I should put JS in Opportunity or Sales folder and do the stuff above for corresponding modules, right?

[ishaan]

rite ......

Cheers,
Ishaan

[grecstar]

ishaan,
I need to do this too. What would the javascript file look like?
Thanks

[ishaan]

ishaan,
I need to do this too. What would the javascript file look like?
Thanks

Hi grecstar,

The javascript file should be like

function yourjavascriptfunction(){
document.EditView.amt1_c.value         // this way you can access the fields 
}

Hope this is clear now.

Any queries you can also reach me at ishaan.guliani@gmail.com

Cheers,
Ishaan

[Secret_Agent_99]

Hi grecstar,

The javascript file should be like

function yourjavascriptfunction(){
document.EditView.amt1_c.value         // this way you can access the fields 
}

Hi,
I don't see how that javascript file can be added to the edit view in sugar.
Is that the actual code to make it function to sum up the fields together.

Thanks