+ Start a Discussion
Lukasz PiziakLukasz Piziak 

Formula to register user name changing a specific field value

Hi,
I'm looking for help with creating a formula field which will display a user name who changed value on the specific date/time type field. I can not use last modified by because record can be edited by many other users. All what I'm trying to acheve is to display user name who changed date/time on my particular field.

Thanks for any ideas.
Lukas
Best Answer chosen by Lukasz Piziak
Nagendra Prasad ChNagendra Prasad Ch
Hi Lukasz,
This can be achieved by using a workflow rule. But, User Name must be text or lookup to User, since we can't assign value to formula fields.

Evaluation Criteria : created and edited
Rule Criteria :  ISCHANGED(particular Date/Time field) 
Field update :
if  User Name is a text field, 
User Name =  LastModifiedBy.FirstName  & ' ' & LastModifiedBy.LastName

If user name is lookup to User, then
User Name = LastModifiedById

Please let me know if it helps.

Thanks,
Nagendra

 

All Answers

Nagendra Prasad ChNagendra Prasad Ch
Hi Lukasz,
This can be achieved by using a workflow rule. But, User Name must be text or lookup to User, since we can't assign value to formula fields.

Evaluation Criteria : created and edited
Rule Criteria :  ISCHANGED(particular Date/Time field) 
Field update :
if  User Name is a text field, 
User Name =  LastModifiedBy.FirstName  & ' ' & LastModifiedBy.LastName

If user name is lookup to User, then
User Name = LastModifiedById

Please let me know if it helps.

Thanks,
Nagendra

 
This was selected as the best answer
Lukasz PiziakLukasz Piziak
Hi Nagendra,

Thanks for help. Your solution is working fine.

Regards,
Lukasz