Create a separate table for primary email and primary phone, similar to primary address

Address(Primary) being it's own table allows you to export that information in query outputs, but Email Addresses and Phone Numbers are all stored in one table, so if you want to export the primary email and/or primary phone without getting duplicate rows, you must use an export defintiion. Creating a separate table for Email(Primary) and Phone(Primary) would allow all primary contact information to be included in ad-hoc query and smart query outputs. For example, my staff would love a Geographic Prospecting report build as a smart query definition, to just type in State and gift range. But because the primary email can only be exported via export definitions, they cannot use a smart query at all.
  • Guest
  • Jun 29 2015
  • Reviewed: Voting Open
  • Attach files
  • Jessica Quastler commented
    18 Dec, 2020 02:41pm

    It would make reporting so much easier!

  • Josue Urbina commented
    17 Dec, 2020 07:33pm

    We need this...

  • Erika Layfield commented
    4 May, 2016 03:44pm

    This is very important! 

  • +15