I have a scenario where I need to display the previous username of a record permissions field after it's been updated. I have created two record permissions fields, one for the Current Value which is Manual and updated periodically by users. The other field is for the Previous Value of the record permissions field. The logic below has worked for me to capture previous values for Text fields but I am having trouble getting this to work with record permissions fields since trying to convert the RP to text only returns the User ID rather than the user's first name and last name.
This is what I have setup in the past.
- Field A = Input value
- Field B = Current Status Helper
- Field C = Previous Status
I put them in this calculation order which worked to capture previous values for Text Fields.
- Field A is updated manually by the user
- Field C calculates to take the value from Field B
- Field B calculates to take the new value from Field A
Is there a way I can create a calculated text field that converts the User ID into First Name + Last name then just use the logic above to set this up? Does anyone have any solution to this?
