+ Start a Discussion
symantecAPsymantecAP 

FIELD HISTORY TRACKING FOR MORE THAN 20 FIELDS

Hi All 

 

I have a requirement of tracking all the field changes on every Object of my Salesforce Organisation. 

Is there any APP on APP exchange that supports the above functionality . 

 

Thanks In Advance

Adil

MarkSilberMarkSilber

Not sure about an app that could track all field changes, but you can request an increase on the maximum limit for field history tracking, although I can't imagine Salesforce would increase it beyond 40 or so, which may not work for your use case. In addition, as you probably already know, field history can't track the before and after values for long text and multi-select picklists, only that the field changed.

Surabhi Agrawal 8Surabhi Agrawal 8
Hi,
A non coding version can be following

Approach:
This approach uses a custom Text field which stores values of multiple other individual fields. Then enabling field history tracking of this field would allow you to track changes for multiple sets of other individual fields. Thus even though remaining within the count limit 20, yet track changes of more than 20 fields.
 
Let us in this example take “Case” object and apply the steps to track change in Urgency, Impact, Priority and Due Date all together.
 
Steps:
Step 1: Add a new custom field.
Setup -> Case
Create a new Text (255) field “Track UIPD” (Or give any other name of your choice.
 
Step 2: Create a workflow on Incident object with the following:
Event: On Create/Update
Criteria: On any change of Urgency, Impact, Priority
Action: Field Update
Set Track UIPD = Formula (Urgency: <urgency> + Impact: <impact> + Priority: <priority>)
 
Step 3: Enable Field History tracking for this combined field “Track UIPD”.
Anil KamisettyAnil Kamisetty
There is an app on the App Exchange to Track the Audit Changes. It is called Flexible Record Auditing and the link is given below.

https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EvWmjUAF

It allows you to track auditing on multiple fronts (by user, by role, by profile etc). Also it has the flexibility to create a snapshot as of a date in the past coupled with data archiving features. Auditing can be done on all standard objects and custom objects. Extending the auditing to a custom object is "just add two lines of code" and it is done.