You need to sign in to do that
Don't have an account?
Hit
Field history Tracking exceed the limit
Hello,
I have two custom fields under Account. I want to setup history tracking for this two field but this Account already exceed the field limits for setup tracking. There are already 25 field under Account, whom had setup the the history tracking.
So can I implement this history tracking by writing Trigger on Account ? If Yes then how can i do?
I am new to Trigger..so please explain me briefly.
Thanks,
Hit
I don't think you can implement history tracking with a trigger. The AccountHistory table only supports the following calls:
query(), retrieve(), getDeleted(), getUpdated(), describeSObjects()
I suggest calling Salesforce.com Customer Support to ask if you can get your limit increased.
Hello,
Thank you very much for your reply.
Is there any way to do this by coding?
Thanks,
Hitendra
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”.
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.