Hi, this is a simple one...I hope!
We're on V12.5. The Output Element "customer_lname" brings up first AND last names of couples in a household. This is really annoying for us - it means we can't alphabetize lists by last name, which we often need to do if its for an event and tracking RSVPs and reporting on these, as well as for running mailing lists by our CEO...she just wants to check them in alphabetical order!
Is there something wrong with our Output Element...or is there something I'm missing? Or is the Output Element truly this dysfunctional?? Please help :-)
"Customer_lname" will unfortunately pull both names together. We get around this by adding "Sort Name" to your output set though. This will pull an additional column with whatever the A1 constituent's sort name is on the account. In the case of John and Mary Smith, the sort name would be Smith/John, allowing you to alphabetize by the last name.