I'm working on a little idea and wondered if it would be the best way to go. Basically i'm working on a basic CRM system for a sales environment. The section i'm working on is based around recording quotes. As a helpful reporting tool i'm now going to try to record from when the quote was opened to when it was won as this will show turn around times.
Now the problem I have is trying to record that difference. My current idea is for them to have a checkbox which they tick to indicate it has been won and then to record the datetime in another cell. This will then give me my start and finish dates. I've looked at both using a custom popup editor like the one here http://www.telerik.com/support/kb/winforms/gridview/create-pop-up-user-control-for-row-editing.aspx
and using a checkbox column in the gridview. It is my feeling that the gridview checkbox would be the simplest way to go.
What I'm stuck on is how to, when the checkbox is selected, set the value of another cell in the same row with the current datetime. I think I would also want it so that once the checkbox has been ticked, it cannot be unticked else the results would be modified for the reporting end of things.
Is this the best way to go or is there a better solution? Any ideas or help would be greatly appreciated.