function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
HitHit 

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

flewellsflewells

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.
HitHit

Hello,

 

Thank you very much for your reply.

 

Is there any way to do this by coding?

 

 

 

Thanks,

Hitendra
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 (including User Object). 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.