Hi all,
Curious how others are storing assistants of donors in Tessitura. We both have the relationship type of "Assistant" and a phone number type of "Assistant" on the donor's own record. I'm not too thrilled with the idea that this information is in two practically unrelated places.. and that the phone number is rarely validated (in case the assistant changes). I'm hoping to find a better system.
Would really like to see it be:• Flexible enough to add or remove assistants from mailings• Visible enough that it's easy to know to contact them first• Be able to pull them into reporting and have them clearly marked as "assistant of...."
I'm thinking of a constituency that calls out that this person has an assistant, and then having all the information as an association type. The pitfall to that is that as it is an association, one can't store work address, etc. Thoughts?
Any suggestions? What's worked for you?
I'd just like to echo this post. I have all of the same questions and am wondering if there's an elegant solution out there?
Best,
Amy
I would welcome thoughts on storing Assistants info as well.
Diane
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Amy Britt Sent: Monday, November 02, 2015 12:20 PM To: Diane Shen Subject: Re: [Tessitura Development Forum] Storing Assistants in Donor Records
From: Naomi Satake <bounce-naomisatake1832@tessituranetwork.com> Sent: 6/25/2015 6:09:11 PM
Would really like to see it be: • Flexible enough to add or remove assistants from mailings • Visible enough that it's easy to know to contact them first • Be able to pull them into reporting and have them clearly marked as "assistant of...."
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
We have board members who have assistants and we enter them in Tess. For any board member who has an assistant, we create an account for the assistant and create a hard association with the board member. Each board member has a Board salutation, Board type address with Board mail purpose, and a Board type email. If the board member wants us to communicate to them via their assistant, we also give the assistant the same salutations, mail and email. Whenever we pull a list of board members we can include assistants, or depending on the need we can pull only assistants, etc. in List manager with the advanced options at the bottom. Then we can output the list with the board salutation, mail and email addresses for any communication that we need to do. If it was an assistant that we only wanted their information as an FYI, we would put their contact information in their account but not code it as a Board type.
That’s our basic set up. Perhaps this can be modified to use for other assistant types.
Hope that helps.
T.C. Brown
Database Administrator
412.392.4834
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Diane Shen Sent: Monday, November 02, 2015 2:17 PM To: TC Brown <TBrown@pittsburghsymphony.org> Subject: RE: [Tessitura Development Forum] Storing Assistants in Donor Records
When you “create an account” – do you mean you are creating a new individual constituent record?
What do you mean by “hard association”?
Thank you.
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of T.C. Brown Sent: Monday, November 02, 2015 3:43 PM To: Laura Chaney Subject: RE: [Tessitura Development Forum] Storing Assistants in Donor Records
Yes we create a new constituent record, and we make it a contact type. Also if the assistant changes, we then update the information in the contact account to reflect the new assistant.
By hard association, I mean that we associate the two Tess accounts, so that in the relationship tab, you can click on the customer_no and easily go to the other acct. (Sometimes people will create an association without entering a Tess ID, but just enter the assistant name, which then limits the functionality of being able to pull info on the assistant.)
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Laura Chaney Sent: Monday, November 02, 2015 3:58 PM To: TC Brown <TBrown@pittsburghsymphony.org> Subject: RE: [Tessitura Development Forum] Storing Assistants in Donor Records
Thank you for the clarification. I did not know you could create an association by entering a name without it being linked to a constituent record!
Laura
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of T.C. Brown Sent: Monday, November 02, 2015 4:45 PM To: Laura Chaney Subject: RE: [Tessitura Development Forum] Storing Assistants in Donor Records