We want to implement a history visualization functionality for our custom Team functionality.
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:
- Use SFDC field history and a custom isDeleted__c flag on TeamMember__c
- 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.