1. Navigate to Lists > Search > Saved Searches > New.
2. Choose Type: Customer.
3. In the Criteria Tab, add System Notes Fields... > Field > Status > Set as your Filter.
4. In the Results Tab, add the following fields:
Field: Name
Summary Type: Group
Field: Formula(Text)
Summary Type: Maximum
Formula Field:
CASE WHEN {systemnotes.oldvalue} is NULL then ({systemnotes.newvalue}) ELSE ({systemnotes.oldvalue} || ' changed to ' || {systemnotes.newvalue}) END
5. Enter a Search Title.
6. Click on Save & Run.
Note: Remove the Summary Type to show all the changes made to the status field. The Maximum Summary Type pulls up the latest change made in the record.
No comments:
Post a Comment