I have a custom object that I am developing a staged progression for.
For the sake of easy discussion, let's just go ahead and call this
Object object which has a picklist field
I have so far been tracking the progression through this stage by stamping the datetimes directly on the record like so:
stage_1_dt__c = '2020-01-15T15:55:55.000+0000' stage_2_dt__c = '2020-01-11T11:11:11.000+0000' stage_3_dt__c = <null>
Which is just messy in my opinion. It also
I'm thinking of converting this instead to a separate custom object
Object events which, each record would be a child of the parent
Object object and would have usually have a 1-1 association to the stages. The main benefit to handling things this way is that I want to make a timeline because an
Object object record can move back and forth along the
Object stage "progress bar". But I'd like to see those stage movements all from one datetime field instead of trying to recreate them across a datetime field for each
Object stage + field history.
Open to any and all suggestions.