Skip to main content
darkknight
Expert ⭐️
Oct 6, 2016 8:57 PM UTC

Customer History object

In Salesforce, we have an Account History object where changes to the records in that object can be tracked.   It would be really helpful to have a Customer History object that would log changes to the fields on Customer Info object (date/timestamp, new value, previous value, who changed it) so that we can leverage historical changes in rules, reports, or when troubleshooting.

    11 replies

    smorrisgainsightcom
    Helper ⭐️⭐️⭐️
    Oct 6, 2016 9:36 PM UTC
    Hey Jeff,

    Would enabling History Tracking on the CustomerInfo object as well as specific fields on that object suffice?  You can currently do this and then report on it.



    Thanks
    Scott
    Translate
    dstokowski
    Gainsight Employee ⭐️⭐️
    Oct 6, 2016 9:45 PM UTC
    Agree - that would be my first suggestion.  Reporting, however, is limited for seeing this in Gainsight reporting.
    Translate
    darkknight
    Expert ⭐️
    Oct 6, 2016 9:49 PM UTC
    Thanks for the suggestion! (My Salesforce novice status is showing 😉 )

    If this is unable to be used by reporting though, how would we be able to view/use it?
    Translate
    Jeff Kirkpatrick
    smorrisgainsightcom
    Helper ⭐️⭐️⭐️
    Oct 6, 2016 9:55 PM UTC
    You can report on this, however there are limited fields available.  In a demo org, I set this up and then created a report.  Here's a sample output.  Also, SFDC allows a max of 20 fields for tracking, so that may be a consideration as well.

    Translate
    dstokowski
    Gainsight Employee ⭐️⭐️
    Oct 7, 2016 12:25 AM UTC
    Make sure "Enable Reports" and "Track Field History" is on for Customer Info.  
    Translate
    karl_rumelhart
    Expert ⭐️
    Oct 7, 2016 11:01 PM UTC
    Don't forget to use Data Spaces to combine data from the history object with the parent. 
    Translate
    darkknight
    Expert ⭐️
    Oct 10, 2016 11:51 AM UTC
    Scott - any idea what permissions I need to be able to surface the "Set History Tracking" button?  Our SFDC team created me a developer sandbox, and I have full admin access there, but this button does not appear.   I asked our SFDC team and this was the response:

    "You have that permission [Customize Application] as part of being a member of the admin profile (I've double checked). I suspect the real reason you can't do what you're trying to do is because JBCXM_Customer_Info_c is part of a managed package. We do not have any rights to the object other than the ability to add new fields to it, and this is probably why that option is not appearing."
    Translate
    Jeff Kirkpatrick
    manu_mittal
    Gainsight Employee ⭐️
    Gainsight Employee ⭐️
    Oct 11, 2016 11:53 PM UTC
    Hey Jeff,

    Do you have field history tracking enabled on CustomerInfo? This option should show up when you 'edit' the object:



    Thanks,
    Manu
    Translate
    darkknight
    Expert ⭐️
    Oct 12, 2016 12:18 PM UTC
    Yes, discovered this yesterday. thanks Manu
    Translate
    Jeff Kirkpatrick
    darkknight
    Expert ⭐️
    Oct 12, 2016 8:44 PM UTC
    I LOVE Data Spaces Karl.
    Translate
    Jeff Kirkpatrick