Alpha sorting Household and Individual

I'm making a mail list that contains both Household and Individual records. Development want to be able to sort the list alphabetically. But sorting by last name doesn't work because the first letter of  household is somebody's first name . For example, the Steven and Liza Hanks Household will sort as "S" and not as "H."

I see that the constituent records have a "Sort Name" field. I tried running the list through and Output Set , but I can't find "Sort Name" as an option in Output Set Builder. Maybe it's right in front of me.

Any suggestions?

Parents
  • We are having the same issue – in our system we have “Program Listing Sort Name.” But it could have been a custom output set criteria. Sorry if that wasn’t much help.

     

    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)

     

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


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Steven Hanks
    Sent: Friday, August 24, 2012 2:01 PM
    To: Marie Kocher
    Subject: [Tessitura Development Forum] Alpha sorting Household and Individual

     

    I'm making a mail list that contains both Household and Individual records. Development want to be able to sort the list alphabetically. But sorting by last name doesn't work because the first letter of  household is somebody's first name . For example, the Steven and Liza Hanks Household will sort as "S" and not as "H."

    I see that the constituent records have a "Sort Name" field. I tried running the list through and Output Set , but I can't find "Sort Name" as an option in Output Set Builder. Maybe it's right in front of me.

    Any suggestions?




    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!

    Be Moved

Reply
  • We are having the same issue – in our system we have “Program Listing Sort Name.” But it could have been a custom output set criteria. Sorry if that wasn’t much help.

     

    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)

     

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


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Steven Hanks
    Sent: Friday, August 24, 2012 2:01 PM
    To: Marie Kocher
    Subject: [Tessitura Development Forum] Alpha sorting Household and Individual

     

    I'm making a mail list that contains both Household and Individual records. Development want to be able to sort the list alphabetically. But sorting by last name doesn't work because the first letter of  household is somebody's first name . For example, the Steven and Liza Hanks Household will sort as "S" and not as "H."

    I see that the constituent records have a "Sort Name" field. I tried running the list through and Output Set , but I can't find "Sort Name" as an option in Output Set Builder. Maybe it's right in front of me.

    Any suggestions?




    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!

    Be Moved

Children
No Data