How to add calculations to a module

[vanrechemh]

All,

I would like to change the cases module to add the folloiwng:

- a link to the products table to have my products in a dropdown on the case as mandatory
- a calculated field to show the time a case is open (datediff (Now(),sugarcrm.cases.date_entered) if case status <> 'Closed' and datediff (sugarcrm.cases.date_closed,sugarcrm.cases.date_en tered)

Of course the field Date closed has to be created as well.

I created already a custom product field and a custom open time field.

Any idea how I continue?

Oh yeah:
OS: XP SP2
Sugar suite: 4.2.1b
Webserver: apache 2.2.3
Php: 4.4.3
MySQL: 5.0.1

Thx

[ispytodd]

I was about to post for a very similar request.

We are finding it increasingly difficult to gauge our own performance because we have no idea how long cases remain open. It would be very useful (and not terribly hard to implement Im guessing) to know when a case was closed. I believe that I could then calculate how long the case was open in JasperReports. maybe.

Regards,
Todd

[malcolmh]

I think this is an excellent idea. I would suggest posting this in the Feature request section and the miscellaneous section for 4.5.1 to get more attention from the Sugar team

[naveenshurpalekar]

Any leads on this particular issue with Sugar ? right now am working on this and finding it really difficult.

[ros.vol]

Hello,

i suggest that "Date Closed" is better to be auto filled on updating status with "Closed"...