Quite often you need to monitor and have workflows designed based on the “Last Touch Date” or the “Next Action” date. While the former should reflect the last interaction made with the customer, the later is to keep track of the next upcoming interaction with the customer.
End users often believe the Modified date reflected on the Account form, is the “Last Touch Date”. Well, that is not true. The Modified date on the Account Form is only updated when any changes are made directly to any of the attributes on the account form. Even adding of a note to the account does not update the “Modified Date”. To track the true “Last Touch date”, you would require to write a custom plugin or perhaps a Workflow could do the job as well.
How to track “Last Touch Date” using Workflow.
You need to trap the create/update/status change events of all the activities that you need to track for an account. Assuming that we would set the regarding to Account for each activity that we create.
1. New Worklow – Set the entity as Appointment – Event Create, Update and Status change
4. Select custom date attribute for tracking “Last touch” set date = Workflow execution as shown in the below screenshot.
For the next action date, in each of these events, you need to read the account associated with the activity. Using the RollupActivitiesforAccount “TargetRollupActivityPointerByAccount” you can get the next due activity and update the “Next Action Date” to this date.