Hi,
We are working on pulling a list for an invitation that will include individuals as well as organizations (with contact names). In Tessitura, for several organizations, we have more than one primary contact as we would like each of these people to receive major mailing information. We are having difficulty pulling a list where the output will include the following columns: organization name, primary contact name, address, etc. If an organization has several contacts, the list should pull in several lines for the organization, each listing a different contact name. Does anyone has any experience with this?
There's a built-in feature that I don't think has been mentioned here. If you are using an extraction, there is special behavior that will occur when doing affiliation substitutions with affiliations that have addresses linked on them. It works as follows:
If you select a group constituent with your segment, use "add individuals" to select the individuals for the desired affiliation types. When you extract, you will get rows for each individual with an affiliation to the group, and the address output will be the one present on the affiliation record.
We were doing this and noticed that we needed to have the organization name included in this output, which we accomplished by reserving the street3 address field for the organization name, which is populated automatically by a database job and not accessible to the client interface.