We want to implement a history visualization functionality for our custom Team functionality.

We have the following data model: Data Model

We want to track changes off attributes values on TeamMember__c, but also when a TeamMember__c was added or deleted. Architecturally, we currently see 2 ways of implementing this:

  1. Use SFDC field history and a custom isDeleted__c flag on TeamMember__c
  2. Custom TeamMemberHistory__c object to capture all changes from TeamMember__c

Both approaches have their downsides, therefore my question: is SFDC providing any other means of implementing this, or is there any other design pattern for this (in my opinion) quite common problem.

  • what did you go for in the end? Currently facing a similar requirement and the deleted history is an issue as well. – zaitsman Aug 7 '19 at 7:44
  • We will go for option 1 with a custom isDeleted flag. – Klaus Aug 8 '19 at 9:54

If you can live with all limitations of Field History Tracking out of the box, then I would use that for field changes. The main limitation is the free retention period of 18-24 months but you can purchase longer retention. #2 limitation is 255 char limit on the changed field.

Else, go with your custom scheme.

| improve this answer | |
  • 2
    We are aware of the field history tracking limitations and we can live with it. Our problem is dealing with the history of deleted records. – Klaus Jun 28 '19 at 6:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.