Another salutation question

Many of our new accounts get set up on the web, and get entered as "John Smith" rather than "Mr. John Smith".

We would like the "Dear" salutation to default to "John" if there is no title, but "Mr. Smith" if there is a title.  I've studied up on the documentation for TR_SALUTATION_FORMAT, but haven't found a way to do this.  Am I missing something, or has someone come up with a way to make this happen?

Parents
  • We do it manually by running a new accounts report and editing the records.

     

    Not only are names missing prefixes, but sometimes information is in all lowercase as well.

     

    Thanks,

     

    Marie

     

    --

    Marie Kocher | Development Assistant

    Kansas City Ballet

    Todd Bolender Center for Dance and Creativity

    500 W Pershing Road

    Kansas City, MO 64108

    816-931-2232 x 1382 | 816-931-1172 (fax)

    mkocher@kcballet.org

     

    Buy tickets and enroll for classes: www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jane Voytek
    Sent: Thursday, October 31, 2013 5:45 PM
    To: Marie Kocher
    Subject: [Tessitura Development Forum] Another salutation question

     

    Many of our new accounts get set up on the web, and get entered as "John Smith" rather than "Mr. John Smith".

    We would like the "Dear" salutation to default to "John" if there is no title, but "Mr. Smith" if there is a title.  I've studied up on the documentation for TR_SALUTATION_FORMAT, but haven't found a way to do this.  Am I missing something, or has someone come up with a way to make this happen?




    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!

    Fancy Free
Reply
  • We do it manually by running a new accounts report and editing the records.

     

    Not only are names missing prefixes, but sometimes information is in all lowercase as well.

     

    Thanks,

     

    Marie

     

    --

    Marie Kocher | Development Assistant

    Kansas City Ballet

    Todd Bolender Center for Dance and Creativity

    500 W Pershing Road

    Kansas City, MO 64108

    816-931-2232 x 1382 | 816-931-1172 (fax)

    mkocher@kcballet.org

     

    Buy tickets and enroll for classes: www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jane Voytek
    Sent: Thursday, October 31, 2013 5:45 PM
    To: Marie Kocher
    Subject: [Tessitura Development Forum] Another salutation question

     

    Many of our new accounts get set up on the web, and get entered as "John Smith" rather than "Mr. John Smith".

    We would like the "Dear" salutation to default to "John" if there is no title, but "Mr. Smith" if there is a title.  I've studied up on the documentation for TR_SALUTATION_FORMAT, but haven't found a way to do this.  Am I missing something, or has someone come up with a way to make this happen?




    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!

    Fancy Free
Children
No Data