+ Start a Discussion
teena jacobteena jacob 

Update a field with corresponding date, based on a certain value being selected in lookup field on same object

Hi,
      I have 2 fields in the Event - the first is lookup filed "Status" and the second is date filed "lastAppointmentDate". For tracking purposes. I would like to add the corresponding date to the "lastAppointmentDate field based on when "Status__r.Actual_Status__c"  is updated to "Done".
I'd also like to make the "lastAppointmentDate" field not able to be edited unless you are an admin.
 
Thanks,
Any help would be appreciated.
bretondevbretondev
You should be able to achieve that with Process Builder without any problems.

https://help.salesforce.com/articleView?id=process_overview.htm&type=5