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
    December 18, 2020 14:41

    It would make reporting so much easier!

  • Josue Urbina commented
    December 17, 2020 19:33

    We need this...

  • Erika Layfield commented
    May 04, 2016 15:44

    This is very important! 

  • +15