Reporting on when a Field is changed

Is there a way to pull a report on when a field has been changed / amended?

We have a multi-select field in the Accounts module, which we would like to be able to report on when a change has been made (date), and also what the change was (selection / removal).

Is this possible to do?

Thank you in advance!

Parents
  • hi  
    what about a simple BPM that triggers an email when that field changes, with both the before and after value, would that work for you?

    .

    CRM Business Consultant

  • Hi Vincent, thank you for your reply. Unfortunately this wouldn't work for what we are needing - there could be large numbers of changes each month so we need all the change information collated into one report...

  • Hi  ,

    instead of sending out an email as Vincent suggested, you could also create an entry in a specific module that you create for this.

    We are doing this on Account level. We have built an extra module called "Field Updates", which gets a new entry via BPM whenever a certain field we want to monitor is changed. Per field, there can always only be one active entry, so if, let's say, the value of the "Expected Growth"-field changes, we set the current Field Update record for this field to the status "Past", write the current date in the "Date end" field of the Field Update and create a new Field Update record with the status "Current" and the runtime date as the "Date Start", (which will get set to past, when the field is changed again and so on and so on ...)

    I hope you got the general idea ;) 


  • this is really helpful, thank you for sharing the map - creating a module would help us track other fields as well - we will look into it! Excuse the question, I'm a very novice Sugar user(!), can you explain what you are building into the module - is it specifically the fields you want to see the changes of?

Reply

  • this is really helpful, thank you for sharing the map - creating a module would help us track other fields as well - we will look into it! Excuse the question, I'm a very novice Sugar user(!), can you explain what you are building into the module - is it specifically the fields you want to see the changes of?

Children
No Data