Track Field Changes

[citapinc]

SugarCRM 6.2.3

Is there a feature or a way to track the exact date/time/user when a field was changed, including the original value? We suspect a user is changing data but need proof.

[kbrill]

Yes, just set the fields you want to track to audit in studio (if there are not already) and then any changes will be written to the MODULE_NAME_audit table. You can see these changes by clicking on the "View Changes" link at the top of the detailview page.

Also whenever a user changes a record they are set as the last modified user so you should be able to tell who was the last to edit a record by that.

[citapinc]

Excuse me while I wear this "Du!!!" hat on my head.

I totally forgot about that feature.

[tobydz]

Yes, just set the fields you want to track to audit in studio (if there are not already) and then any changes will be written to the MODULE_NAME_audit table. You can see these changes by clicking on the "View Changes" link at the top of the detailview page.

Also whenever a user changes a record they are set as the last modified user so you should be able to tell who was the last to edit a record by that.

Is there a way to do this with code?

[tobydz]

Taken from a reply by ldd-silver-ziegler


create a save logic hook for this module.

you can compare the values of your field before and after the save in this way:

$bean->fetched_row['yourcustomfieldname']==$bean->yourcustomfieldname // if true, the field was not changed

fetched_row gets the value before the update. I hope this helps