[rt-users] Calculations on custom field values

[Joop]

Daniel Farst wrote:
> I have a couple of things I'd like to do with RT and haven't been able to find any clear answers how to do it, or if it's even possible. Can anyone point me in the right direction? We'd like to do some simple calculations on values stored in a custom fields and on values from those custom fields in tickets returned from a saved search.
>
> Some background info: We use a queue in RT 3.8.8 to keep track of upcoming orders we need to place with a ticket for each order. Those tickets have custom fields tracking several values including order cost, what we're charging for the order, order status, tracking numbers, etc..
I do something like this and also as other already pointed out, it can 
be  done within RT but not as flexible as in Excel for example.

I have an asset (using AssetTracker) that has 3 CFs for counting how 
many hours support a party has and uses.
Further I have a script which is triggered for each transaction and 
looks at a ticket CF to see if it needs to recalculated the used hours. 
Through the clever use of Queue and Asset names it gets to the right 
asset CFs and updates them.

Things that are still to be done are for example: send a mail (ticket) 
when there is only 10% left or better use a CF to hold when to send the 
mail. Could be different per client.

Regards,

Joop