+ Start a Discussion
Brianna BollettieriBrianna Bollettieri 

Have a field update based on a date/time stamp field change

Hi! Currently, I'm working on creating a process builder in order to update a field on an account related list each time the date/time stamp value is changed.

As of now, each time an event is logged on an account it updates a date/time stamp field I created with the date and time of the most recently logged event and there's another field that pulls the person to have last logged an event. Based on that date/time stamp and the person to have last logged then even, I want a field I have on a related list I have to keep a running tally of the "calls completed" by the record owner. Below is what I have so far but I can't seem to get the "calls completed" date to populate.

Node 1: Related list - when a record is created or edited

Node 2:
Conditions are met
Logged Date/time stamp -> is changed -> Boolean -> True
Logged by -> equals -> formula-> related list owner id

TRUE - Node 3:
No criteria—just update the records!
Calls Completed -> formula -> Calls Completed +1

Below are images of the process builder as well. Any help to get this working would be great!

User-added image

User-added image

ShirishaShirisha (Salesforce Developers) 
Hi Brianna,

Greetings!

I would suggest you to capture the debug logs while changing the date field to confirm,if we are missing something in the process builder.

How to capture the debug logs:https://help.salesforce.com/articleView?id=code_add_users_debug_log.htm&type=5

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.

Warm Regards,
Shirisha Pathuri