I have a Picklist list field Account_Mgmt_Stage__c based on the changes in the value the Date fields are populated to TODAY
But then , with a specific scenario there might be cases where a user can toggle between certain values such of the Account_Mgmt_Stage__c which are Post-Kickoff Documentation Received and Status Report Updated and whenever this is changed the Date field Actual_First_Status_Report_Update__c is update to today. This could happen a number of times. Is there a way I could count how many times a date field has been changed based on the changes in the picklist list values as mentioned above? please help . thanks in advance
For this I have also tried creating number field and setting it to default value 0 and update everytime the date field changes - It dosent seem to work
Filed history tracking is also ruled out as we have exausted the 20 fields limit.
1 answer
Hi,
You could create 2 number fields:
Previous value and Current value
Create a flow or process builder that would update Current_Value__c to 1 and Previous_value__c to 0 the first time this picklist is set.
Then have another branch that updates Previous_Value__c to the previous value of Current_Value__c, and updates Current_Value__c to Previous_Value__c+1 when the picklist is changed.
Another way woudl be to create a custom object related to Account by a master detail relationship and create a record everytime the picklist value is changed, then you can simply report on this custom object just like the Field History. You can also add a roll up summary field on Account to have a count of those records