In the navigation menu, click System Setup > Page Views. Click New View, and fill out the fields as recommended in the view example you want to add (linked under this help page).

You can create the following views using the Advanced Search Tool with no additional SQL:

• Active 4th Graders
• Created by User
• Contacts Out of Area
• Email Address No User

You can create the following views by adding or editing SQL in an otherwise straightforward view:

• Contacts in Groups
• Contacts with Milestones
• Group Last Attended
• Groups Over Capacity
• Groups Under Capacity
• Heads of Households with Minor Children
• New Donors Last 7 Days

You can create the following views using advanced SQL concepts:

• Background Check Information
• Contact Changes
• Contacts in Households Selection
• Contacts with Files Attached
• Email Addresses Updated Last 30 Days
• Event Rooms
• Events in Series
• Events Needing Approval
• Expiring Option Prices
• Fix: Same Email No Relationship
• Group Counts
• Group Members - Current User
• Group Participant Attributes
• Group Participant Form Submissions
• Group Participants in Selection
• Small Group Participants Not Serving on a Ministry Team
• Household Donations
• New Donors Last 7 Days
• New Donors Last Week
• Participant Heads
• Phone Numbers for a Household
• Reports Permitted
• Page Permissions
• Tools Permitted
• Tasks Attached to Contacts
• Top 50 Donors