Field That Records Former Profile?

Question

I'm trying to create a Field on the User Object that will record the users former profile.

We're creating a Process Builder that will change the users Profile if the user is set to inactive but we want to keep track of the users original profile for keeps sake and/or if we need to revert back. And if the user's profile changes again, back to the Original Profile then we'd like to Something like this:

Original Profile
Inactive Profile
Original Profile

I'm not sure how to do this because the Profile will be changing and we don't simply want a field that mirrors the current profile, instead we want one that tracks the profile history.

Any ideas? & thank you in advance.

Edit Also what Custom Field do I need to add to the User object itself so that this data populates there? Related lists aren't an option on the User Object. Thanks

enter image description here

Answer 1

You'll need a child object, much like the way Opportunity stage history tracking is handled. This would be an additional custom object; you could call it "User Profile History". On that new custom object, create a lookup to the User ("User"/User__c, a Lookup Relationship) and a text field for the name of the Profile ("Profile Name"/Profile_Name__c, Text field, length 255).

Then, in your Process Builder (which fires on changes to your User record), use an immediate action to Create Records. You'll configure it to create a new User Profile History record each time the profile changes. In the section where you populate field values, you would set the User__c field to the User's Id, populate the old profile name in the Profile_Name__c field, and allow the Created Date of the record to serve as your time-stamp. For both User__c and Profile_Name__c, the type of data you're populating will be a Reference, since you're pulling it from the User record that started the process.