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
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