Lately my clients have been asking to be able to see the latest time a particular record was “touched”, whether via an email, phone call, note, etc. Also, the type of record varied from leads, contacts, opportunities or custom records being created and managed by personnel.
In the past I’ve used the technique of creating multiple custom fields (Last Email Date, Last Note Date, etc.) that would be populated with the date when a new record was created. These fields could then be placed on the view of the related record so that users can see the last date.
Another solution was to ask the users to add their notes in a text field with specific naming conventions that often did not get followed.
I’ve also seen the technique of having a plugin created to store the last date any of the records within the entity were modified. This, however, didn’t really tell me what type of activity was taking place, but that wasn’t what the client needed. They simply needed the date.
After explaining to the client their options, we found that they only needed to see the last note that was created. But they wanted to make sure that the user was only having to put the note in the Note section of the form once and that standard date/time stamp and author functionality was maintained.
- Create a custom field on the form called Last Note.
- Hide the field on the form (since the user doesn’t need to see this in both the Note section and the field).
- Save and publish
- Create a workflow that when a Note is created, it populates this field with the date/time, author, and description (or whatever Note field they wanted to see). I set the workflow to be a real-time workflow so that it happens instantly.
- Set the properties to concatenate the values the client would like to see.
- Place the hidden field on their main view.
Now let’s try it out:
- Open or create an opportunity.
- Add a Note.
- Refresh the view.
- Add another Note.
- Refresh the view.
A very simple solution! Let us know if this helped or if you have an alternative workaround.