Skip to main content
Hi All, 

 

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 risposta
  1. 9 apr 2021, 11:39
    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