Is there a way to show all sales line comments for a particular order in one cell? I am able to use an NL function to get the first comment, but can I retrieve all comments for that order in one cell separated by a space?
Date
Votes
2 comments
-
CascadiaDataworks An easy way? Not really because, in theory, you never know how many comments are going to be on a given order and they are technically on separate records in the database.
Can it be done? Yes. It is easy to explain over a message board without really knowing your data? Not really (is it a custom comment field? are you using the description field? would this field have non-comment content that you would need to filter out? etc)
If you want a quick consult, you can reach out to me at my username at gmail
-
CascadiaDataworks Glad I was able to help, Lucy.
Please sign in to leave a comment.