Reporting on when a Field is changed

hi Sara Foreman 
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?

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 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...

OK, in that case sounds like you need a monthly report with all the changes on that field during the whole month rather than every time for each change?

If that is the case, then an advanced report should help with achieving this.

Hi Sara Foreman ,

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 ;)