[chrispyg]

Is there a way to create a saved search that will combine User Notes and messages for a single customer. We want a single view so we can see if following correspondence with a customer any orders where taken.
This is a cached copy. Click here to see the original post.

[fourthwaveconsulting]

User notes and messages are both tables that are linked from the customer record. You could create a customer saved search, then in the results column, scroll down to the 'Messages…' line. Anything with the ellipses (…) after it is a linked table. You can pull in the fields you want from those tables into the customer search. It can get more complicated, as often the same record will show up multiple times. You can use grouping to get around this.

[Author]

Posts