How To Store The Date of A Field Change?

Question

I would like to store the date when the RLI Sales Stage changes. I've tried various techniques including Custom Calculated Fields and SugarBPM, but I can't quite find the right method to accomplish this. I've looked at several solutions, but can't seem to make them work... 
 
 Capturing the Sales Stage When an Opportunity Closes : Can't see where I can compare current and previous versions of the Sales Stage and then set a custom Date field. 
 Sugar Logic Walkthrough - Tracking a Field's History : Can't see where I can set both the previous version of the Sales Stage AND set the custom date field when the Sales Stage and Previous Sales Stage are different (indicating a change of the field). 
 
 Any thoughts out there? Thanks ahead of time! VO

Vince Outlaw · Accepted Answer

Hello Vince,

Agree with Mykola about the field changes tracked automatically in the Audit Log.

Nevertheless, as Sugar Admin, I feel you are looking for smth more friendly for building out further CRM processes automation, aren't you?

As for me, achieving this is not about Dev Practice that demand dev efforts

Three steps:

1. Add a date field sales_stage_change_date_c for RLI module via Studio

2. Goto Module Loader and deploy field population logic:
TrackRLISalesStageChange.zip

3.Enjoy!

For the note - Sugar behavior configuration provided in the ZIP is the following:

If any questions I would be happy to help

Cheers!

Vince Outlaw · Answer

Hi John "it works" !== "optimum solution" depends on the scope- if to expand programming scope to business scope, optimum could be another Thank you, I followed your suggestion and changed after_save on before_save in the flowchart and regenerated ZIP with a click Here it is: TrackRLISalesStageChange_beforesave.zip 
 
 The infinite loop might not happen until the checked field is updated and saved again - but anyway, if the designer miss this, there are mechanics that prevent infinite loops after some iterations Thank you!