Is there a way to implement SLA into the Case form ?

Hi all,

I’ve been working with suitecrm for a very short time, I am impressed how the application has helped me…

I am trying to use the application to control open cases until there are finished and concluded…

So I have already added some new fields and it’s becoming amazing the end result, although I have not much experience with it, I would like to ask some help to create a new field, that would be the SLA for the ticket, but if I only add a new field it will be basic stuff.

I was thinking if there would be a way to create a field to compared the Created date and from this date I would like to set the SLA, so for example if a ticket was open on November 7th and the SLA was set to 4 days, on November 11th the SLA would 0, and 0 means that our deadline is gone…

By doing this I would like to maybe send an e-mail do assigned Person or anykind of alert that would be possible.

Is this a crazy idea ? has anyone seen something like this ??

Workflow should be able to do most of what you seek.