I have yet another question about using the Tessitura Event History Screen.
The Guest Name Field unfortunately is only one field, which makes it hard to
1) create an alpha sort – can only be accomplished when you enter the name LAST NAME, FIRST NAME
2) print table cards, envelope labels etc. – can only be accomplished when you enter the name FIRST NAME LAST NAME
3) have a way to formally address them (including Mr. / Mrs. to their name) – can only be accomplished when you enter the name MR.MRS FIRST NAME LAST NAME
I saw at a presentation in the 2009 conference that someone came up with a solution for that putting a * in between the first and last name – so this could be filtered out in excel? Unfortunately I have forgotten whose presentation I was watching, and what the details were.
If you read this would you mind sharing the information again??
I also remember seeing in 2008 that NYC OPERA is using the performance Seat Field to enter the name again using LAST NAME, FIRST NAME.
Does any one have other suggestions?
Also related to that we would like to use the Event Listing Report that comes with the system. Has anyone by any chance modified it to include the CNFR checkbox and the Source number?
Thanks everyone!
Monika
Monika Jouvert
Brooklyn Academy of Music
Development Business Process Director
718.623.7810 x6 / internally x4253
mjouvert@bam.org
http://www.bam.org
Thanks everyone for great suggestions, screen shots and code!!!!!!!!!