Open the Page Views page in the System Setup Folder. Click New and fill out the fields as recommended in the view example.

The following Views may be created easily using the Advanced Search Tool with no additional SQL:

• Active 4th Graders
• Created by Same User
• Contacts Living Outside of Area
• Email Address, No User

The following Views may be created by adding or editing SQL in an otherwise straightforward View:

• Contacts In Groups
• Contacts with Milestones
• Groups Last Attended
• Groups Over Capacity
• Groups Under Capacity
• Head of Household With Minor Children
• New Donors Past 7 Days

The following Views may be created using advanced SQL concepts:

• Background Check Info
• Contact Changes Past 7 Days
• Contacts in Households Selection
• Contacts With Files Attached
• Email Address Updated Last 30 Days
• Event Rooms
• Events In Series
• Events Needing Approval
• Expiring Product Option Prices
• Fix-Same Email No Relationship
• Group Counts
• Group Members - Current User
• Group Participant Attributes
• Group Participant Form Submissions
• Group Participants in Selection
• Group Participants Not Serving On Ministry Team
• Household Donations
• New Donors Last Calendar Week
• Participant Heads of Households
• Phone Numbers for a Household
• Security Role - Field Restrictions
• Security Role - Reports Permitted
• Security Role - Page Permissions
• Security Role - Tools Permitted
• Tasks Attached to Contacts
• Top 50 Donors