0

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 hereenter image description here

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.

| improve this answer | |
  • Hi David, can you clarify on this please? I got lost in the translation. -Create Child Object (In the User field?) User Field>Custom Field>New>Hierarchy? – Mr.Smith Jan 16 '19 at 19:59
  • @Mr.Smith I've expanded my answer. – David Reed Jan 16 '19 at 20:22
  • Hi David, sorry I'm still struggling with this. Please see edited photos above. – Mr.Smith Jan 17 '19 at 13:08
  • I generally recommend against placing one-to-many history information in a single field. Instead, I would run a report on Users with User Profile History. If you must, you could use a Long Text Field and design your process to concatenate the existing value in that field with the changed profile name. – David Reed Jan 17 '19 at 15:10
  • I'm totally lost & what I have so far, if activated, causes an error when saving the user after editing. – Mr.Smith Jan 18 '19 at 12:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.