Skip to main content
Michael Dely a posé une question dans #Collaboration
I need to create a new field that always pulls in the previous value of a lookup field.  So if the field is changed from Matt Gomez to Jason Battery the new field will show Matt Gomez.  I believe this can be done with a trigger using some type of prior value, but was hoping someone can point me in the right direction.  

 

Thanks, 

 

Mike
8 réponses
  1. 5 août 2020, 20:05
    I'm not sure if you can use Priorvalue() on a lookup field.

     

    If you want to use workflow then :

     

    1. Create a formula field of type text to hold the User.Name field value

     

    2. Use workflow rule to update the text field with priorvalue(Formula field)