Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

What is the best practice to track Custom Fields' history on Custom Objects?

Edit: Also, is there any way to include Field History in Reports?

share|improve this question
3  
I'd say, only track those fields for which it makes sense and the history actually provide added value. –  Samuel De Rycke Dec 7 '12 at 9:38

4 Answers 4

up vote 6 down vote accepted
  1. Check 'Track Field History' on custom object
  2. Push button 'Set History Tracking' which is displayed together with 'Custom Fields & Relationships'
  3. Check up to 20 fields to track
share|improve this answer

Field Trip, is a nice free app that you can use to get a good set of reports on # of records used, whether custom or standard etc. on all the major objects.

share|improve this answer

Turns out you can't report on field history on the child object in a Master/Detail relationship. It's a known issue and there's an Idea for fixing it (https://sites.secure.force.com/success/ideaview?id=08730000000BrlxAAC). The kicker is that the UI lets you turn on history tracking for fields, and the data is captured, but you can't access it with the reporting engine. This means no dashboards and the like.

share|improve this answer

It is also probably worth mentioning Analytical Snapshots - you can daily/weekly/monthly copy a subset of your data (from your designated report) into custom object and then report on it.

Obviously the biggest pain is setting up a clone of an object (provided you need all the fields), but Eclipse might help. Create a new object via Salesforce UI and then in Eclipse just copy/paste previous object field definitions onto the new object.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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