Auto filling fields using calculation.

[user21]

I’m new to SugarCRM and edited the accounts module and added my own fields.
I need help trying to figure out how to populate some fields automatically by calculation using existing fields.
For Example
Total cost to be automatically calculated and populated by adding the cost filed plus 1.2% tax.

How would I go about doing this on the accounts module?

Mike

[jertothejig]

Mike,
If you come across anything for Sugar 5.2 please let another nube know. I have been looking for a while now. Not doing so well piecing together some of the threads.

j

[mvngti]

Total cost to be automatically calculated and populated by adding the cost filed plus 1.2% tax.
How would I go about doing this on the accounts module?

You need to create a before_save logic hook that calculates the field before saving the record every time.
See the sections on logic hooks in the DEV manual in my signature and if you search on threads started by me I posted a script that can help you create them.

Your hook should do something like this:

 $bean->total_cost_c = $bean->cost_c * 101.2; 
  

M

[user21]

Thanks Marnus, i'll look into this.