This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
BMC Helix Remedyforce Service Desk
While using Salesforce Field History tracking feature for auditing field value updates, sometimes the 20 field limit applied by Salesforce can be challenging. If you had a reason to add 2 more fields needed by your organization business need, you will have to prioritize out of the given 22 which are the highest so you have to choose the most important ones for tracking and make a unwanted decision.
In this document, we will see how Field History Tracking can be done for more than 20 fields without writing code or needing custom object. This however is not a setting, but a series of configuration steps.
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 “Incident” object and apply the steps to track change in Urgency, Impact, Priority and Due Date all together
Step 1: Create a Custom Field.
Setup -> Create -> Objects-> Incident
Create a new Text (255) field “Track UIPD” ( or 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”
Once the workflow is enabled any change to Impact, Urgency or Priority will be updated to the UIPD field