Whenever we have a mailing or print tickets for will call the word "household" shows up. Example: John and Jane Smith Household. Is there any way to delete that word? Because it's internal lingo I think it looks confusing for patrons. Thanks!
I know you can change the default Household salutation by modifying TR_SALUTATION_FORMAT, but I was wondering if anyone had come up with a ticket design value mask expression that just strips ' Household' from the end of the header sal if it exists. Haven't tried it myself yet; wondering if anyone has done this already.
Sounds like you're pulling the household lname field rather than the salutation. Switch to the latter and the "household" should vanish.
On my ticket designs, I'm using "Constituent Display Name" and having the same issue.
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
The following “Mask” for “Constituent Display Name” in ticket design should work:
IF((RIGHT(val,10)=’ Household’), LEFT(val,LEN(val)-10),val)
I had used the following “Mask” for “Constituent Display Name” in ticket design, which worked:
Please note that there is a blank character before “Household”.
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Nick Reilingh Sent: Tuesday, January 05, 2016 11:17 AM To: Unal, Ahmet Subject: Re: [Tessitura Marketing Forum] Households
From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com> Sent: 1/5/2016 11:27:04 AM