CustomFieldHistoryTracking
Shows historical changes to selected custom fields, enabling audits of when and how values were modified.
Table-Specific Information
Select
The connector uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
- ModuleName supports the '=' operator.
- EntityId supports the '=' operator.
- FieldName supports the '=' operator.
- HistoryName supports the '=' operator.
All columns used in the criteria are required. Use FieldName to specify the actual name of the tracked custom field and HistoryName to specify the name of the history tracking section. If you want to retrieve data for a specific entity of a module specify EntityId in the criteria.
For example, the following query is processed server side:
SELECT * FROM [CustomFieldHistoryTracking] WHERE ModuleName = 'Leads' AND FieldName = 'pickListField' AND HistoryName = 'Pick List 1' SELECT * FROM [CustomFieldHistoryTracking] WHERE ModuleName = 'Leads' AND FieldName = 'pickListField' AND HistoryName = 'Pick List 1' AND EntityId = '12345665'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique numeric identifier for the history entry. |
| ModuleName | String | Name of the module this custom field history belongs to. |
| EntityId | String | Identifier for the specific module instance associated with the custom field history. |
| FieldName | String | Name of the custom field being tracked. |
| HistoryName | String | Label assigned to this historical tracking entry. |
| FieldValue | String | Value of the custom field at the time of the recorded change. |
| DurationDays | Integer | Number of days the value remained in this stage. |
| ModifiedAt | Datetime | Date and time when the field value was last updated. |
| ModifiedById | String | Identifier of the user who modified the field value. |
| ModifiedByName | String | Name of the user who modified the field value. |
| CurrencySymbol | String | Symbol of the currency used with the field value, if applicable. |
| ProcessFlow | Boolean | Indicates whether this historical value is part of a defined process flow. |
| Editable | Boolean | Indicates whether the historical value can be edited. |
| Approved | Boolean | Indicates whether the historical value has been approved. |