Family Email

This script runs from the Main Menu if added to the Menu. It shows the Family ExtraValue with a Field name of Email along with other email addresses for the family. The report is one row per family.

Use Case - Conversions

This is intended for conversions when the previous software had a family email address. We don’t recognize family email in TouchPoint, so we put it into a Family Extra Value Text field (single email). If the church did not have emails on the individual people records, then they can run this report to know which records they need to correct.

The recommended name is FamilyEmail

Use the following code to Create the SQL Script. See How to create a SQL Script.

SELECT
    p.PeopleId,
    p.Name2 HeadOfHouse,
    Data,
    p.EmailAddress,
    p.EmailAddress2,
    sp.PreferredName Spouse,
    sp.EmailAddress SpouseEmail,
    sp.EmailAddress2 SpouseEmail2,
    (SELECT COUNT(*) FROM dbo.People m WHERE m.FamilyId = fe.FamilyId) FamilyCount
FROM dbo.FamilyExtra fe
JOIN dbo.Families f ON f.FamilyId = fe.FamilyId
JOIN dbo.People p ON p.PeopleId = f.HeadOfHouseholdId
LEFT JOIN dbo.People sp ON sp.PeopleId = p.SpouseId
WHERE Field = 'Email'
ORDER BY p.Name2