contact to client with record of life
I have a contacts table and migrate the status from contact to prospect, lead, client, ex-client. I do this in a Radio button set.
I want to record the date that the status changes (from lead to client) and then use the time stamp to report the life of the client in days. Crucially I want this to reside in a store and not change when the client moves to Ex-client status.
If anyone feels this is the wrong way to operate I’m open to ideas as i’m just a beginner.