Hello -
We are looking for a way to export a list of patrons in list manager, or analytics, that will provide us with the constituent name and record information, followed by a set of recent performances that they've attended, but with each performance in their own unique column. So that ultimately, each constituent record only takes up one row, but has as much performance history as we need for any given list.
Our predecessor set up a way to export e-mail address this way, but we haven't been successful at reverse-engineering what she did and using it for performances.
Any suggestions?
Thank you all!
HI Katie.
This might not be what you are looking for but I have written some output sets that will take all emails, constituents etc and put them in a single cell, as a string separated by a comma (or what ever you need). If you save the output set as a csv (commas separated values) file you're doing the same thing. I've done it with a custom database view as I'm often returning a bunch of related info but you can use a function as described in the Output set cookbook.
Actually you can create short tables of data, such as all a customers gift vouchers numbers and remaining amounts, and stuff them together in a single cell wrapped in some html for ease in displaying in an email. I've been down the separate column route by have usually been foiled by having to guess the number of columns I'll need.
Holler if you need a hand
That's a good idea, thank you! I'll look into that :)