• Contents
  • Index
  • Recent Updates
  • Releases
  • Contents
  • Index
  • Recently Updated
  • Releases
  • Home
  • Administration
    • Setup
      • Lookup Codes
        • Create a New Lookup Item
        • Edit an Existing Lookup Item
        • Delete an Existing Lookup Item
        • Categories
      • Morning Batch
        • Set Up the Morning Batch
        • Testing Your Script
        • Sample Search
        • Sample Morning Batch Python Script
        • Performing an Action on a Particular Day of the Week
      • Promotion Setup
        • Video Demonstration
        • Create Promotion Structure
      • Administrative Settings
        • To Edit a Setting
        • To Create a New Setting Code
        • Settings
        • General
          • All
        • System
          • Administration
          • Church Info
        • Features
          • Check-In
          • Tasks & Notes
          • Prayer Requests
          • Mobile App
          • MyData Access
          • Quick Sign In
          • Registrations
          • Resources
          • Small Group Finder Map & Family Map
        • Status Flags
          • Volunteer Scheduler
        • Integrations
          • eSPACE
          • Powered By Text
          • MinistrySafe
          • Protect My Ministry
          • Pushpay
          • Rackspace
          • Twilio
          • Azure
          • Firebase
        • Finance
          • Batches
          • Contribution Search
          • Donor Covers Fees
          • Giving Tab
          • Online Giving
          • Pledges
          • Recurring
          • Statements
        • Security
          • Login
          • Miscellaneous
          • reCAPTCHA
          • SSO
      • Special Content
        • HTML Content
        • Text Content
        • Sql Scripts
        • Python Scripts
      • Set Up TouchPoint for Texting
        • Completing Setup for Twilio
        • Completing Setup for PBT
        • Configuring Users and Groups
        • Facts re Groups, Numbers, and Users
      • Using a Custom Header
        • Logo Requirements
        • Custom Header Settings
      • Using a Custom Login Page
        • Setting Up Your Custom Login Page
        • Creating Campus-Specific Login Pages
        • Choose a Sample Shell as a Starting Point
      • Zip Codes
        • To Create Resident Codes
        • To Create the Table
    • Users and Roles
      • New Users And Roles
        • Users Page
        • Create a New User
        • Adjust roles for an existing user
        • Copy user roles
        • Add a New Role
        • Role Definitions
        • User Roles
        • Job Position Examples
        • Impersonate a User
      • Best Practices: Adding and Removing Users
        • New Staff Users
        • New Lay Leaders
        • Manage Users when Their Position Changes
        • Communication with New Staff
      • User Accounts and New User Welcome
      • Change Password
      • Custom Access Roles
        • Setting Role Priorities
        • Changing Custom Access Settings
        • Custom Access Settings
          • Involvement Category
          • Meetings Category
          • General Category
          • Person Category
      • Forgot Password or Username
      • Password Settings
      • Activity Log
        • Search
        • Links
      • Search Users
        • Search for Users
      • Lay Leaders as Users on TouchPoint
        • OrgLeadersOnly Role
        • FAQ re Lay Leaders
      • User Email Delegation
        • To Delegate a User
        • To Edit or Remove Permissions
        • To Email on Behalf of a User
        • Tracking Emails Sent on Behalf of Another User
    • Management
      • Programs, Divisions, and Involvements
        • Programs
        • Divisions
        • Create a New Program
        • Create a New Division
          • Changing Programs for a Division
        • Assign Involvements to a Division
        • Main Division
          • Set the Main Division for an Involvement
      • Annual Promotion
        • When to use Manage Involvement Members for Promotion
        • When to use Annual Promotion
        • Steps in Using Annual Promotion
        • Moving Students to a Different Pending Class
          • Moving One Member at a Time
          • Moving Several Members
          • Dropping Pending Enrollment
      • Sending Emails
        • Video
        • Basics Steps for Sending Emails
        • Options for Adding Recipients
          • Add Person to Email
          • Add CC/Reply-To
          • Use Cases for CC and Reply-To
        • Creating a New Email from an Existing One
      • How to Send Texts via TouchPoint
        • Send a Text
        • Multimeda Messages (MMS)
        • Including Special Links in Text Messages
        • URL Shortening
        • Tracking Texts
      • Transactions Log
        • Required User Roles
        • Totals Bar
        • Information Contained in the Transactions Log
        • Actions
        • Filters
        • Other Reports
        • Filter
        • Mission Trip Transactions
      • Check-In Labels
        • Label Formats
      • Add Members Using a Tag
    • Batch Actions
      • Tag People IDs
      • Batch Update Fields from a Tag or Query
        • Use Case 1 - Making Employer Names Consistent
        • Use Case #2 - Statement Option
        • Use Case #3 - Grade (Legacy field only)
      • Batch Update Involvement Settings
        • To Update Involvements
        • The fields/columns that can be updated
        • Add Sub-Groups Using Batch Update
      • Status Flags
        • Purpose
        • How Status Flags Work
        • Where To Find Status Flags
        • Starter Set
        • How To Create Status Flags
        • Status Flag For Emergency Contacts
        • Status Flag Settings
      • Original Use of Status Flags
      • Protected Status Flags
        • Create a Protected Status Flag
      • Validate Address for a Tag or Query
        • Validate Multiple Addresses
    • Data Security, Active Records, Email Deliverability
      • Data Security
        • Security Architecture
      • Nightly Database Backups
      • Privacy Statement
      • Single Sign-On (SSO) Integration
        • Infrastructure Setup
        • TouchPoint Application Settings
        • Configure Users for SSO
      • Two Factor Authentication
        • Configuring 2FA
        • User Setup
        • Common Supported Authenticators
        • What if a user lost or left their phone at home?
      • Email Deliverability
      • About your Database
      • Active Records
    • Misc
      • TouchPoint News
      • Church News
      • Using a Custom Login Page
        • Setting Up Your Custom Login Page
        • Creating Campus-Specific Login Pages
        • Choose a Sample Shell as a Starting Point
      • Custom Login Shell - Sample 1
        • Customizing the Image
        • Customizing the Button Color
        • Customizing the Footer Text
        • Using the Sample 1 Code
      • Custom Login Shell - Sample 2
        • Customizing the Logo
        • Customizing the Button Color
        • Customizing the Footer Text
        • Using the Sample 2 Code
      • Custom Login Shell - Sample 3
        • Customizing the Logo
        • Customizing the Image
        • Customizing the Button Color
        • Customizing the Footer Text
        • Using the Sample 3 Code
      • Custom Login Shell - Sample 4
        • Customizing the Logo
        • Customizing the Image
        • Customizing the Transparency of the Logon Form
        • Customizing the Button Color
        • Customizing the Footer Text
        • Using the Sample 4 Code
      • Custom Login Shell - Sample 5
        • Customizing the Logo
        • Customizing the Background Image
        • Customizing the Transparency of the Logon Form
        • Customizing the Button Color
        • Customizing the Instructions
        • Using the Sample 5 Code
      • Development Partner Program FAQ
      • Product Update Releases
        • Regular Releases
        • Hotfixes
        • Scheduled Maintenance
        • Do Not Release Periods
      • FAQ
        • People
        • Organizations / Attendance
        • Contributions
      • Member Profile Automation for Deceased Only
        • How this Works
        • Change Member Profile Automation
      • Registration History
        • Run the Registration History Report
        • Filters
      • Registration Summary
        • Run the Registration Summary
      • Sponsored Work
        • When Is It Appropriate to Sponsor Work?
        • Using a Third-Party
      • Translations
        • Selecting A Language
        • Updating Translations
        • Translation Files (Legacy)
  • Blue Toolbar
    • Toolbar General
      • Toolbar Options
        • Email and Texting (envelope icon)
        • Exports and Reports (cloud icon)
          • Export Excel
            • Involvement Members Exports
          • Other Exports
          • Reports
          • Involvement Members Reports
          • Directories
          • Address Labels
          • Other Labels
          • Choose Format Dialog
          • Involvement Attendance
        • Custom Reports (code icon)
          • Custom Reports
          • SQL and Python Reports
        • Actions (gear icon)
          • Administrative
          • Tags
          • Contacts and Tasks
            • Extra Values
            • Meeting Operations
            • Meeting - Convert to Search
            • Checks/Trainings
            • Users
    • Individual Options
      • Compact Directory
        • Sample
      • Family Picture Directory
        • Generate a Family Picture Directory
        • Sample
      • Picture Directories w/Individual Photos
        • Generate a Picture Directory
        • Samples
      • Directories
        • Online Directories for Organizations
        • Directories on the Toolbar
      • Custom DocX Directory
        • Requirements
        • Replacement Codes
        • Including optional lines in the output
          • Use the DocX Directory
      • Family Mapping
        • Setup
        • Feature Use
          • Identify Geo-Region On A People Record
          • Use Search Builder To Identify Those Within a Geo-Region
          • Run Report To See Families On A Map
      • Contact Report
        • Sort by Address
      • Custom Reports
        • Create a Custom Report
        • Sample Report
        • Run an Existing Custom Report
        • Edit an Existing Custom Report
        • Spreadsheet of Basic Column Headers / Fields
      • Export Members
        • Generate the Export
      • Export Involvements to Excel
        • Uses for the Involvement Excel Export
          • Generate the Export
        • Information included in the export:
      • Engagement Score Report
      • Family Export
        • Run the Export
        • Sample
      • Labels - Family and Group By Address
        • Address Labels - Family
        • Address Labels - Group by Address
      • Printing Avery 5160 Labels
        • Skip Used Labels
        • Alignment Problems for Avery Labels
      • Status Flag Export
      • Word Merge
        • Saving and Uploading the Document
        • Add Merge to Custom Reports
        • Test the Report
        • Use the DocX Merge
      • Word Merge Family Directory
        • Create a Family Directory Using Word Merge
      • Word Merge Picture Directory
        • Create a Picture Directory using Word Merge
        • Inserting the Image into the Mail Merge
        • Complete the Word Merge
  • Check-In
    • Getting Started
      • Check-In Overview
        • Key Points to Consider
        • Setting Up Check-In
      • Hardware List for TouchPoint Check-In
        • Check-In Print Server
        • Check-In Clients
        • Label Printers
        • Labels
        • QR Scanners for Pre Check-In
        • Kiosks & Stands
      • Check-In Administrative Settings
      • Involvement Settings for Check-In
      • Check-In Profiles
        • General Tab
        • Testing Tab
        • Security Tab
        • Printing Tab
        • Labels Tab
        • Design Tab
        • Add Family Tab
        • Manage Recommended
      • Check-In Users
      • Check-In Labels
        • Label Formats
      • Custom Check-In Labels
        • Steps to create a custom label
        • Helpful formatting tips for specific elements
    • Using Check-In
      • Using Check-In
        • Running Check-In in Kiosk Mode
        • Member Check-In
        • Guest Check-In
        • Add a Record
        • Add a family
        • Log Out of Check-In
      • Check-Out
        • How To Set Up
        • Who Are Authorized Check-Out People
        • How To Authorize Check-Out People
        • Check-Out Settings
      • Pre Check-In
        • Accessing Pre Check-In
        • Using Pre Check-In
        • Additional Details
        • QR Code Scanner
      • Check-In Troubleshooting
        • I can’t get the label to print.
        • My security code/label text is getting cut off.
        • A child is checking in but not getting the security label or getting an adult tag.
        • Why can’t someone check in/no classes are available for Check-In.
    • Printers
      • Printer Settings for Check-In
      • GoDEX Printer Settings for Check-In (DT4, DT4x, DT4xW)
      • GoDEX Printer Configuration for Check-In (DT200)
        • Purchase Information
      • Brother Printer Settings for Check-In
      • Dymo Printer Settings for Check-In
      • Print Server for Check-In
        • Setting Up the TouchPoint Check-In Print Server
        • Running Print Servers
        • Modifying a Print Server’s Configuration
        • Removing a Print Server
        • Automatically Launching
    • Additional Features
      • Extra Value - PIN
        • Add a PIN
      • Check-In Dashboard
        • Set Up
        • Accessing the Check-In Dashboard
        • Using the Check-In Dashboard
        • Layout
      • Classroom Dashboard
        • Layout
      • Check-In Control Report
        • Run the Check-In Control Report
      • Key Fobs and Scanners
        • Pre Check-In
    • Building Checkin
      • Building Check-In
        • Building Check-In Process
        • Create the Saved Search
        • Setup Building Check-In Profile
        • Other Options
        • Using Building Check-In
        • How it Works for the Attendant
        • How It Works for the Person Checking In
      • Check-In Activity Log
  • Tasks and Notes
    • Tasks
      • Managing and Searching for Tasks
      • Mobile App
      • Create a Task for One Person
      • Transferring Tasks
      • Creating Tasks from a Search Result or Tag
      • Action Buttons and My Action Required Filter
    • Add a Note
      • How to Add a Note
      • Touchpoints Tab
    • Tasks & Notes Keywords
      • Step by Step Instructions for Keywords
      • System Keywords
      • Deleting a Keyword, Extra Question and/or Option
    • Tasks & Notes Search Page
      • Tabs
      • Filtering
      • Quick Search
      • Easy Access
      • Actions
      • Mass Actions
    • Tracking Tasks and Notes
      • Who Can See Tasks & Notes?
      • Using Search Builder to Track Incomplete Tasks
        • Incomplete Assigned Tasks
        • Incomplete Tasks About
    • Upload Tasks & Notes
      • Uploading New Tasks/Notes
      • Making Mass Edits To Existing Tasks/Notes
    • Videos
  • Programming TouchPoint Using Python and SQL
    • Programming TouchPoint Using Python and SQL
      • SQL Recipes
        • Background Checks
          • Sample Report
          • SQL Code for Background Checks
        • Blended Families Report
          • Create the Blended Families Script
          • Code
        • Compact Family Report
        • Extra Value Details Report
          • Create the Extra Value Details Script
        • Giving Change
          • Sample Report
        • Giving Change Fund
          • Sample Report
        • Giving Snapshot by Quarters
          • SQL Code for the Report
        • Has Multiple Main Fellowships
          • SQL Code for the Report
        • Master Pager List
          • Create a Master Pager List Script
          • Code
        • User People Tagged
        • User Roles
          • Sample User Roles Report
          • SQL Code for User Roles Report
        • Zip Count Report
          • Create the Report
            • Run this Report
          • Sample Report
        • Absents Report
          • Sample Report
          • Create to SQL Report
          • SQL Code
        • Attendance Change Detail for Orgs
        • Attendance Change for Orgs
        • Average Attendance For Organizations
        • Average Monthly Attendance For Organizations
        • Bad Enrollment Transactions
        • Count Meetings By Org
        • Directory Enabled
          • Sample Report
          • Create the SQL Report
          • SQL Code
        • Member Type in Org
        • Org Attend Counts
        • Org Givers
        • Org Giving Totals
        • Org Percent Giving
        • Org Search Member Stats
        • User People Tagged For Orgs
        • Visitor Attend Percent for Orgs
          • Create to SQL Report
          • Run the report
        • Age Range Giving Units
        • Average Attendance Compare
          • Create Script for Average Attendance Comparison
          • Code
        • Average Monthly Attendance for an Org
          • Create the Script
          • Code
        • Average Annual Attandance By Org
        • Bad Extra Values
        • Couples With Different Contribution Options
        • Deceased This Month
          • Create Deceased This Month Report
          • Code
        • Family Email
        • Family With Duplicate Addresses
        • First Gifts in Past 365 Days
          • Sample Report
            • Create the First Gifts 365 Report
        • Givers Over Amount Report
          • Sample Report
        • Giving Units (Date Range)
        • Giving Units 365
        • Kids To Move
        • Last Attend Last Gift 365
          • Create the Report
          • Sample Report
        • Meeting Attend Dates Different
        • New Member Giving
          • Create New Member Giving Script
          • Code
        • Offsite Trip Organizations
        • Organization Giving
          • Status Flag
          • Create OrgGiving SQL Report
          • Code
        • Orgs Limit to Role
          • Create Orgs Limit to Script
          • Code
        • Parent Child Involvements Report
        • Picture Directory
        • Previous Sub Groups
          • Sample Excel Report
          • Sample Browser Report
          • Code
        • Recent Visitors to Division
          • Run this Report
            • Create the Report
            • Sample Report
        • Recurring Gifts
        • Register Email not Equal to Personal Email
        • Registration Sub Groups
        • Registration Without Account Codes
          • Report Details
          • Cleanup Process
          • Create the Report
        • Top 200 Donors with Email
        • Top Giving Families
        • Total Gifts >= 5000
        • Class List
          • Create the Class List Report
        • Class List 2
          • Create Class List 2 SQL Report
        • Contribution Basics Report
          • Add the Contribution Basics Report to your Database
          • Run the Contribution Basics Report
        • Custom Contributions Search Export
          • Add the Export
          • Code
        • Custom Transaction Report
          • Create a Custom Transaction Report
          • Run the Custom Transaction Report
        • Custom Transaction Report Using Batch Dates
          • Create a Custom Transaction Report
          • Run the Custom Transaction Report
        • Details with Fees
          • Create the Details with Fees Report
          • Run the Details with Fees Report
          • Code for the Report
        • Giving Change Quarters
          • To Run the Report
          • Sample Report
          • Create the Giving Change Quarters Report
          • Giving Change Quarters Code
        • Gloo Church Analytics Export
          • Create a Custom Transaction Report
          • Run the Custom Transaction Report
        • Monthly Giving Analysis
          • Sample Report
          • Create the Monthly Giving Analysis Report
          • Run the Monthly Giving Analysis
        • Totals by Fund Payment Type
          • Create Script for TotalsByFundPaymentType
          • Code
        • Totals by Fund with Fees
          • Create the Totals by Fund with Fees Report
          • Run the Totals by Fund with Fees Report
          • Code for the Report
        • Yearly Giving Analysis
          • Sample Report
          • Create the Yearly Giving Analysis Report
          • Run the Yearly Giving Analysis
      • Python
        • Python Recipes
          • Batch Report
            • Create the Batch Report
            • Generate the Batch Report
            • Python Code
          • Batch Report 2
            • Create the Batch Report
            • Generate the Batch Report
            • Python Code
            • SQL Code
          • Batch Report 3
            • Create the Batch Report
            • Generate the Batch Report
            • Python Code
            • SQL Code
          • Batch Report by Campus
            • Create the Batch Report
            • Generate the Batch Report
            • Python Code
            • SQL Code
          • Batch Report with Fee Rows
            • Create the Batch Report
            • Generate the Batch Report
            • Python Code
            • SQL Code
          • Batch Report by Type
            • Create the Batch Report
            • Generate the Batch Report
            • Python Code
            • SQL Code
          • Faith Path Stage of Life Campaign
            • Search Criteria
            • Sample Email with a Video Embedded
            • Code for Python Script
          • Five Year Giving Report
            • Sample Report
              • Create Five Year Giving Report
              • Five Year Giving Code
          • Giving Dashboard
            • Giving Types Report
            • Giving Households Report
            • Giving Forecast Report
          • LoginMetrics for Churches with Campuses
            • Create the LoginMetrics Script
          • LoginMetrics for Churches without Campuses
            • Create the LoginMetrics Script
          • Member Status Chart
            • Create Member Status Chart
          • Morning Worship Chart
            • Create Morning Worship Script
          • Move Kids
          • Multi-Batch Report
            • Create the Multi-Batch Report
            • Generate the Multi-Batch Report
            • Python Code
            • SQL Code
          • Multi-Batch Report 2
            • Create the Multi-Batch Report
            • Generate the Multi-Batch Report
            • Python Code
            • SQL Code
          • Multi-Batch Report 3
            • Create the Multi-Batch Report
            • Generate the Multi-Batch Report
            • Python Code
            • SQL Code
          • Multi-Batch Report by Campus
            • Create the Multi-Batch Report
            • Generate the Multi-Batch Report
            • Python Code
            • SQL Code
          • Multi-Batch Report with Fee Rows
            • Create the Multi-Batch Report
            • Generate the Multi-Batch Report
            • Python Code
            • SQL Code
          • Multi-Batch Report by Type
            • Create the Multi-Batch Report
            • Generate the Multi-Batch Report
            • Python Code
            • SQL Code
          • New Guest Email Campaign
          • New Guest History Report
          • Financial Peace University Packet Pickup Project
            • Overview
          • Prayer Digest
            • SQL Script
              • Add the SQL Script
              • Customize the SQL Script
            • Python Script
              • Add the Python Script
              • Customize the Python Script
            • Manually Run the Report
            • Automate the email
          • Python Charts
          • Recent Inactive Today
            • Installation
            • Explanation of the code
          • RecurringGivingForecast
            • Create the RecurringGivingForecast Script
          • Settlement Report
            • Configure the Settlement Report
            • Run the Settlement Report
            • Code for the Settlement Report Python Script
          • Shape Data Integration
            • To Install
              • UpdateShapeData Python Script
              • PeopleWithShapeData SQL Script
          • Three Year Giving
            • Create Three Year Giving Report
            • Three Year Giving Code
          • Vital Stats Report
            • Explanation of Contribution numbers computed
          • MailChimp Integration
            • TouchPoint Setup for MailChimp Integration
              • Step 1 - Create a User Account on MailChimp
              • Step 2 - Add Python and SQL Scripts to your Database
              • Step 3 - Set up your Mailing Audience Involvements in TouchPoint
              • Step 4 - Create a Mail Chimp Campaign and Send an Email
              • Unsubscribe
            • Your MailChimp Account
              • Python Script: MailChimpSync
              • SQL Script: MailChimpMembersOfInvolvement
              • SQL Script: MailChimpInvolvementsSql
            • TouchPoint Mailing Audience Involvements
              • Required MailChimp Extra Value
              • Optional Extra Values
        • Python Model
          • Contributions
            • model.AddContribution()
            • model.AddContribution()
            • model.AddContributionDetail()
            • model.CloseBundle()
            • model.CreateContributionTag()
            • model.CreateContributionTagFromSql()
            • model.DeleteContribution()
            • model.DeleteContributionTags()
            • model.FetchOrCreateFund()
            • model.FindBundleHeader()
            • model.FindBundleHeader()
            • model.FindContribution()
            • model.FindOrCreateBundleHeader()
            • model.FinishBundle()
            • model.FirstFundId()
            • model.GetBundleHeader()
            • model.MoveFundIdToExistingFundId()
            • model.MoveFundIdToNewFundId()
            • model.QueryContributionIds()
            • model.ResolveFund()
            • model.ResolveFundId()
          • Dates
            • model.AddDays()
            • model.DateTime
            • model.DayOfWeek
            • model.DateAddDays()
            • model.DateAddHours()
            • model.DateDiffDays()
            • model.FormatDate()
            • model.MostRecentAttendedSunday()
            • model.ParseDate()
            • model.ParseDateUTC()
            • model.ResetToday()
            • model.ScheduledTime
            • model.SetToday()
            • model.SundayForDate()
            • model.SundayForWeek()
            • model.WeekNumber()
            • model.WeekOfMonth()
          • Deprecated Functions
            • Email
              • model.Email2()
              • model.EmailContent()
              • model.EmailContent2()
              • model.EmailContent2()
              • model.EmailStr()
            • Organization
              • model.OrgMembersQuery()
            • ManagedGiving
              • model.DisableRecurringGiving()
            • Misc
              • model.FromJson()
            • Tasks
              • model.CreateTask()
              • model.CreateTask()
          • Docusign
            • model.docusign.ApiClient()
            • model.docusign.Configuration()
            • model.docusign.Document()
            • model.docusign.EnvelopeDefinition()
            • model.docusign.EnvelopesApi()
            • model.docusign.EnvelopesApi()
            • model.docusign.ListStatusChangesOptions()
            • model.docusign.Recipients()
            • model.docusign.RecipientViewRequest()
            • model.docusign.SignHere()
            • model.docusign.Signer()
            • model.docusign.Tabs()
            • model.docusign.TemplateRole()
            • model.docusign.TemplateTabs()
            • model.docusign.Text()
          • DynamicData
            • model.DynamicData()
            • model.DynamicData()
            • model.GetValue()
            • model.Remove()
            • model.AddValue()
            • model.SetValue()
            • model.ToString()
            • model.ToFlatString()
            • model.Keys()
            • model.SpecialKeys()
          • Email
            • model.TestEmail
            • model.Transactional
            • model.ContentForDate()
            • model.Email()
            • model.EmailContent()
            • model.EmailContentWithSubject()
            • model.EmailReminders()
            • model.EmailReport()
            • model.EmailReport()
            • model.EmailStr()
          • ExtraValues
            • model.AddExtraValueAttributes()
            • model.AddExtraValueBool()
            • model.AddExtraValueCode()
            • model.AddExtraValueDate()
            • model.AddExtraValueInt()
            • model.AddExtraValueText()
            • model.DeleteAllExtraValueLike()
            • model.DeleteExtraValue()
            • model.ExtraValue()
            • model.ExtraValueAttributes()
            • model.ExtraValueBit()
            • model.ExtraValueCode()
            • model.ExtraValueDate()
            • model.ExtraValueInt()
            • model.ExtraValueText()
          • ExtraValuesOrg
            • model.AddExtraValueBoolOrg()
            • model.AddExtraValueCodeOrg()
            • model.AddExtraValueDateOrg()
            • model.AddExtraValueIntOrg()
            • model.AddExtraValueTextOrg()
            • model.ExtraValueBitOrg()
            • model.ExtraValueCodeOrg()
            • model.ExtraValueDateOrg()
            • model.ExtraValueDateOrgNull()
            • model.ExtraValueIntOrg()
            • model.ExtraValueOrg()
            • model.ExtraValueTextOrg()
          • Forms
            • model.BuildDisplay()
            • model.BuildDisplayRows()
            • model.BuildForm()
            • model.BuildFormRows()
            • model.Form
            • model.Header
            • model.HttpMethod
            • model.Script
          • Handlebars Templates
            • model.RenderTemplate()
            • HandleBars Helpers
          • JsonDocumentRecords
            • model.AddUpdateJsonRecord()
            • model.AddUpdateJsonRecord()
            • model.DeleteJsonRecord()
            • model.DeleteJsonRecordSection()
            • model.SqlListDynamicData()
            • model.SqlTop1DynamicData()
            • model.SqlList()
          • ManagedGiving
            • model.DisableRecurringGiving()
          • Meetings
            • model.AddExtraValueMeeting()
            • model.DeleteExtraValueMeeting()
            • model.EditCommitment()
            • model.EditPersonAttendance()
            • model.ExtraValueMeeting()
            • model.GetMeeting()
            • model.GetMeetingIdByDateTime()
            • model.GetMeetingIdByDateTime()
            • model.GetMeetingIdsByDateTime()
            • model.GetMeetingsByDateTime()
            • model.GetMeetingsByDateTime()
            • model.GetMeetingsByDateTimeRange()
            • model.GetMeetingsByDateTimeRange()
            • model.GetNextScheduledMeetingDate()
            • model.MeetingDidNotMeet()
            • model.MeetingIsAllDay()
            • model.MeetingShowAsBusy()
            • model.UpdateMeetingDate()
            • model.UpdateMeetingDuration()
            • model.UpdateMeetingEnd()
          • Misc
            • model.AppendIfBoth()
            • model.BirthdayList()
            • model.CallScript()
            • model.Content()
            • model.CreateCustomView()
            • model.CreateQueryTag()
            • model.CsvReader()
            • model.CsvReader()
            • model.CsvReaderNoHeader()
            • model.CustomStatementsFundIdList()
            • model.CmsHost
            • model.Data
            • model.DataHas()
            • model.DebugPrint()
            • model.DeleteFile()
            • model.DeleteQueryTags()
            • model.Dictionary()
            • model.DictionaryAdd()
            • model.DynamicData()
            • model.DynamicDataFromJson()
            • model.DynamicDataFromJsonArray()
            • model.Draft()
            • model.DraftTitle()
            • model.ElementList()
            • model.ExecuteSql()
            • model.FmtPhone()
            • model.FmtZip()
            • model.FormatJson()
            • model.FormatJson()
            • model.FromMorningBatch
            • model.GetCacheVariable()
            • model.HtmlContent()
            • model.JsonDeserialize()
            • model.JsonDeserialize2()
            • model.JsonSerialize()
            • Markdown()
            • model.Md5Hash()
            • model.PythonContent()
            • model.ReadFile()
            • model.RegexMatch()
            • model.Replace()
            • model.ReplaceCodeStr()
            • model.ReplaceQueryFromCode()
            • model.RestDelete()
            • model.RestGet()
            • model.RestPost()
            • model.RestPostJson()
            • model.RestPostXml()
            • model.SetCacheVariable()
            • model.Setting()
            • model.SetSetting()
            • model.SpaceCamelCase()
            • model.StatusFlagDictionary()
            • model.StatusFlagList()
            • model.SqlContent()
            • model.TextContent()
            • model.TagLastQuery()
            • model.TitleContent()
            • model.Trim()
            • model.UrlEncode()
            • model.UserName
            • model.UserPeopleId
            • model.UpdateStatusFlag()
            • model.UpdateStatusFlags()
            • model.UserIsInRole()
            • model.WriteContentHtml()
            • model.WriteContentPython()
            • model.WriteContentSql()
            • model.WriteContentText()
            • model.WriteFile()
          • Organizations
            • model.AddMembersToOrg()
            • model.AddMemberToOrg()
            • model.AddOrganization()
            • model.AddOrganization()
            • model.AddSubGroup()
            • model.AddSubGroupFromQuery()
            • model.AddTransaction()
            • model.AddTransaction()
            • model.AdjustFee()
            • model.CurrentOrgId
            • model.DeleteOrg()
            • model.DropOrgMember()
            • model.GetOrganization()
            • model.GetPayLink()
            • model.InOrg()
            • model.InSubGroup()
            • model.JoinOrg()
            • model.MoveToOrg()
            • model.OnlineRegPerson()
            • model.OnlineRegPerson()
            • model.OrganizationIds()
            • model.RemoveSubGroup()
            • model.SendAttendanceReminders()
            • model.SetMemberType()
            • model.UpdateMainFellowship()
          • Person
            • model.AddBackgroundCheck()
            • model.AddPerson()
            • model.AddRole()
            • model.AddTag()
            • model.AgeInMonths()
            • model.ArchiveRecords()
            • model.ClearTag()
            • model.DeletePeople()
            • model.FindAddPeopleId()
            • model.FindAddPerson()
            • model.FindPersonId()
            • model.FindPersonId()
            • model.FindPersonIdExtraValue()
            • model.FindPersonIdExtraValueInt()
            • model.GetAuthenticatedUrl()
            • model.GetAuthenticatedUrl()
            • model.GetPerson()
            • model.GetPerson()
            • model.GetSpouse()
            • model.PeopleIds()
            • model.RemoveRole()
            • model.UnArchiveRecords()
            • model.UpdateAllSpouseId()
            • model.UpdateCampus()
            • model.UpdateContributionOption()
            • model.UpdateElectronicStatement()
            • model.UpdateEnvelopeOption()
            • model.UpdateField()
            • model.UpdateMemberStatus()
            • model.UpdateNamedField()
            • model.UpdateNewMemberClassDate()
            • model.UpdateNewMemberClassDateIfNullForLastAttended()
            • model.UpdateNewMemberClassStatus()
            • model.UpdatePerson()
            • Statement/Envelope Options
          • The Query Parameter
          • Sms
            • model.SendSms()
            • model.CreateTinyUrl()
          • SqlGrid
            • model.SqlGrid()
          • Tasks & Notes
            • model.CreateTaskNote()
            • model.GetExtraQuestions()
            • model.GetExtraQuestionsByKeywords()
            • model.GetExtraQuestionsWithAnswers()
            • model.GetTaskNote()
            • model.GetTaskNoteKeywordIds()
            • model.GetTasksNotes()
            • model.SetTaskNoteKeywordIds()
            • model.SetTaskNoteStatus()
            • model.TaskNoteAccept()
            • model.TaskNoteComplete()
            • model.TaskNoteDecline()
            • model.TaskNoteEdit()
            • model.TaskNoteMassAddKeywords()
            • model.TaskNoteMassArchive()
            • model.TaskNoteMassAssign()
            • model.TaskNoteMassComplete()
            • model.TaskNoteMassDelete()
            • model.TaskNoteMassUnarchive()
          • Upload
            • model.UploadExcelFromSqlToDropBox()
            • model.UploadExcelFromSqlToDropBox()
            • model.UploadExcelFromSqlToFtp()
        • Query Functions
          • Attendance
            • Properties
              • q.LastSunday
            • Functions
              • q.AttendanceTypeCountDateRange()
              • q.AttendCountAsOf()
              • q.AttendMemberTypeCountAsOf()
              • q.LastWeekAttendance()
              • q.MeetingCount()
              • q.MeetingCountDateHours()
              • q.NumPresent()
              • q.NumPresentDateRange()
            • Number of Attendances vs Number of People
          • Contributions
            • q.ContributionTotals()
            • q.ContributionCount()
            • q.DateRangeForContributionTotals()
            • Funds Parameter
          • People
            • q.BlueToolbarCount()
            • q.BlueToolbarReport()
            • q.GetWhereClause()
            • q.QueryCount()
            • q.QueryList()
            • q.QueryPeopleIds()
            • q.QuerySql()
            • q.QuerySqlInts()
            • q.QuerySqlInt()
            • q.QuerySqlJsonArray()
            • q.QuerySqlPeopleIds()
            • q.QuerySqlScalar()
            • q.QuerySqlStr()
            • q.QuerySqlTop1()
            • q.SqlNameCountArray()
            • q.StatusCount()
            • q.TagCount()
            • q.TagQueryList()
            • q.TagSqlPeopleIds()
            • q.SqlFirstColumnRowKey()
            • q.SqlNameValues()
            • q.SqlPeopleIdsToQuery()
          • Sort Parameter
        • Other References
          • LookupTable Object
          • Fields on Organization Object
          • Person Object
      • APIs
        • OData API
          • People
          • Contributions
          • Pledges
          • Funds
          • Lookups
          • Organizations
          • Custom
        • GetOneTimeLoginLink and GetOnetimeRegisterLink APIs
          • Prerequisites
          • Usage
          • GetOneTimeLoginLink API
          • GetOneTimeRegisterLink API
        • Push Post API
          • AddContribution()
          • ReverseContribution()
        • http://www.tpsdb.com/Public/BVCMSCheckinAPI.htm
        • Personal Access Tokens
          • Creating a Personal Access Token
          • Deleting/Invalidating a Personal Access Token
          • Impersonating Another User with Personal Access Tokens
        • TouchPoint Authentication in External Applications
          • Validating Users
          • Linking to External Systems
            • Giving Pages
            • Mobile v3.x Banners
            • External Systems
      • Homepage Widgets
        • Management
          • Homepage Widgets
            • Managing Widgets
            • Video: Managing Widgets
            • Video: Changing Widget Colors
          • Multiple Dashboards
            • Editing the Code
            • New Dashboard Code
        • Individual Widgets
          • Attendance Year over Year Widget
            • Video
            • HTML Code
            • SQL Script
            • Python Script
          • Birthdays Widget
            • HTML Code
            • Python Script
          • Church News Widget
            • HTML Code
            • Python Script
          • Contact Trend Widget
            • Video
            • HTML Code
            • SQL Script
            • Python Script
          • Division Comparison Widget
            • Video
            • HTML Code
            • SQL Script
            • Python Script
          • Giving Change Widget
            • Video
            • HTML Code
            • SQL Script
            • Python Script
          • Giving Sources Widget
            • Customizing the Giving Sources Widget
            • Video
            • HTML Code
            • SQL Script
            • Python Script
          • Giving to Budget Comparison Widget
            • Video
            • HTML Code
            • SQL Script
            • Python Script
          • Giving Type Breakdown Widget
            • Video
            • HTML Code
            • SQL Script
            • Python Script
          • Login Metrics Widget
            • HTML Code
            • Python Script
          • My Involvement Widget
            • HTML Code
            • SQL Script
            • Python Script
          • My Searches Widget
            • HTML Code
            • SQL Script
            • Python Script
          • My Tags Widget
            • HTML Code
            • SQL Script
            • Python Script
          • My Tasks Widget
            • HTML Code
            • SQL Script
            • Python Script
          • Quick Links Widget
            • Video
            • HTML Code
          • Recent Attendance Trends Widget
            • HTML Code
            • SQL Script
            • Python Script
          • Recurring Giving Widget
            • Video
            • HTML Code
            • SQL Script
            • Python Script
          • TouchPoint News Widget
            • HTML Code
            • Python Script
          • Vital Stats Widget
            • Video
            • HTML Code
            • Python Script
          • Welcome to TouchPoint Widget
            • HTML Code
    • Custom Recipes
    • Writing Your Own Scripts
  • Email and Texting
    • Emails
      • Emailing in TouchPoint
      • Creating HTML Emails
        • HTML Editor
        • Getting Started
        • Technical notes:
      • Creating Mobile Responsive Emails
        • Creating Templates with Mobile Responsive Email Builder
        • Content
        • Blocks
        • Body
        • Images
        • General Tools and Settings
        • Modifying the Supplied Example Template
      • Sending Emails
        • Video
        • Basics Steps for Sending Emails
        • Options for Adding Recipients
          • Add Person to Email
          • Add CC/Reply-To
          • Use Cases for CC and Reply-To
        • Creating a New Email from an Existing One
      • Email Footers
        • Include an Unsubscribe Link
        • Include Your Church Name and Physical Mailing Address
      • Unsubscribe Link
        • How to Use Unsubscribe in your Emails
        • What Does the Recipient See
        • Manually Unsubscribe a Recipient
      • Email/SMS Replacement Codes
        • All Emails
          • Email Related Replacements
          • Personal Information
          • Contribution Statement Options
          • Extra Values
          • Replacements for Members of a Division
          • Drop Membership from an Involvement
        • Involvement Context - Confirmations, Reminders, Normal Email
        • Confirmation Emails
        • New User Email
        • Contribution-Related Email Templates
        • Recurring Gift Notice
          • Pledge Replacements
        • Continue Registration Link Email
        • DiffEmailMessage or NoEmailMessage
        • CreateAccount
        • SMS Texting Replacement Codes
        • Scheduler
        • Ticketing
      • Emailing Files, Images (Pictures), or Videos
        • Why send links instead of attachments?
        • Important Caveats
        • Instructions for Using Email Builder
        • Instructions for Using the Older Editor
      • MailChimp Integration
        • TouchPoint Setup for MailChimp Integration
          • Step 1 - Create a User Account on MailChimp
          • Step 2 - Add Python and SQL Scripts to your Database
          • Step 3 - Set up your Mailing Audience Involvements in TouchPoint
          • Step 4 - Create a Mail Chimp Campaign and Send an Email
          • Unsubscribe
        • Your MailChimp Account
          • Python Script: MailChimpSync
          • SQL Script: MailChimpMembersOfInvolvement
          • SQL Script: MailChimpInvolvementsSql
        • TouchPoint Mailing Audience Involvements
          • Required MailChimp Extra Value
          • Optional Extra Values
      • Public Emails
        • Make Public Before Sending
        • Find the Link and Post It
        • Make Public and Post After Sending
        • Make a Public Email Private
      • Schedule Email
        • Who Can Schedule an Email
        • How to Schedule an Email
        • How to Cancel a Scheduled Email
        • Schedule Email for Current Involvement Members
      • Parent/Child Involvements - Emailing
        • Email Leaders and/or Members Under Parent Involvement
        • Using Search Builder to Email Parent/Child Involvement Members and/or Leaders
      • Tracking Emails
        • Track Opens
        • Track Links
    • Special Links
      • MyData Accounts
        • Benefits for MyData Users
        • Facts about MyData Accounts
        • How MyData Accounts Are Created
      • Create Vote Links in an Email
        • Create a Vote Link
      • Create Send Links in Emails
        • Send Links vs Register Links
          • 2 Types of Send Links
        • Create a Send Link
        • Create a Send Link2
      • Create RSVP and Regrets Links in Emails
        • Create an RSVP Link
        • Create Regrets Link
        • Track Responses
        • Special Code for Next Meeting Using a Saved Draft
      • Create Register Links in Emails
        • 2 Types of RegisterLinks
          • Compose a Register Link or Register Link2
      • Special Links for Online Registrations
        • Vote Link
        • Register Link
        • Register Link2
        • RSVP Link
        • Regrets Link
        • Send Link
        • Support Link
    • Drafts and Templates
      • Email Drafts
        • Create and Save a Draft
        • Edit a Saved Draft
        • Send a Saved Draft
        • Share Saved Drafts to specific users or to a Team
      • Email People - Tips and Suggestions
        • What Is a Target Audience?
        • Why Use a Target Audience?
        • Sending Targeted Emails Using the Blue Toolbar
        • Features and Tips for Sending Targeted (Mass) Emails
      • Email Templates
        • What Are Templates?
        • Copying Templates
        • Starter Templates
        • Email Templates and Roles
        • Identifying Templates
      • Using Email Templates
        • How do I send an email?
        • What will I see when I send an email?
      • Recreate Empty Template for your Database
    • Managing Emails
      • Email Management
        • Filters
        • Email List
        • More Email Management Tools
      • Sent Email Notice
        • How to Use this Notice
      • Email Details
        • Access Email Details
        • Contents of the Details Page
        • Creating a New Email from Details of Existing Email
        • Tracking Emails
      • Sent Emails
      • Received Emails
      • Email Optout
        • When will an Optout / Unsubscribe be overridden?
        • Add an Optout
        • Remove an Optout
      • User Email Delegation
        • To Delegate a User
        • To Edit or Remove Permissions
        • To Email on Behalf of a User
        • Tracking Emails Sent on Behalf of Another User
      • Failed Email Notices
        • The Bounce Email List
        • The Spam Report List
        • What You Should Do About Spam Reports
        • Mass Email Policy
    • Texting
      • Texting from TouchPoint - Overview
        • Benefits
        • How Quickly Are Messages Sent?
        • Getting Started
      • Establish an Account with Twilio
        • Twilio Account
        • Configure Your Twilio Account for Two-Way SMS
        • Receiving Calls and Texts
      • Establish an Account with Powered By Text (PBT)
        • Powered By Text Account
      • Texting with Powered By Text (PBT) and/or Twilio
      • Set Up TouchPoint for Texting
        • Completing Setup for Twilio
        • Completing Setup for PBT
        • Configuring Users and Groups
        • Facts re Groups, Numbers, and Users
      • Texting: Opt-In
      • How to Send Texts via TouchPoint
        • Send a Text
        • Multimeda Messages (MMS)
        • Including Special Links in Text Messages
        • URL Shortening
        • Tracking Texts
      • Managing SMS Messages
        • Sent Tab
        • Received Tab
        • Reply Words Tab
          • Opt In and Opt Out
          • Context Information Available for the Run Python Script Action
          • Duplicate Cell Phone Numbers
        • Blue Toolbar Functions
  • Extra Values
    • Basic Extra Values
      • Extra Values - People
        • Where Extra Values Display on a Person’s Record
        • Exports and Reports
        • Special Extra Values
        • Create a Standard Extra Value Field
        • Types of Extra Value Data
        • To Arrange Extra Values in a Specific Order
        • Delete Standard Extra Value Fields
        • Create an Ad Hoc Extra Value Field
          • Adding or Editing Extra Values as a Batch
      • Extra Values - Family
        • Mailing Address
        • Create a MailingAddress Standard Family Extra Value
        • Couple Name
        • Create a CoupleName Standard Family Extra Value
        • Family Name
        • Create a FamilyName Standard Family Extra Value
        • Adding the Same Family Extra Value to Multiple Families
        • Displaying Extra Values on Inreach / Outreach Report
      • Standard Extra Values (a technical explanation)
      • Adding or Updating Extra Values from Toolbar
        • Update Existing Extra Value
        • Create New Ad Hoc Extra Value
        • Deleting an Extra Value
        • To Delete an Extra Value Completely
    • Organization Extra Values
      • Allow Last Year Shirt Text
        • Create Extra Value for Optional Shirt
      • App Roll List - Committed Only
        • Add the Extra Value to an Involvement
      • Family Deposit Extra Value
        • Add the Family Deposit to an Org
      • You Must Agree Statement Extra Value for an Organization
        • Create the Extra Value
    • Special Use Extra Values
      • Confidential Comments as Extra Values
      • Tasks & Notes Keywords
        • Step by Step Instructions for Keywords
        • System Keywords
        • Deleting a Keyword, Extra Question and/or Option
      • Deposit Extra Value
      • Extra Value Comment Fields on Inreach / Outreach Reports
      • Extra Value - Parent
        • To add the Parent Extra Value to a child’s record:
        • Check-In and Parent Extra Value
      • Extra Value - PIN
        • Add a PIN
      • Using Envelope Numbers
        • Create an Adhoc Extra Value for EnvelopeNumber
        • To Edit an Adhoc Extra Value
        • To Delete/Remove an Individual Adhoc Extra Value
        • To Find Everyone with an EnvelopeNumber Extra Value
        • Use Envelope Number on Contribution Statement
  • Finance
    • General Process
      • Contributions Overview
        • Actions required to begin using TouchPoint for contributions:
      • Contribution Workflow
        • Online Contributions
        • Manually Entered Contributions
        • Scanned Checks
        • Imported Contributions
      • Contribution Batch
        • Batch Filters
        • Batch Data
        • How a Batch is Automatically Created
        • Create Batches Manually
        • Pending Batches
        • Multi-fund Transactions in Batches
        • Editing Batches
        • Reports
      • Batch Type and Contribution Type
        • Batch Types
      • Contribution Types
      • Finance Roles
        • Roles Needed for Contributions
          • Secondary Functions and Roles
      • Fund-Based Finance Roles
        • Process
        • What Is Available?
      • Scanning Checks to Import Data and Images
        • Requirements
        • Setting Up the Scanner
        • Scanning Checks
        • How to Handle Bank Drafts
      • Contributions Search
        • Contribution Search Options
          • Text Boxes
          • Dates
          • Drop-down Menus
          • Checkboxes
          • Filter Button, Export, and Update All
        • Contribution Summary Bar
      • Contribution Terms
      • Reconciling Batches
        • Batch Report
          • Weekly - Enter Contribution Summary Totals into the General Ledger
          • Monthly - Reconcile your Bank Statement
          • Quarterly or Yearly - Send Contribution Statements
      • Corrections/Reversals for Contributions/Registrations
        • If the Batch Is Closed
        • Facts about Reversals
        • If the Batch Is still Open
      • FAQs Regarding Contributions
        • Contribution Statements
        • Posting Contributions / Batches
        • Corrections & Returns
        • Reports / Summary Totals
      • Finance FAQs
        • Bundles/Batches
        • Account Codes
        • Pledges
      • Fund Management
        • Add a New Fund
        • Fund Sets
        • Other Functions on Fund Management
      • Returned Checks / ACH Rejects
        • Facts about Returned Checks / ACH Rejects
      • Scanning Checks / Importing Files
        • Importing Other Types of Files
        • Associating Donors
        • Assigning Fund and/or Splitting Check into Multiple Funds
        • New Clients and/or 1st-Time Check Scanners
        • Importing Files from PayPal, etc.
        • Importing Scanned Check Files to Create Batches
        • Assigning Donor and Fund
        • Subsequent Imports
        • Corrections
        • How to Handle Bank Drafts
      • Split Contribution
        • Splitting Contributions
    • Online Giving
      • Online Giving Overview
        • A Look at the New Features
        • Overview of Features
      • Online Giving Setup
        • Steps to Configure Giving Pages
        • Communicate Change
        • Saving Accounts for Online Giving
        • External Giving Links
      • Configuring Payment Gateways
        • Changing Payment Processors
      • Online Giving Batches
        • Managing / Closing Online Batches
      • Emails for Online Giving
        • Customizing the Templates
        • Video Tour
        • Viewing Contribution Confirmations
      • Recurring Giving Failure Notices
        • Action Required
        • Control Failure Notice Recipients
        • Edit Failed Recurring Giving Notice for Donor
        • Failed Gift Tasks
          • How it Works
      • Pushpay Integration
        • Setup for the Pushpay Integration
      • Txt2Give Integration - Allowing Giving by Text
        • Setup for the Txt2Give Integration
      • GivingFire Integration
        • Setting Up the GivingFire Integration
        • Managing Your Integration
        • Syncing Past GivingFire Transactions
      • OnlineGiving.org Integration
      • Vanco Import for Online Giving
        • Preliminary Steps
        • Importing the Vanco file
      • Online Processing: Donations and Payments
        • When can I expect my batch settlements to be deposited in my bank account?
        • Virtual Terminal
        • Failed Recurring Giving Transactions
        • Other Failed Online Transactions
        • General Ledger and Online Processing
      • Communicate Change - Sample Emails
        • Sample - Using Create Account
        • Sample - Using Request Password
    • Pledges
      • Non-Tax Deductible Gifts and Pledges
        • Gifts through a Foundation
        • Gifts of Stock
          • How a donor determines the value of their stock gift
      • Pledge Overview
        • Roles for Entering/Managing Pledges
        • Administrative Settings
      • Creating Pledge Funds
      • How Pledges are Entered
        • Online
        • One Time Pledge Manual Entry
        • Recurring Pledge Manual Entry
        • Pledge Summaries When Posting Contributions
      • Recurring Pledges
        • Enable Recurring Pledges
        • Manage Recurring Pledges
        • Email Templates for Recurring Pledges
      • Pledges & Contribution Statements
        • Administrative Settings
        • Pledges on Statements
        • Show or Hide Pledges on Contribution Statements
    • Pledge Reports
      • Pledge Reporting
        • Pledges Page
        • Export
        • Comparison Graph
        • Report
        • Search Builder
      • Pledge Totals by Fund Range Report
        • Generate the Pledge Totals by Fund Range Report
      • Pledge Fulfillment Report
        • Run the Pledge Fulfillment Report
    • Reports and Exports
      • Donor Totals by Range Report
        • To generate the Donor Totals by Range Report
      • Donor Total Summary Export
      • Export Donor Details
        • Alternative Donor Details Export
      • Export Donor Fund Totals
        • How to Generate the Report
      • Export Donor Totals
        • Generate the Export
      • Export Ledger Income
        • Run the Ledger Income Report
      • Manage Recurring Giving
        • Add Recurring Giving for a Donor
        • Edit Recurring Giving for a Donor
        • Delete Recurring Giving for a Donor
        • Contents of the Manage Recurring Giving Page
      • Giving Change
        • Create a Giving Change Report
        • Run this Report
      • Scan and Deposit
      • Settlements Report
      • Totals by Age Range Report
        • To generate the Totals by Age Range Report
          • Sample Report:
      • Totals by Fund Range Report
        • Generate the Totals by Fund Range Report
      • Totals by Fund Report
        • Generate the Fund Totals Report
        • Further Options
        • Exports
      • Transactions (New)
        • Required User Roles
        • Information Displayed By Default
        • Additional View Options
        • Filtering the Transactions
        • Bulk Update
        • Export
      • Transactions Log
        • Required User Roles
        • Totals Bar
        • Information Contained in the Transactions Log
        • Actions
        • Filters
        • Other Reports
        • Filter
        • Mission Trip Transactions
      • Contribution Change Log
        • Search
        • Log
      • First Time Giving Report
      • Increased Giving by Range Report
      • Decreased Giving By Range Report
      • Lapse Giving Report
    • Statements and Envelopes
      • Contribution Statement Types and Envelope Options
        • Edit Statement and Envelope Options
      • Contribution Statements
        • Options for Generating PDF Statements
        • Further Options
        • Contribution Options in the Templates
        • Extra Values Relating to Statements
        • Custom Statements for Ministries
        • Troubleshooting
      • Contribution Statement Header and Notice
        • To Modify the Statement Header
        • To Modify the Statement Notice
      • Statements for Deceased Donors
        • Generate Statements for the Deceased and Spouse
        • Generate a Joint Statement for Deceased and Spouse
        • Transfer Deceased Giving History
      • Contribution Statements - HTML Option
        • Custom Statements for Ministry Fund Sets
        • Including a Cover Letter
        • Settings Used with the HTML Option
        • Templating Language
        • Objects
          • DateTime
          • ContributorInfo
          • Contributions
          • Decimal
          • PledgeSummary
          • NonTaxSummary
          • TaxSummary
        • StatementOptions
        • HTML Template Files
          • StatementHeader
          • StatementNotice
          • StatementTemplate
          • StatementTemplateBody
          • StatementTemplateFooter
      • Custom Contribution Statements
        • Setup
        • Standard Statements
        • Renaming Standard Statements
        • Generating Statements
      • Donors’ Access to Contribution Statements
        • If you already have a My Data user account
        • If you are staff or have a Leader type of user account
        • If you do not have a user account on TouchPoint
        • All users
      • Electronic Only Statement Option
        • Electronic Statements
        • Identify and Notify Donors with Electronic Only Flagged
        • FAQ
      • Using Envelope Numbers
        • Create an Adhoc Extra Value for EnvelopeNumber
        • To Edit an Adhoc Extra Value
        • To Delete/Remove an Individual Adhoc Extra Value
        • To Find Everyone with an EnvelopeNumber Extra Value
        • Use Envelope Number on Contribution Statement
      • Mailed Envelope Sets
        • Envelopes - Joint and Individual
    • Other Articles
      • Giving Tab
        • To Stop Recurring Giving
      • Finance Documents
        • User Roles
        • Upload Finance Documents
        • Questions
      • Gifts-in-Kind
        • Record Gifts-in-Kind
        • Create a Stock or Gift-In-Kind Batch
      • Non-Tax-Deductible Contributions
        • Recording Non-Tax-Deductible Gifts
        • Non-Tax-Deductible Gifts and Pledges
        • Special Cases
  • For Documenters
    • Admonition
    • Anchor Link Reference Point
      • From Cicero
      • Far far away
    • Embedded Video
    • Force Line Breaks
    • Glossary
    • Highlight Words
    • Images
    • Links to other documents
    • Lists
    • Multi Column List
    • Note
    • Sections
      • And Sub Sections
        • And Bad Bad, Sub Sub Sections
    • Source Code
    • Tables
    • Workflow for BVCMS Documenters
  • Getting Started
    • Insert People
      • Sample Data Examples - Explanations
      • Existing Clients
    • First Steps with your TouchPoint Database
      • Settings
      • Other Tasks and Resources
      • Other Administrative Tasks
    • Next Steps
      • TouchPoint Overview
      • Preparing for Sunday
      • Recording Attendance for Sunday
      • Miscellaneous Tasks
    • Browser Guide
      • Session Time Out
    • Videos
      • Overviews and Training Videos
        • Overviews
        • Training
      • Category Videos
        • Contributions - Basics
        • Contributions - Online Giving
        • Membership Process
        • Online Registrations
        • Organizations and Promotion
        • People - Managing Duplicates
        • Search Builder
  • Miscellaneous
    • Videos
      • Videos
        • Overviews and Training Videos
          • Overviews
          • Training
        • Category Videos
          • Contributions - Basics
          • Contributions - Online Giving
          • Membership Process
          • Online Registrations
          • Organizations and Promotion
          • People - Managing Duplicates
          • Search Builder
    • Home Page
      • Home Page
        • Sections / Boxes
        • Main Menu Headers
          • People
          • Organizations
          • Reports
          • Administration
        • Other Options
          • Search
          • Active Tag
          • Profile
          • Help
          • More Help
      • Home Page Birthdays
        • Use the Birthdays Default
        • Use a TrackBirthdays Tag
        • Use a TrackBirthdays Search
        • Caution: TrackBirthdays Tag and TrackBirthdays Search vs the Default
      • Email Support
        • Search First
        • Contact Support
        • Why not just email TouchPoint Support directly?
        • Why not just call?
      • Help Documentation
        • Searching for Answers
          • Browser Tabs
          • Search Options
        • Documentation Homepage
          • Index
          • Categories
          • Recently Updated
          • Contact Support
      • Welcome Header
        • Profile
        • Change your password
        • Open Person in New Tab
        • Open Org in New Tab
        • Use OnlineRegFind for SearchAdd
        • Finance Role
        • Log Out
    • Basics
      • Basic Search Builder Searches
        • Short Instructional Videos about Search Builder
      • Campus
        • Create Campuses
        • Assign a Campus to an Organization
        • Assign a Campus to an Individual
        • Setting a Campus Automatically
        • Settings Relating to Campus
      • Check-In
        • Getting Started
          • Check-In Overview
            • Key Points to Consider
            • Setting Up Check-In
          • Hardware List for TouchPoint Check-In
            • Check-In Print Server
            • Check-In Clients
            • Label Printers
            • Labels
            • QR Scanners for Pre Check-In
            • Kiosks & Stands
          • Check-In Administrative Settings
          • Involvement Settings for Check-In
          • Check-In Profiles
            • General Tab
            • Testing Tab
            • Security Tab
            • Printing Tab
            • Labels Tab
            • Design Tab
            • Add Family Tab
            • Manage Recommended
          • Check-In Users
          • Check-In Labels
            • Label Formats
          • Custom Check-In Labels
            • Steps to create a custom label
            • Helpful formatting tips for specific elements
        • Using Check-In
          • Using Check-In
            • Running Check-In in Kiosk Mode
            • Member Check-In
            • Guest Check-In
            • Add a Record
            • Add a family
            • Log Out of Check-In
          • Check-Out
            • How To Set Up
            • Who Are Authorized Check-Out People
            • How To Authorize Check-Out People
            • Check-Out Settings
          • Pre Check-In
            • Accessing Pre Check-In
            • Using Pre Check-In
            • Additional Details
            • QR Code Scanner
          • Check-In Troubleshooting
            • I can’t get the label to print.
            • My security code/label text is getting cut off.
            • A child is checking in but not getting the security label or getting an adult tag.
            • Why can’t someone check in/no classes are available for Check-In.
        • Printers
          • Printer Settings for Check-In
          • GoDEX Printer Settings for Check-In (DT4, DT4x, DT4xW)
          • GoDEX Printer Configuration for Check-In (DT200)
            • Purchase Information
          • Brother Printer Settings for Check-In
          • Dymo Printer Settings for Check-In
          • Print Server for Check-In
            • Setting Up the TouchPoint Check-In Print Server
            • Running Print Servers
            • Modifying a Print Server’s Configuration
            • Removing a Print Server
            • Automatically Launching
        • Additional Features
          • Extra Value - PIN
            • Add a PIN
          • Check-In Dashboard
            • Set Up
            • Accessing the Check-In Dashboard
            • Using the Check-In Dashboard
            • Layout
          • Classroom Dashboard
            • Layout
          • Check-In Control Report
            • Run the Check-In Control Report
          • Key Fobs and Scanners
            • Pre Check-In
        • Building Checkin
          • Building Check-In
            • Building Check-In Process
            • Create the Saved Search
            • Setup Building Check-In Profile
            • Other Options
            • Using Building Check-In
            • How it Works for the Attendant
            • How It Works for the Person Checking In
          • Check-In Activity Log
      • Ministry Plan for 1st-Time Guests
        • Additional Helps
        • 2nd and 3rd Time Guests
      • Weekly Tasks
        • Membership
        • Attendance and Follow-Up
        • Contributions
        • Database
        • Volunteers
  • Mobile App
    • Mobile App
      • Free Mobile App
        • Download the App
        • Sign in to the App
        • People Search
        • Attendance
        • Tasks and Notes
          • Completing A Task
          • Creating A Task or Note
      • Mobile App Deeplinking
        • How to Use Your Own Domain for Deeplinking
        • Available Deeplinks
        • Deeplink Redirections
        • Sample HTML code for AppStorePromoPage
      • Mobile App Giving History Page
        • Giving Summary
        • Giving Detail
        • Access Giving Statement
        • Update Statement Preferences
        • Make a One-Time Contribution
        • Manage Recurring Giving
      • Mobile App Map Builder
        • Adding Maps to Your App
      • Discipleship Groups
        • Overview of D-Groups
        • Curriculum Basics
        • Managing People
        • Viewing Data In TouchPoint
      • Mobile App Push Notifications
        • Scheduling a Notification
        • Using Replacement Codes
        • Using Deeplinking Fields
      • Mobile Quick Sign in
        • System Configuration
        • Twilio Configuration
        • Ministry by Text (MBT) Configuration
        • Using Quick Sign in
      • Prayer Requests
        • Optional Settings for Prayer Requests
        • Embed into Your Website
        • Keywords
        • Submitting Prayer Requests via the Mobile App
          • Logged In
          • Not Logged In
        • Submitting Prayer Requests via the Stand Alone Form
        • Submitting Prayer Requests via form Embedded in your Website
        • Prayer Digest Email/Report
      • Online Registrations on Custom Mobile App
        • Registration Categories
        • Registration Locations
        • Managing App Registrations
          • Editable Settings on Mobile View Tab
      • Account Deletion
        • Task Details
        • Deleting the Account
  • Mobile App 3.0
    • Mobile App 3.0
      • Getting Started
        • Beta to Release Version Process
        • Finding/Downloading your Church’s App from the store
        • Logging In
      • Mobile App Setup
        • Mobile Admin Settings
        • Recommended Image Sizes
        • Media & Resources
        • Events
        • In App Giving Page
        • Giving Impact Cards
        • Mobile Tip Cards
        • Messages & Push Notifications
        • Directories
        • Channels
      • App Features
        • Feed (Home Screen) Items
        • Profile
        • Chat
        • Features
        • Menu
  • Online Registration
    • Registration Types
      • Registration Form
        • Creating a Registration Form
        • Publishing the Registration Form
        • Tracking Registrations
        • Reporting
      • Manage Subscription Registration
        • Creating Newsletter Subscription Involvements
        • Publicize Your Newsletters
        • How Manage Subscription Works
          • Notes about your Newsletters
      • Record Family Attendance
        • Guests not in Database
        • Subgroups
        • Auto Check Attendance
    • Mission Trip Online Registration
      • Mission Trip Registration Overview
        • Benefits for the Goers (Participants)
        • Link to Post on Website
        • Benefits for the Senders (Supporters)
        • Benefits for the Staff
      • Setting up a Mission Trip Involvement
        • Set Up the Involvement
        • Misc Info
      • Mission Trip Participants
        • Self-Support Payments
        • Manually Configuring a Support Link
      • Mission Trip Goer Funding Page
        • Elements of the Goer Funding Page
      • Cash/Check Donations, Revise Trip Cost, Email Support Link - Mission Trips
        • Record a Cash or Check Donation
        • Results
        • Send SupportLink for an Online Donation
        • Assign a Goer to Donation
        • Move Donations - Change a Goer to a Sender
      • Mission Trip Coupons
        • Coupon for the Initial Deposit/First Payment
        • Coupon for a Subsequent Payment Using a Paylink
        • Alternate Method for Allowing a $0 Deposit or a Discount
      • Mission Trip Reports
        • Mission Trip Funding Report
        • Mission Trip Funding Export
        • Mission Trip Sender Export
        • Mission Trip Tracking on the Transactions Log
      • Sample Confirmation for Mission Trips
        • Sample Confirmation
    • Special Links and URLs
      • Special Links for Online Registrations
        • Vote Link
        • Register Link
        • Register Link2
        • RSVP Link
        • Regrets Link
        • Send Link
        • Support Link
      • Create Vote Links in an Email
        • Create a Vote Link
      • Create Register Links in Emails
        • 2 Types of RegisterLinks
          • Compose a Register Link or Register Link2
    • Other Features
      • Discount Codes - Payments and Scholarships
        • Create a Single Use Discount Code
        • Create a Multi Use Discount Code
        • Deactivate a Multi Use Discount Code
        • Use a Discount Code
        • View the Discount Code List
        • FAQs
      • Change Registration Person
        • PayLinks
      • Registration Report and Export
        • To Generate the Report or Export
        • What Information Is Included
      • Submission Report
        • To Generate the Report
        • What Information Is Included
      • Shirt Sizes Report
        • Run the Shirt Sizes Report
        • Last Year
      • Standard Shells for Online Registrations or Giving Pages
        • Standard Shell
        • Standard Shell Light
        • Standard Shell with Background
        • Video Demonstration of Shell Customization
    • Samples & Help
      • Videos
        • Overviews and Training Videos
          • Overviews
          • Training
        • Category Videos
          • Contributions - Basics
          • Contributions - Online Giving
          • Membership Process
          • Online Registrations
          • Organizations and Promotion
          • People - Managing Duplicates
          • Search Builder
      • Vacation Bible School (VBS) Tips
        • Online Enlistment of Teachers / Workers / Volunteers
        • Online Registration for Children
        • Recording Attendance: Rollsheets or Check-In?
        • Schedules - Rollsheets - Meetings
        • Registration on Day One of VBS
        • Miscellaneous Tips
      • VBS Worker Enlistment Sample
        • Assigning Volunteers to a Class
    • Legacy Registration Articles
      • Online Registration - Basic Videos
      • Creating a Basic Registration
        • Post the link on your website
        • Email a Register Link
      • Creating a Basic Registration Continued
        • Add Questions
        • Add Image in Confirmation
      • User Selects and Compute Involvement by Birthdate Registrations
        • User Selects Involvement
        • Compute Involvement by Birthdate
        • Create a Master Involvement with Pick List
        • FAQs
      • Online Registration Basics and FAQ
        • Basics of TouchPoint Online Registration
        • Log in to Register
        • Register without Logging In
        • Create an Account
        • Frequently Asked Questions
      • Registration Types
        • Basic Registration
        • Master Involvement Style Registrations
        • Special Purpose
      • Special Registration URLs
        • Present Log In Page First
        • Do Not Display Family List at First
        • Using Multiple Special URLs
      • Online Registration Settings
        • Settings > General
        • Settings > Attendance
        • Settings > Extra Values
        • Registration > Registration
        • Registration > Fees
        • Registration > Questions
        • Registration > Messages
      • Registration Settings Tab
        • Basic Setup
        • Join Type
        • Age Groups
        • Advanced Setup
          • Relaxed Requirements
        • Campus Requirement
      • Default Shell for Online Registrations
        • How to Create a Shell
        • Image
        • Other Shells
        • Sample Shell for Bootstrap
      • General Settings Tab
        • Basic Setup
        • Mission Trip Settings
        • Advanced Setup
      • Attendance Settings Tab
        • Schedules / Meeting Series
        • First Meeting Date
        • Last Meeting Date
        • Rollsheet Guest Weeks
        • Send an attendance link to leaders at the start of each meeting
        • Filter Attendance Roster By Subgroup
        • Does NOT Meet Weekly
        • Consecutive Absents Threshold
        • Off-Site Trip
        • Allow Attendance Overlap
      • Fee Settings Tab
        • Basic Setup
          • Checkboxes
        • Involvement Fees
        • Donation Setup
        • Service Fees & Discount Codes
      • Questions Settings Tab
        • Question Options
        • Freeform Questions
          • Checkboxes
          • Dropdown
          • Radio Buttons
          • Menu Choices
          • Yes/No Questions
          • Single Line Answers
          • Multiline Answers
          • Upload Documents
          • Tickets
          • Add More Tickets
        • Design Elements
          • Divider
          • Header
          • Instruction Highlighted
          • Instruction Plain
        • Standardized Questions
          • Allergies
          • Cell Phone
          • Church
          • Coaching
          • Special Request
          • Doctor
          • Emergency Contact
          • Grade Options
          • Insurance
          • Parents
          • Shirt Size
          • Suggested Fee
          • Approved Medications
          • Passport
          • Pledge
        • Target Extra Values
      • Enlist Attendees for Future Meetings
        • Create Registration
        • Changing Someone’s Selection
        • Attendance
      • Online Registration Checkboxes
        • How to Create Checkboxes for an Online Registration
        • Group Checkboxes with Special Headers
      • Messages Settings Tab
        • Editing Messages
        • Confirmation Email
        • Terms
        • Instructions
        • Reminder
        • Confirmation Tracking Code
      • Messages Settings - Reminder Email
        • Create a Reminder Email
        • Send the Reminder
        • FAQs:
      • No Phone or DOB on Find Page
        • Omit One or Both Questions
      • Extra Donation Option for Online Registrations
      • Recreation Teams
        • Use the Recreation Team Feature
  • Involvements
    • Involvement Basics
      • Involvement - Defined and Dissected
        • Involvement Details
        • People Tabs
        • Options
        • Hide Records or Show Hidden Records
        • Other Involvement Tabs
        • Blue Toolbar
        • Drop Down Menu
        • Filters
      • Add-Create New Involvements
        • To Add a New Involvement
      • Involvements > Search / Manage Page
        • Main View
        • Mobile View 2.0
        • Management View
          • Blue Toolbar on Involvements > Search / Manage
      • Advanced OrgSearch Using Name Field
        • Extra Values Search
        • Parent/Child or MasterOrg PickList Search
        • Registration Settings Search
    • Managing Involvements
      • Active and Inactive Involvements
        • Changing the Status
      • Delete an Involvement
        • Who Can Delete
        • How to Delete
      • Filter and Sort Options
        • Name Filter
        • Sub-Group Filter
        • Filter Button
        • Options Button
        • Sort
      • Main Fellowship Involvements
        • Set Main Fellowship Flag for an Involvement
          • Search Builder and Main Fellowship
          • Attendance and Main Fellowship
          • Multiple Main Fellowship Enrollments
      • Involvement Types
        • Using Involvement Types
        • Create Involvement Types
        • Assign Involvement Type to One Involvement
        • Assign Involvement Type for Multiple Involvements
      • Parent Child Involvements
        • Facts about Parent Child Involvements
          • Make the Parent Child Association
          • Removing Parent Child Associations
        • Report
      • Security Role for a Private Involvement
    • People in Involvements
      • Inactive Members of Involvements
        • Add an Inactive Date for an Existing Member
        • Make Multiple Members Inactive
        • Make Multiple Inactive Members Active Again
        • Inactive Members and Check-In
      • In-Service Members
      • Leader Types
        • Set the Leader Type
        • Lay Leader Access
      • Involvement Member Types
        • Leader Types and Attendance Types
      • Pending Members
        • Add Pending Members
        • Move Pending Members to Members Tab
      • Prospects, Guests, and Members
        • Guests vs Prospects
        • Who Manages Prospects?
          • Add a Prospect to an Organization
          • Change from Prospect to Member
            • Change Several Prospects
        • FAQs re Prospects
    • Managing People in Involvements
      • Add a New Involvement Member
        • A Guest who has visited the class before
        • A Prospect who has not visited the class before
        • A person who is neither a Prospect nor a Guest
        • Adding members from a Tag
      • Add Transaction or Make Adjustment
        • Use Case 1 - Set Initial Fee
        • Use Case 2
        • Use Case 3a - Adjustment for One Person
        • Use Case 3b - Adjustment for Multiple Members
        • Use Case 4 - Online Registration with Fee Zero, now Needs Fee
      • Already a Member
        • Schedules
        • Member Types
      • Drop Involvement Members
        • Drop Individual Members
        • Drop Multiple or All Members - Batch Process
        • Drop Using a Tag
        • Drop All Members for Multiple Involvements
        • Drop Members Based on Zero or Low Attendance
      • Manage Involvement Members
        • Use Cases for Manage Involvement Members
        • Filters / Features
          • Using Manage Involvement Members
        • Email Assignment Notices
        • Misc Info
      • Moving Involvement Members
        • Moving Individual Members
        • Moving Multiple Members
      • Involvement Member Dialog
        • Member Tab
        • Groups Tab
        • Questions Tab
        • Privacy Tab
        • Action Buttons
      • Removing Previous Enrollments
      • Sub-Group Management
        • Manage Sub-Groups Tab
          • Create New Sub-Group
          • Batch Update to Create Sub-Groups
          • Rename a Group
          • Delete a Group
          • Delete Multiple Groups
        • Sub-Group Members Tab
          • Adding Group Members
          • Removing Group Members
        • Filtering
          • Filtering for Those Who ARE in a Specific Group
          • Filtering for Those NOT in a Specific Group
          • Filtering for Those Who ARE in One Type of Group But NOT in Another Type of Group
          • Filtering by Tag or by Member Type
          • Use the Request Field
      • Update Members
        • Update Functions
        • Enrollment Date
        • Member Type
        • Inactive Date
        • Pending Members
        • Add Transaction
        • Sub-Groups
    • Involvement Settings Tabs
      • General Settings Tab
        • Basic Setup
        • Mission Trip Settings
        • Advanced Setup
      • Attendance Settings Tab
        • Schedules / Meeting Series
        • First Meeting Date
        • Last Meeting Date
        • Rollsheet Guest Weeks
        • Send an attendance link to leaders at the start of each meeting
        • Filter Attendance Roster By Subgroup
        • Does NOT Meet Weekly
        • Consecutive Absents Threshold
        • Off-Site Trip
        • Allow Attendance Overlap
      • Check In Settings Tab
        • Number of Checkin Labels
        • Number of Worker Checkin Labels
        • Start Birthday and End Birthday
        • Early Checkin
        • Late Checkin
        • Allow Check-In
        • Suspend Checkin
        • Allow Non Campus Check In
        • No security label required
      • Privacy Settings
        • Involvement Directory Settings
        • Global Privacy Settings
        • Involvement-Specific Personal Privacy Settings
        • Example Scenarios
        • Who may update these privacy settings?
        • Hide Blue Toolbar Directories
      • Registration Settings Tab
        • Basic Setup
        • Join Type
        • Age Groups
        • Advanced Setup
          • Relaxed Requirements
        • Campus Requirement
      • Fee Settings Tab
        • Basic Setup
          • Checkboxes
        • Involvement Fees
        • Donation Setup
        • Service Fees & Discount Codes
      • Questions Settings Tab
        • Question Options
        • Freeform Questions
          • Checkboxes
          • Dropdown
          • Radio Buttons
          • Menu Choices
          • Yes/No Questions
          • Single Line Answers
          • Multiline Answers
          • Upload Documents
          • Tickets
          • Add More Tickets
        • Design Elements
          • Divider
          • Header
          • Instruction Highlighted
          • Instruction Plain
        • Standardized Questions
          • Allergies
          • Cell Phone
          • Church
          • Coaching
          • Special Request
          • Doctor
          • Emergency Contact
          • Grade Options
          • Insurance
          • Parents
          • Shirt Size
          • Suggested Fee
          • Approved Medications
          • Passport
          • Pledge
        • Target Extra Values
      • Messages Settings Tab
        • Editing Messages
        • Confirmation Email
        • Terms
        • Instructions
        • Reminder
        • Confirmation Tracking Code
      • Reset New Visitor Days
        • Purpose of this Setting
        • Create the Setting
        • More about the Attend Type for Guests
    • Attendance
      • Printing Roll Sheets
        • Using Word instead of PDF
        • Using Alternative Names in Chinese
        • Roll Sheets for an Entire Division and Schedule
        • Roll Sheets for a Single Organization
        • Roll Sheets by Sub-Groups
        • Roll Sheets with a Specific Sub-Group Name Displayed
        • Roll Sheets for Rallies with the Parents
        • FAQs re Roll Sheets:
      • Recording Attendance
        • Scanning
        • FAQs re Scanning:
        • Making Corrections
          • Hardware for Scanning Roll Sheets
      • iPhone / Android Attendance with App
        • Prerequisites
        • Record attendance
        • Add a Guest
          • Other Options
        • Sub-Group Attendance
          • How it Works
          • Set up Filter Attendance by Sub-Group
      • Mobile App Attendance by Lay Leaders and Staff
        • Getting Started
        • Open the Mobile App
        • Take Attendance
        • Add a New Guest
        • Images
      • iPad Attendance Using your Browser
        • Three ways to record attendance using an iPad
          • iPad Attendance Using a Browser
          • Status Flag for iPad Attendance Highlight
      • Email Attendance Notices
        • Send Email Attendance Notices
          • Results
          • Change the Consecutive Absents Threshold
          • Change Subject of Email Attendance Notices
          • Preview Attendance Notices
      • Recording Headcount Attendance
        • Record a Headcount
        • Record a Headcount and Individual Attendance
      • Repair Transactions
        • What does the Repair Transactions option do?
      • Send Leaders Attendance Reminder
        • Configuring for Attendance Reminders
        • How the Reminders Are Sent
        • Attendance Reminder Email
        • Did Not Meet Feature
        • Troubleshooting
      • Record by Family Attendance
        • Checkbox Options
        • Recording Attendance by Name
        • Using Barcodes with Ticketing Attendance
          • Barcode Email Replacement Code
        • Recording Attendance with Scanner
        • Screenshots
      • Attendance by Groups Report
        • View Attendance by Groups
        • Filter Report by Sub-Group Prefix
      • Add Attendees from a Tag
      • Manual Attendance
        • Record Attendance Manually
        • Headcounts / Group Attendance
      • Add a New Guest
        • Add Guests while Entering Attendance
        • Add Guests after Recording all Attendance
    • Attendance Tracking
      • Attendance History
      • Attendance String
        • To view the Attendance String
          • Attendance Transaction History
        • To View the Attendance Transaction History
      • Attendance Types
        • Attend Types Based on the Person’s Member Type
        • Attend Types Based on Other factors
      • Off-Site Attendance
        • Setup for the Off-Site Org
          • How Does an Off-Site Attendance Display
    • Meetings, Schedules, and Meeting Series
      • Meetings in TouchPoint
      • Create a Meeting (legacy)
        • How to Create a Meeting for One Involvement
        • How to Create Meetings for Multiple Involvements
        • To Change the Date of a Meeting
        • Facts about Meetings
      • Meeting Page
        • What do all these headings mean?
      • Involvement Schedules
        • Adding a Schedule
        • Adding Multiple Schedules
        • Removing a Schedule
        • Searching by Schedule
        • Check-In & Schedules
        • Recording Attendance for Involvements without Schedules
      • Involvements with Multiple Schedules
        • Example 1
        • Example 2
        • Example 3
    • Printing Roll Sheets
      • Printing Roll Sheets
        • Using Word instead of PDF
        • Using Alternative Names in Chinese
        • Roll Sheets for an Entire Division and Schedule
        • Roll Sheets for a Single Organization
        • Roll Sheets by Sub-Groups
        • Roll Sheets with a Specific Sub-Group Name Displayed
        • Roll Sheets for Rallies with the Parents
        • FAQs re Roll Sheets:
      • Firefox - Printing Roll Sheets
        • If you are using Windows
        • If you are using a Mac
      • Rally Roll Sheets - Parents
        • What does it look like?
        • How does it work?
        • Printing a Rally Rollsheet for a Group of Organizations
        • Printing a Rally Rollsheet for one Organization
        • Recording Attendance using Rally Roll Sheets
      • Roll Sheets with Small Group Name
        • Printing Roll Sheets with a Small Group Name Displayed
    • Programs and Divisions
      • Programs, Divisions, and Involvements
        • Programs
        • Divisions
        • Create a New Program
        • Create a New Division
          • Changing Programs for a Division
        • Assign Involvements to a Division
        • Main Division
          • Set the Main Division for an Involvement
      • Hierarchy - Programs, Divisions, Involvements
        • Hierarchy
        • Example
          • FELLOWSHIP (Prog)
          • WORSHIP (Prog)
          • OTHER GROUPS (Prog)
      • Prog/Div/Involvement Hierarchy Report
        • Generate the Hierarchy Report
      • Create, Rename or Delete a Division
        • How to create a new Division
        • How to Rename a Division
        • How to Delete a Division
      • Assigning Divisions
        • Single Involvement
        • Multiple Involvements
        • Involvement Types
    • Promotion
      • Promotion Using Manage Involvement Members
        • Options
          • Manage Involvement Members for Promotion
          • Teachers
          • After You Move Students
      • Annual Promotion
        • When to use Manage Involvement Members for Promotion
        • When to use Annual Promotion
        • Steps in Using Annual Promotion
        • Moving Students to a Different Pending Class
          • Moving One Member at a Time
          • Moving Several Members
          • Dropping Pending Enrollment
      • Promotion Setup
        • Video Demonstration
        • Create Promotion Structure
      • Promotion Prep
        • Empty the 12th Grade Involvements
        • Video Demonstration
        • Clean Up Membership in Involvements
          • Video Demonstration
        • Current Involvements
        • More Involvements Needed
      • Promotion Management
        • Accessing Manage Promotion
        • Assign Pending Members
        • Sort Methods for Assigning as Pending
        • Promotion Totals Sticky Note
        • New Teachers
          • Add Pending Teachers Manually
          • Move New Pending Teachers
        • Behind the Scenes
      • Promotion Management Using Date of Birth
        • Video Demonstration
        • Pending Classes
      • Promotion Management - Mixed
        • Video Demonstration
        • Promotion Totals Sticky Note
        • Pending Classes
      • Promotion Management Using Same Class
        • Video Demonstration
        • Pending Classes
      • Promotion—Notify Parents
        • Before Promotion is Finalized
        • After Promotion Finalized
        • Mail
        • Staff Sending Email for all Students
        • Teachers Emailing Students in their Involvement
      • Promotion—Finalize
        • Prerequisites
        • Promotion - Finalize
          • Promotion Involvements - Adjust Settings
          • Excel Export and Batch Update
    • Reports
      • Attendance Percentages Report
        • Run the Attendance Percentages Report
      • Attendee Report
        • Run the Attendee Report
      • First, Second, or Third Time Attender Reports
      • Check-In Dashboard
        • Set Up
        • Accessing the Check-In Dashboard
        • Using the Check-In Dashboard
        • Layout
      • Meetings for Month Report
        • Generate the report
      • Inreach / Outreach Report
        • Header
        • Family Summary
        • Attendance Summary
        • Contacts
        • Current Enrollment
        • Sample Report
          • Extra Values on Report
        • Report with Form
      • Meetings / Attendance (date range)
        • Run the Report
      • Meetings Report
        • Option 1 - Involvements > Search
        • Option 2 - Week at a Glance
          • Summary
          • Meetings Grid
      • Recent Absents Report
        • Consecutive Absents
        • Sample Report
        • Multiple Organizations
        • In-Service, Homebound or Inactive Members
        • Organizations with Multiple Schedules
      • Recent Absents Report 2
        • Requirements
        • Run the Report
          • Another Worship Attendance Report
      • Recent Attendance Report
        • Generate Report
      • Guests/Absentees Report
        • Generate Report
      • Guests/Absentees Contact Report
        • Run the Report
      • Class List
        • Run the Class List
      • Enrollment Control Report
        • PDF, Export to Excel, For Tagged List, iPhone/iPad Version
          • Generate the Report
          • iPhone/iPad Version - How it Works
        • Use Cases for Normal Enrollment Control Report
        • Use Case for Excel and Active Tag Options
        • Use Case for iPhone/iPad Version
      • Leaders Report
        • Run the Leaders Report
      • Roster Report
      • Visitor Attend Percent for Orgs
        • Create to SQL Report
        • Run the report
    • Exports
      • Groups Export
        • Generate the Groups Export
      • Meeting Day Stats
        • Data
        • Purpose
      • Member Export
        • Generate the Member Export
      • Export Members
        • Generate the Export
      • Membership Info Export
        • Generate the Export
    • Small Group Finder
      • Small Group Finder Overview
        • Create a Small Group Finder
          • Display the Small Group Finder on your Website
          • Multiple Small Group Finders
      • Small Group Finder Step 1 - Create the Involvements
        • Create the Involvements
          • Create Extra Values
        • Put the Involvements in the Same Division
        • Map
        • Tracking Attendance for Small Groups
          • Continue Setting up the Small Group Finder
      • Small Group Finder Step 2 - Create the Layout
        • Create the Layout
        • Available Involvement Field Codes
        • Continue Setting up the Small Group Finder
      • Small Group Finder Step 3 - Create the Shell
        • Create the Shell
        • Continue Setting up the Small Group Finder
      • Small Group Finder Step 4 - Create the XML File
        • Create the Small Group Finder XML file
          • Check Out your Small Group Finder
      • Small Group Finder - Embedding a Map
        • Steps to Open a Google Cloud Account
        • Steps to Create API Keys
        • Add API Keys to Administration Settings
        • Test Geocoding
        • Configure the Map in Small Group Finder
        • Explanation of Map Pin Locations
        • Optional Settings
    • Volunteer Management / Calendar
      • Volunteer Management Calendar
        • Scenario
        • Calendar
          • Other Options
          • Miscellaneous Notes:
        • Alternate Simple Calendar View
        • Alternative Option for Special Cases
      • Enlist Volunteers
        • Method One
        • Method Two
          • Member Type - VIP or Volunteer
      • Managing the Volunteer Calendar
        • Place Individual Volunteers in Time Slots
        • Place Groups of Volunteers in Time Slots
        • Remove a Volunteer’s Commitments
        • Request More Volunteers
        • Volunteer’s Commitment page
          • Leader Managing Commitments for Volunteer
      • Manage Volunteer Calendar - Simple View
        • Add Volunteers to the Calendar
        • Other Functions
          • Stacked Lines aka the Hamburger Icon
          • Volunteer’s Name
          • Header
          • Other Indicators
      • Volunteer Commitment Conflicts
        • Find Conflicts While Viewing the Organization
        • Find Conflicts While Viewing the Volunteer Calendar
        • Find Conflicts on a Volunteer’s People Record
          • Resolve Conflicts
      • Volunteer - Get Sub
        • Get a Substitute
        • Customize Volunteer Emails
      • Volunteer Management: Using Sub-Groups
        • Requesting Sub or Additional Volunteers
          • Managing Volunteer Calendar
        • Create Sub-Groups
        • Assign Members to Sub-Groups
    • All Other Topics
      • Involvement Directory Settings
      • Convert to Search from a Meeting
      • Custom Involvement Tabs
        • Configure Custom Involvement Tabs
        • Configuration Files
      • eSPACE Integration
        • Step 1 - Create a User Account with eSPACE
        • Step 2 - Generate an API key in eSPACE
        • Step 2 - Enable the Integration on TouchPoint
        • Step 3 - Link TouchPoint Involvements to eSPACE Events
      • Org Members Only Page
        • Access Members Only Page
          • Staff Users
          • My Data Users
          • OrgLeadersOnly - Leaders in Org
          • OrgLeadersOnly - Not Leader in that Org
        • Edit Members Only Page
      • 24 Hour Prayer Grid
        • Creating a Second Prayer Grid
          • Part One - Copy the Code
          • Part Two - Past the Code
      • TouchPoint Newsletters
      • Vacation Bible School Follow-up
        • Visitation Blitz
          • Suggestions for Search Conditions
        • Email ‘Thank You’
        • Assign Tasks
  • People
    • People Records
      • People Page
        • Business Card Section
        • Toolbar
        • Family Members
        • Tabs
      • Alt Name
        • Show Alt Name on Search Results
        • Other Places to Use Alt Name
        • Search Using Alt Name Contains
      • Upload and Remove Photos
        • Picture Upload Notifications
        • Existing Photo
        • Removing Photos
        • Family Photos
        • Editing Photos - Rotating or Cropping
          • Rotate a Photo
          • Crop a Photo
        • Tips for Capturing Good Photos
      • Address Verification
        • Edit an Existing Address
        • Adding a New Record in a New Family
          • Address Types
        • Addresses that Cannot Be Validated
      • Entry Point, Origin and Interest Point
      • Do Not Publish Phones
        • To Set the Flag
      • People ID Numbers
      • Ministry Records
        • Requirements
        • Benefits of Using Ministry Records for Emailing
        • Tips Regarding Ministry Records
      • Grade Field
      • Engagement Score
        • Engagement Badge
    • Managing People
      • New Person Data Entry Tasks
        • Completing Data Entry Tasks
      • New People Manager
        • To Set the New People Manager
        • What happens when a new people record is created:
        • Special Setting
      • Finding Duplicates
        • Batch Process for Finding Duplicates
        • Checking For Duplicates on the Person Page
        • More Details About the Batch Find Duplicate Process
      • Merging Duplicates
        • The Merge Controller has 2 parts.
        • Part 1 Process
        • Merge Process Part 2
        • Roles
        • Batch Process
        • Merge History Tab
      • Archived People Records
        • How To Archive A Person
        • How to Remove an Archived Flag
        • Viewing an Archived Person
      • Deleting a Record
        • User Role for Delete Privileges
        • How to Delete a Record
    • Managing Families
      • Add a New Family Member
      • Position in Family
        • To Change the Position
          • Head of Household Calculation
      • Family Relationships
        • Add Family Relationship
        • Remove a Family Relationship
        • Examples
      • Move Person to New Family
    • Membership
      • Church Membership Process
        • Steps in a Nutshell
        • Videos
        • User Roles re Membership
        • Member Status and Decision Types
        • Record a Decision
          • Decision Type Triggers
        • Completing the Membership Process
        • Baptism - Scheduled, Completed
        • New Member Class
        • Business Rule Options
          • Turn Off Rules
          • Deceased Rules
          • New Member Class(es) Required or Not Required
      • Membership Documents
        • User Roles
        • Upload Membership Documents
        • Questions
      • Membership - Misc Notes
      • Dropping Church Members
        • Drop a Church Member
        • Changes that occur automatically
        • Drop types
      • Deceased Members and Non-Members
        • Flag a Person as Deceased
        • Automatic Changes
    • Search
      • People Search / Find
      • Search Box
        • How Does Search Work?
        • More about Alt Name
    • Volunteer Management
      • Volunteer Management / Review
        • User Roles
        • Administrative Settings
        • How to Upload a PDF File
        • FAQ About Volunteer Application Documents
      • Background Checks and Trainings with MinistrySafe
        • Setting Up Your MinistrySafe Account
        • TouchPoint Settings
        • Required User Roles
        • MinistrySafe Labels
      • Request a Background Check and/or Training Class Using MinistrySafe
        • Background Check
        • Training Classes
        • Notifications
        • Mass Background Check Requests
      • Background Checks with Protect My Ministry
        • Required Settings
        • Optional Settings
        • Required User Roles
        • Labels in Protect My Ministry
      • Request a Background or Credit Check using Protect My Ministry
        • Option 1 - Email for Consent
        • Option 2 - Submit with PII
          • Notifications
          • Credit Check
          • Mass Background Check Requests
    • Miscellaneous
      • Status Flags
        • Purpose
        • How Status Flags Work
        • Where To Find Status Flags
        • Starter Set
        • How To Create Status Flags
        • Status Flag For Emergency Contacts
        • Status Flag Settings
      • Tags
        • Create a Tag from the Tags Page
        • Create / Manage a Tag from the Toolbar
        • Add People to a Tag
        • Sharing Tags
      • Media & Resources
        • Enabling & Configuring Resources
        • Media & Resources Page Breakdown
        • Create Tabs
        • Create a Group
        • Add a Resource
        • Manage Tabs
        • Manage Groups
        • Organizing Resources
        • Viewing Resources
        • Making Resources Available on the 2.0 App
  • Process Builder
    • Process Builder
      • Process Builder Overview
        • Process Builder Setup
      • Using Process Builder
        • Steps to Create a Process
        • Publish Your Process
      • Process Builder Actions
      • Process Builder Workflow
        • Monitor and Manage the Process
        • Completion of Process
  • Rooms & Reservations
    • Rooms & Reservations
      • Rooms & Reservations - Overview
        • Frequently Asked Questions (FAQs)
        • Implementation
      • Rooms & Reservations Settings
      • Rooms & Reservations - Creating Meetings
        • Create Meeting or Meeting Series
        • 1. Involvement Meeting tab
        • 2. Involvement Attendance tab
        • 3. Calendar Page
        • Edit Meeting or Meeting Series
        • Delete Meeting or Meeting Series
      • Rooms & Reservations - Meeting View
        • Meetings Tab
        • Individual Meeting Page
        • Meeting information
        • Attendance Summary
        • Attendance Details
      • Rooms & Reservations - Calendar
        • Month View
        • Week View
        • Day View
        • Location View
      • Rooms & Reservations - Calendar Feeds
        • Create Calendar Feed
      • Rooms & Reservations - Reservables
        • Locations
          • Locations Page
          • Create Location
          • Delete Location
        • Setups
          • Setups Page
          • Create Setup
        • Assets
          • Assets Page
          • Create Asset
        • Services
          • Services Page
          • Create Service
        • Deleting Assigned Reservables
        • Importing Reservables
      • Rooms & Reservations - Notifications
        • Reservation Requested
        • Reservation Approved
        • Reservation Denied
        • Reservation Updated
        • Reservation Cancelled
      • Rooms & Reservations - Conflicts
        • Approvals with conflicts
  • Scheduler
    • Scheduler
      • Scheduler Overview
        • Administrative Settings
        • Scheduler Setup
      • Scheduler: General Settings
        • General
        • Registration
        • Check-In & Attendance
        • For New Users
      • Scheduler: Registration Settings
        • Time Slots or Only Use Ad Hoc
        • Communication
        • Instructions
      • Scheduler View
        • Getting People Involved
      • Managing the Scheduler
        • Search Options
        • Additional Features
      • Scheduler Email Templates
  • Search Add
    • Add Person in Context
    • Search and then Add People
      • Where is the Add button?
      • Notes on Searching
    • New Database - Adding People
    • Search for a Family
      • Results
    • Add New Person to New Family
    • Add New Business
      • Tabs on the Profiles of Business Records
      • Convert a Person Record to a Business Record
      • Search for a Business Record
  • Search Builder
    • Basics
      • How to Use Search Builder
        • Code Link
        • Create a New Search
        • Groups
        • Convert to Search
        • Conditions:
        • Videos of Sample Searches
      • Convert to Search
      • Saved Searches
        • Open and Run a Saved Search
        • Other Options on Saved Searches
          • Filter
          • Sort
          • Actions
        • Auto Remove Archive Flag Saved Search
      • Open Person in New Tab
      • Using Groups in Search Builder
      • Search Builder Facts and Tips
        • Videos
        • Facts
        • Tips
    • Personal
      • Age
      • Archived Flag
      • Gender
      • Birthdate
      • Birthday
      • Days until Birthday
      • Days Until Anniversary
      • Marital Status
      • Wedding Date
      • Grade - Legacy
      • Grade
      • First Name
      • Last Name
      • Nick Name
      • Middle Name
      • Maiden Name
      • Alt Name
      • School
      • Employer
      • Occupation
      • Has Picture
      • Has Multiple User Accounts
      • Deceased Date
      • Widowed Date
      • Email Address - Primary
      • Email Address - Secondary
      • Title
      • People Record Type
      • Engagement Score
    • Family
      • Position in Family
      • Number of Family Members
      • Number of Primary Adults
      • Has Parents
      • Family Has Children
      • Family Has Children Age X and Under
      • Family Has Children Aged Range
      • Family Has M/F Children Aged Range
      • Is Head of Household
      • Has Related Family
      • Family Has Primary Adult Church Member
      • Family Member Has Status Flag
      • Family ID
      • Related Family Members
      • Has Family Picture
    • Address
      • Resident Code
      • Zip
      • City
      • State
      • Address Line 1
      • Address Line 2
      • Country
      • Bad Address Flag
      • Has Zip Plus 4
      • Geographic Region
    • Contact Info
      • Home Phone
      • Cell Phone
      • Work Phone
      • Do Not Call
      • Do Not Visit
      • Do Not Mail
      • Do Not Publish Phones
      • Has Invalid Email Address
      • Email Address - Primary
      • Email Address - Secondary
      • Head or Spouse with Email
      • Spouse Has Email
      • Spouse or Head with Email
      • Send Email Address 1
      • Send Email Address 2
      • Receive SMS (Texts)
    • Ministry
      • Family Has Notes
      • Task About With Details
      • Task About With Keywords
      • Has Incomplete Task
      • Days Since Last Note
      • Recent Note With Keywords
      • Recent Contact Type
      • Recent Contact Reason
      • Email Recipient
      • Recent Email Count
      • Recent Email Sent Count
      • Made Note With Keywords As Of
      • Has Notes
      • Contact Recipients
      • Contact Makers
    • Membership
      • Church Member Status
      • Campus ID
      • Decision Date
      • Decision Type
      • Recent Decision Type
      • Recent Join Church
      • Join Date
        • No Join Date
      • Join Date Months Ago
      • Join Type
      • Drop Date
      • Drop Type
      • Baptism Date
      • Baptism Type
      • Baptism Scheduled Date
      • Baptism Status
      • New Member Class Date
      • New Member Class Status
      • Previous (Former) Church
      • New Church
      • Letter Requested Date
      • Letter Status
    • Enrollments
      • In Main Fellowship Class
      • Is Member Of
      • Is Inactive Member Of
      • Is Pending Member Of
      • Member Type Codes
      • Involvement Member with Campus
      • Member of Org with Schedule
      • Recent Registration Type
      • In Sub-Group
      • Number of Enrollments
      • Has Balance in Organization
      • Involvement Search Member
      • Is Prospect Of
      • Attend Type Codes
      • Recent Incomplete Registrations
      • Is Member of Directory
    • Enrollment History
      • Was Org Member As Of
      • Member Type As Of
      • Org Join Date
      • Recent Org Join Date (Days Ago)
      • Org Inactive Date
      • Org Join Date Compare
      • Was Recent Member Of
      • Is Previous Member Of
      • First Org Join Date
      • Org Member Joined As Of
      • Org Member Created Date
    • Current Org
      • Has Balance in Current Organization
      • In Current Organization
      • Inactive in Current Organization
      • Pending in Current Organization
      • Previous Member in Current Organization
      • Prospect in Current Organization
      • Has Visited Current Organization
      • Leaders Under Current Org
      • Members Under Current Org
    • Volunteer
      • Has Volunteer Applications
      • Volunteer Approval Code
      • Volunteer Application Status Code
      • Volunteer Processed Months Ago
      • Background Check Status Code
      • MVR Processed Date Months Ago
      • MVR Status Code
      • Check Date Range
      • Days Since Last Training
      • Training Date Range
      • Training Months Ago
      • Months Since Last Background Check
      • Training Status Code
    • Recent Attendance
      • Recent Attend Member Type
      • Visit Date Nth Time
      • Recent Visit Number
      • Recent Visit Number Orgs
      • Recent Attend Type
      • Attendance Percent
      • Recent Attend Count
      • Recent Attendance Count by Attendance Credit
      • Kids Recent Attendance Count
      • Need Attendance
      • Has Recent New Attend
      • Recent First Family Visit
      • Recent Family Adult Last Attended
    • Attendance Dates
      • Attended As Of
      • Member Type Attended as Of
      • Attendance Type as Of
      • Attendance Percent History
      • Attendance Count History
      • Days Between 1st and 2nd Attendance
      • Days After Nth Visit with Date Range
      • Guest As Of
      • Building Check-In by Date
      • Building Check-In by Activity
      • Meeting ID
      • Registered for Meeting ID
      • Commitment for Meeting Id
      • Has Commitment for Meeting Id
      • First Family Visit As Of
      • Get Eldest Family Member that Attended
    • Contributions
      • Envelope Options
      • Contribution Options
      • Recent Contribution Count
        • Sample search for those with no contributions:
      • Recent Contribution Amount
        • Select or enter the following information:
      • Recent Contribution Amount Both Joint
      • Contribution Amount (with Both Joint) by Date Range
      • Recent Giver
      • Recent Giver to Funds
      • Recent Has Failed Recurring Giving
      • Recent Managed Giving
      • Recent Non-Tax Deductible Count
      • Recent Non-Tax-Deductible Amount
      • Non-Tax-Deductible Amount Both Joint
      • Non-Tax-Deductible Amount Donor Only
      • Recent Pledge Count
        • Sample search for those with no pledges
      • Recent Pledge Amount
        • Sample search for those with no pledges
      • Recent Pledge Amount with Both Joint
      • Pledge Amount History with Both Joint
      • Pledge Balance
      • Contribution Amount History
      • Contribution Amount History Donor Only
      • Contribution Change Percent
      • Giving Change
        • Create a Giving Change Report
        • Run this Report
      • Recent Individual Contributions
      • Recent First Time Giver
      • First Time Giver
      • Is Top Giver
      • Is Top Pledger
      • Is in Giving Family
      • Is in a Giving Family toward FundSet
      • Is in a Pledging Family
      • Has Managed Giving
      • Managed Giving with Credit Card
      • Credit Card Expiration
      • Wants Electronic Statement
      • Recent Contribution in Bundle Type
      • Had Individual Contributions
      • Soft Credit Recipient Number Of Days
      • Soft Credit Recipient Date Range
    • Extra Values
      • Extra Value Code
      • Extra Value Text
      • People Extra Value Date
      • People Extra Value Integer
      • People Extra Value Field
      • Family Extra Value Code
      • Family Extra Value - Text
      • Family Extra Value - Date
      • Family Extra Value - Integer
      • Has Family Extra Value - Field
      • Recent People Extra Field Changed
      • Days Since Extra Value Date was Set
    • Miscellaneous
      • Include Archived
      • Include Deceased
      • Parents Only
      • Status Flag
      • Recent Flag Added
      • Has Current Tag
      • Has My Tag
      • Has Membership Documents
      • Has Finance Documents
      • Entry Point
      • Origin
      • In SQL List
      • Interest Point
      • Member Any Church
      • Registration - Not Church Member
      • Add Primary Adults
      • Add Spouse
      • Saved Search
      • Registration - Active in Other Church
      • Registration, Interested in Coaching
      • In One of My Involvements
      • Number of Check-In Visits
      • Medical Length
      • Has Failed Emails
      • First Person Same Email
      • Days Since Date Field
      • Engagement Score
    • Admin
      • User in Role
      • Is System User
      • Record Created By User
      • Created Date
      • Recently Created
      • Recent Changed Record
      • Recent Login Days Ago
      • Recent Mobile App Use
      • Is Current Person
      • Is Current User
      • Duplicate Emails
      • Duplicate Names
      • Has Lowercase Name
      • People IDs
      • Has Optouts for Email
      • People ID
      • Has Opened Email
        • Suggestions
      • Has Spam Block
      • Match Anything
      • Match Nothing
  • Summary Reports
    • Church-wide Summary Reports
      • Week at a Glance and Average Week at a Glance
        • Drill Down to Meetings Report
        • Sample Report
        • Average Week at a Glance
      • Configure the Week At A Glance Report
        • Sections (boxes) in the Week at a Glance
        • Rows (lines) within each Section
      • Worship Att Report
        • Requirements
        • Sample
      • Recent Absents Report 2
        • Requirements
        • Run the Report
          • Another Worship Attendance Report
      • Vital Stats
      • Vital Stats Graphs
        • Monthly Giving Analysis
        • Monthly Attendance Analysis
    • Church-Wide Directory
      • Online Picture Directory
        • Quick Start for the Directory
        • Who can view a directory?
        • Search, Sort, View, and Active Links
      • Example And Details
        • Church-wide Directory
        • Exclusions from Directory
        • Steps to Create a Main Directory for a Status Flag
      • Default Picture Directory Template
      • Default SQL for Picture Directory
    • Attendance
      • Attendance by Groups Report
        • View Attendance by Groups
        • Filter Report by Sub-Group Prefix
      • Attendance Percentages Report
        • Run the Attendance Percentages Report
      • Attendee Report
        • Run the Attendee Report
      • First, Second, or Third Time Attender Reports
      • Guests/Absentees Report
        • Generate Report
      • Guests/Absentees Contact Report
        • Run the Report
      • Meetings / Attendance (date range)
        • Run the Report
      • Meetings for Month Report
        • Generate the report
      • Meetings Report
        • Option 1 - Involvements > Search
        • Option 2 - Week at a Glance
          • Summary
          • Meetings Grid
      • Recent Absents Report
        • Consecutive Absents
        • Sample Report
        • Multiple Organizations
        • In-Service, Homebound or Inactive Members
        • Organizations with Multiple Schedules
    • Membership
      • Decision Summary Report
      • Membership Info Export
        • Generate the Export
    • Finance - Contributions
      • Contribution Statements
        • Options for Generating PDF Statements
        • Further Options
        • Contribution Options in the Templates
        • Extra Values Relating to Statements
        • Custom Statements for Ministries
        • Troubleshooting
      • Donor Totals by Range Report
        • To generate the Donor Totals by Range Report
      • Donor Total Summary Export
      • Export Donor Fund Totals
        • How to Generate the Report
      • Export Donor Totals
        • Generate the Export
      • Pledge Fulfillment Report
        • Run the Pledge Fulfillment Report
      • Pledge Totals by Fund Range Report
        • Generate the Pledge Totals by Fund Range Report
      • Totals by Age Range Report
        • To generate the Totals by Age Range Report
          • Sample Report:
      • Totals by Fund Report
        • Generate the Fund Totals Report
        • Further Options
        • Exports
      • Totals by Fund Range Report
        • Generate the Totals by Fund Range Report
    • Other
      • Toolbar Options
        • Email and Texting (envelope icon)
        • Exports and Reports (cloud icon)
          • Export Excel
            • Involvement Members Exports
          • Other Exports
          • Reports
          • Involvement Members Reports
          • Directories
          • Address Labels
          • Other Labels
          • Choose Format Dialog
          • Involvement Attendance
        • Custom Reports (code icon)
          • Custom Reports
          • SQL and Python Reports
        • Actions (gear icon)
          • Administrative
          • Tags
          • Contacts and Tasks
            • Extra Values
            • Meeting Operations
            • Meeting - Convert to Search
            • Checks/Trainings
            • Users
      • Convert to Search
      • Standard Extra Value Fields
    • Custom
      • Custom Reports
        • Create a Custom Report
        • Sample Report
        • Run an Existing Custom Report
        • Edit an Existing Custom Report
        • Spreadsheet of Basic Column Headers / Fields
      • Programming TouchPoint Using Python and SQL
        • Programming TouchPoint Using Python and SQL
          • SQL Recipes
            • Background Checks
              • Sample Report
              • SQL Code for Background Checks
            • Blended Families Report
              • Create the Blended Families Script
              • Code
            • Compact Family Report
            • Extra Value Details Report
              • Create the Extra Value Details Script
            • Giving Change
              • Sample Report
            • Giving Change Fund
              • Sample Report
            • Giving Snapshot by Quarters
              • SQL Code for the Report
            • Has Multiple Main Fellowships
              • SQL Code for the Report
            • Master Pager List
              • Create a Master Pager List Script
              • Code
            • User People Tagged
            • User Roles
              • Sample User Roles Report
              • SQL Code for User Roles Report
            • Zip Count Report
              • Create the Report
                • Run this Report
              • Sample Report
            • Absents Report
              • Sample Report
              • Create to SQL Report
              • SQL Code
            • Attendance Change Detail for Orgs
            • Attendance Change for Orgs
            • Average Attendance For Organizations
            • Average Monthly Attendance For Organizations
            • Bad Enrollment Transactions
            • Count Meetings By Org
            • Directory Enabled
              • Sample Report
              • Create the SQL Report
              • SQL Code
            • Member Type in Org
            • Org Attend Counts
            • Org Givers
            • Org Giving Totals
            • Org Percent Giving
            • Org Search Member Stats
            • User People Tagged For Orgs
            • Visitor Attend Percent for Orgs
              • Create to SQL Report
              • Run the report
            • Age Range Giving Units
            • Average Attendance Compare
              • Create Script for Average Attendance Comparison
              • Code
            • Average Monthly Attendance for an Org
              • Create the Script
              • Code
            • Average Annual Attandance By Org
            • Bad Extra Values
            • Couples With Different Contribution Options
            • Deceased This Month
              • Create Deceased This Month Report
              • Code
            • Family Email
            • Family With Duplicate Addresses
            • First Gifts in Past 365 Days
              • Sample Report
                • Create the First Gifts 365 Report
            • Givers Over Amount Report
              • Sample Report
            • Giving Units (Date Range)
            • Giving Units 365
            • Kids To Move
            • Last Attend Last Gift 365
              • Create the Report
              • Sample Report
            • Meeting Attend Dates Different
            • New Member Giving
              • Create New Member Giving Script
              • Code
            • Offsite Trip Organizations
            • Organization Giving
              • Status Flag
              • Create OrgGiving SQL Report
              • Code
            • Orgs Limit to Role
              • Create Orgs Limit to Script
              • Code
            • Parent Child Involvements Report
            • Picture Directory
            • Previous Sub Groups
              • Sample Excel Report
              • Sample Browser Report
              • Code
            • Recent Visitors to Division
              • Run this Report
                • Create the Report
                • Sample Report
            • Recurring Gifts
            • Register Email not Equal to Personal Email
            • Registration Sub Groups
            • Registration Without Account Codes
              • Report Details
              • Cleanup Process
              • Create the Report
            • Top 200 Donors with Email
            • Top Giving Families
            • Total Gifts >= 5000
            • Class List
              • Create the Class List Report
            • Class List 2
              • Create Class List 2 SQL Report
            • Contribution Basics Report
              • Add the Contribution Basics Report to your Database
              • Run the Contribution Basics Report
            • Custom Contributions Search Export
              • Add the Export
              • Code
            • Custom Transaction Report
              • Create a Custom Transaction Report
              • Run the Custom Transaction Report
            • Custom Transaction Report Using Batch Dates
              • Create a Custom Transaction Report
              • Run the Custom Transaction Report
            • Details with Fees
              • Create the Details with Fees Report
              • Run the Details with Fees Report
              • Code for the Report
            • Giving Change Quarters
              • To Run the Report
              • Sample Report
              • Create the Giving Change Quarters Report
              • Giving Change Quarters Code
            • Gloo Church Analytics Export
              • Create a Custom Transaction Report
              • Run the Custom Transaction Report
            • Monthly Giving Analysis
              • Sample Report
              • Create the Monthly Giving Analysis Report
              • Run the Monthly Giving Analysis
            • Totals by Fund Payment Type
              • Create Script for TotalsByFundPaymentType
              • Code
            • Totals by Fund with Fees
              • Create the Totals by Fund with Fees Report
              • Run the Totals by Fund with Fees Report
              • Code for the Report
            • Yearly Giving Analysis
              • Sample Report
              • Create the Yearly Giving Analysis Report
              • Run the Yearly Giving Analysis
          • Python
            • Python Recipes
              • Batch Report
                • Create the Batch Report
                • Generate the Batch Report
                • Python Code
              • Batch Report 2
                • Create the Batch Report
                • Generate the Batch Report
                • Python Code
                • SQL Code
              • Batch Report 3
                • Create the Batch Report
                • Generate the Batch Report
                • Python Code
                • SQL Code
              • Batch Report by Campus
                • Create the Batch Report
                • Generate the Batch Report
                • Python Code
                • SQL Code
              • Batch Report with Fee Rows
                • Create the Batch Report
                • Generate the Batch Report
                • Python Code
                • SQL Code
              • Batch Report by Type
                • Create the Batch Report
                • Generate the Batch Report
                • Python Code
                • SQL Code
              • Faith Path Stage of Life Campaign
                • Search Criteria
                • Sample Email with a Video Embedded
                • Code for Python Script
              • Five Year Giving Report
                • Sample Report
                  • Create Five Year Giving Report
                  • Five Year Giving Code
              • Giving Dashboard
                • Giving Types Report
                • Giving Households Report
                • Giving Forecast Report
              • LoginMetrics for Churches with Campuses
                • Create the LoginMetrics Script
              • LoginMetrics for Churches without Campuses
                • Create the LoginMetrics Script
              • Member Status Chart
                • Create Member Status Chart
              • Morning Worship Chart
                • Create Morning Worship Script
              • Move Kids
              • Multi-Batch Report
                • Create the Multi-Batch Report
                • Generate the Multi-Batch Report
                • Python Code
                • SQL Code
              • Multi-Batch Report 2
                • Create the Multi-Batch Report
                • Generate the Multi-Batch Report
                • Python Code
                • SQL Code
              • Multi-Batch Report 3
                • Create the Multi-Batch Report
                • Generate the Multi-Batch Report
                • Python Code
                • SQL Code
              • Multi-Batch Report by Campus
                • Create the Multi-Batch Report
                • Generate the Multi-Batch Report
                • Python Code
                • SQL Code
              • Multi-Batch Report with Fee Rows
                • Create the Multi-Batch Report
                • Generate the Multi-Batch Report
                • Python Code
                • SQL Code
              • Multi-Batch Report by Type
                • Create the Multi-Batch Report
                • Generate the Multi-Batch Report
                • Python Code
                • SQL Code
              • New Guest Email Campaign
              • New Guest History Report
              • Financial Peace University Packet Pickup Project
                • Overview
              • Prayer Digest
                • SQL Script
                  • Add the SQL Script
                  • Customize the SQL Script
                • Python Script
                  • Add the Python Script
                  • Customize the Python Script
                • Manually Run the Report
                • Automate the email
              • Python Charts
              • Recent Inactive Today
                • Installation
                • Explanation of the code
              • RecurringGivingForecast
                • Create the RecurringGivingForecast Script
              • Settlement Report
                • Configure the Settlement Report
                • Run the Settlement Report
                • Code for the Settlement Report Python Script
              • Shape Data Integration
                • To Install
                  • UpdateShapeData Python Script
                  • PeopleWithShapeData SQL Script
              • Three Year Giving
                • Create Three Year Giving Report
                • Three Year Giving Code
              • Vital Stats Report
                • Explanation of Contribution numbers computed
              • MailChimp Integration
                • TouchPoint Setup for MailChimp Integration
                  • Step 1 - Create a User Account on MailChimp
                  • Step 2 - Add Python and SQL Scripts to your Database
                  • Step 3 - Set up your Mailing Audience Involvements in TouchPoint
                  • Step 4 - Create a Mail Chimp Campaign and Send an Email
                  • Unsubscribe
                • Your MailChimp Account
                  • Python Script: MailChimpSync
                  • SQL Script: MailChimpMembersOfInvolvement
                  • SQL Script: MailChimpInvolvementsSql
                • TouchPoint Mailing Audience Involvements
                  • Required MailChimp Extra Value
                  • Optional Extra Values
            • Python Model
              • Contributions
                • model.AddContribution()
                • model.AddContribution()
                • model.AddContributionDetail()
                • model.CloseBundle()
                • model.CreateContributionTag()
                • model.CreateContributionTagFromSql()
                • model.DeleteContribution()
                • model.DeleteContributionTags()
                • model.FetchOrCreateFund()
                • model.FindBundleHeader()
                • model.FindBundleHeader()
                • model.FindContribution()
                • model.FindOrCreateBundleHeader()
                • model.FinishBundle()
                • model.FirstFundId()
                • model.GetBundleHeader()
                • model.MoveFundIdToExistingFundId()
                • model.MoveFundIdToNewFundId()
                • model.QueryContributionIds()
                • model.ResolveFund()
                • model.ResolveFundId()
              • Dates
                • model.AddDays()
                • model.DateTime
                • model.DayOfWeek
                • model.DateAddDays()
                • model.DateAddHours()
                • model.DateDiffDays()
                • model.FormatDate()
                • model.MostRecentAttendedSunday()
                • model.ParseDate()
                • model.ParseDateUTC()
                • model.ResetToday()
                • model.ScheduledTime
                • model.SetToday()
                • model.SundayForDate()
                • model.SundayForWeek()
                • model.WeekNumber()
                • model.WeekOfMonth()
              • Deprecated Functions
                • Email
                  • model.Email2()
                  • model.EmailContent()
                  • model.EmailContent2()
                  • model.EmailContent2()
                  • model.EmailStr()
                • Organization
                  • model.OrgMembersQuery()
                • ManagedGiving
                  • model.DisableRecurringGiving()
                • Misc
                  • model.FromJson()
                • Tasks
                  • model.CreateTask()
                  • model.CreateTask()
              • Docusign
                • model.docusign.ApiClient()
                • model.docusign.Configuration()
                • model.docusign.Document()
                • model.docusign.EnvelopeDefinition()
                • model.docusign.EnvelopesApi()
                • model.docusign.EnvelopesApi()
                • model.docusign.ListStatusChangesOptions()
                • model.docusign.Recipients()
                • model.docusign.RecipientViewRequest()
                • model.docusign.SignHere()
                • model.docusign.Signer()
                • model.docusign.Tabs()
                • model.docusign.TemplateRole()
                • model.docusign.TemplateTabs()
                • model.docusign.Text()
              • DynamicData
                • model.DynamicData()
                • model.DynamicData()
                • model.GetValue()
                • model.Remove()
                • model.AddValue()
                • model.SetValue()
                • model.ToString()
                • model.ToFlatString()
                • model.Keys()
                • model.SpecialKeys()
              • Email
                • model.TestEmail
                • model.Transactional
                • model.ContentForDate()
                • model.Email()
                • model.EmailContent()
                • model.EmailContentWithSubject()
                • model.EmailReminders()
                • model.EmailReport()
                • model.EmailReport()
                • model.EmailStr()
              • ExtraValues
                • model.AddExtraValueAttributes()
                • model.AddExtraValueBool()
                • model.AddExtraValueCode()
                • model.AddExtraValueDate()
                • model.AddExtraValueInt()
                • model.AddExtraValueText()
                • model.DeleteAllExtraValueLike()
                • model.DeleteExtraValue()
                • model.ExtraValue()
                • model.ExtraValueAttributes()
                • model.ExtraValueBit()
                • model.ExtraValueCode()
                • model.ExtraValueDate()
                • model.ExtraValueInt()
                • model.ExtraValueText()
              • ExtraValuesOrg
                • model.AddExtraValueBoolOrg()
                • model.AddExtraValueCodeOrg()
                • model.AddExtraValueDateOrg()
                • model.AddExtraValueIntOrg()
                • model.AddExtraValueTextOrg()
                • model.ExtraValueBitOrg()
                • model.ExtraValueCodeOrg()
                • model.ExtraValueDateOrg()
                • model.ExtraValueDateOrgNull()
                • model.ExtraValueIntOrg()
                • model.ExtraValueOrg()
                • model.ExtraValueTextOrg()
              • Forms
                • model.BuildDisplay()
                • model.BuildDisplayRows()
                • model.BuildForm()
                • model.BuildFormRows()
                • model.Form
                • model.Header
                • model.HttpMethod
                • model.Script
              • Handlebars Templates
                • model.RenderTemplate()
                • HandleBars Helpers
              • JsonDocumentRecords
                • model.AddUpdateJsonRecord()
                • model.AddUpdateJsonRecord()
                • model.DeleteJsonRecord()
                • model.DeleteJsonRecordSection()
                • model.SqlListDynamicData()
                • model.SqlTop1DynamicData()
                • model.SqlList()
              • ManagedGiving
                • model.DisableRecurringGiving()
              • Meetings
                • model.AddExtraValueMeeting()
                • model.DeleteExtraValueMeeting()
                • model.EditCommitment()
                • model.EditPersonAttendance()
                • model.ExtraValueMeeting()
                • model.GetMeeting()
                • model.GetMeetingIdByDateTime()
                • model.GetMeetingIdByDateTime()
                • model.GetMeetingIdsByDateTime()
                • model.GetMeetingsByDateTime()
                • model.GetMeetingsByDateTime()
                • model.GetMeetingsByDateTimeRange()
                • model.GetMeetingsByDateTimeRange()
                • model.GetNextScheduledMeetingDate()
                • model.MeetingDidNotMeet()
                • model.MeetingIsAllDay()
                • model.MeetingShowAsBusy()
                • model.UpdateMeetingDate()
                • model.UpdateMeetingDuration()
                • model.UpdateMeetingEnd()
              • Misc
                • model.AppendIfBoth()
                • model.BirthdayList()
                • model.CallScript()
                • model.Content()
                • model.CreateCustomView()
                • model.CreateQueryTag()
                • model.CsvReader()
                • model.CsvReader()
                • model.CsvReaderNoHeader()
                • model.CustomStatementsFundIdList()
                • model.CmsHost
                • model.Data
                • model.DataHas()
                • model.DebugPrint()
                • model.DeleteFile()
                • model.DeleteQueryTags()
                • model.Dictionary()
                • model.DictionaryAdd()
                • model.DynamicData()
                • model.DynamicDataFromJson()
                • model.DynamicDataFromJsonArray()
                • model.Draft()
                • model.DraftTitle()
                • model.ElementList()
                • model.ExecuteSql()
                • model.FmtPhone()
                • model.FmtZip()
                • model.FormatJson()
                • model.FormatJson()
                • model.FromMorningBatch
                • model.GetCacheVariable()
                • model.HtmlContent()
                • model.JsonDeserialize()
                • model.JsonDeserialize2()
                • model.JsonSerialize()
                • Markdown()
                • model.Md5Hash()
                • model.PythonContent()
                • model.ReadFile()
                • model.RegexMatch()
                • model.Replace()
                • model.ReplaceCodeStr()
                • model.ReplaceQueryFromCode()
                • model.RestDelete()
                • model.RestGet()
                • model.RestPost()
                • model.RestPostJson()
                • model.RestPostXml()
                • model.SetCacheVariable()
                • model.Setting()
                • model.SetSetting()
                • model.SpaceCamelCase()
                • model.StatusFlagDictionary()
                • model.StatusFlagList()
                • model.SqlContent()
                • model.TextContent()
                • model.TagLastQuery()
                • model.TitleContent()
                • model.Trim()
                • model.UrlEncode()
                • model.UserName
                • model.UserPeopleId
                • model.UpdateStatusFlag()
                • model.UpdateStatusFlags()
                • model.UserIsInRole()
                • model.WriteContentHtml()
                • model.WriteContentPython()
                • model.WriteContentSql()
                • model.WriteContentText()
                • model.WriteFile()
              • Organizations
                • model.AddMembersToOrg()
                • model.AddMemberToOrg()
                • model.AddOrganization()
                • model.AddOrganization()
                • model.AddSubGroup()
                • model.AddSubGroupFromQuery()
                • model.AddTransaction()
                • model.AddTransaction()
                • model.AdjustFee()
                • model.CurrentOrgId
                • model.DeleteOrg()
                • model.DropOrgMember()
                • model.GetOrganization()
                • model.GetPayLink()
                • model.InOrg()
                • model.InSubGroup()
                • model.JoinOrg()
                • model.MoveToOrg()
                • model.OnlineRegPerson()
                • model.OnlineRegPerson()
                • model.OrganizationIds()
                • model.RemoveSubGroup()
                • model.SendAttendanceReminders()
                • model.SetMemberType()
                • model.UpdateMainFellowship()
              • Person
                • model.AddBackgroundCheck()
                • model.AddPerson()
                • model.AddRole()
                • model.AddTag()
                • model.AgeInMonths()
                • model.ArchiveRecords()
                • model.ClearTag()
                • model.DeletePeople()
                • model.FindAddPeopleId()
                • model.FindAddPerson()
                • model.FindPersonId()
                • model.FindPersonId()
                • model.FindPersonIdExtraValue()
                • model.FindPersonIdExtraValueInt()
                • model.GetAuthenticatedUrl()
                • model.GetAuthenticatedUrl()
                • model.GetPerson()
                • model.GetPerson()
                • model.GetSpouse()
                • model.PeopleIds()
                • model.RemoveRole()
                • model.UnArchiveRecords()
                • model.UpdateAllSpouseId()
                • model.UpdateCampus()
                • model.UpdateContributionOption()
                • model.UpdateElectronicStatement()
                • model.UpdateEnvelopeOption()
                • model.UpdateField()
                • model.UpdateMemberStatus()
                • model.UpdateNamedField()
                • model.UpdateNewMemberClassDate()
                • model.UpdateNewMemberClassDateIfNullForLastAttended()
                • model.UpdateNewMemberClassStatus()
                • model.UpdatePerson()
                • Statement/Envelope Options
              • The Query Parameter
              • Sms
                • model.SendSms()
                • model.CreateTinyUrl()
              • SqlGrid
                • model.SqlGrid()
              • Tasks & Notes
                • model.CreateTaskNote()
                • model.GetExtraQuestions()
                • model.GetExtraQuestionsByKeywords()
                • model.GetExtraQuestionsWithAnswers()
                • model.GetTaskNote()
                • model.GetTaskNoteKeywordIds()
                • model.GetTasksNotes()
                • model.SetTaskNoteKeywordIds()
                • model.SetTaskNoteStatus()
                • model.TaskNoteAccept()
                • model.TaskNoteComplete()
                • model.TaskNoteDecline()
                • model.TaskNoteEdit()
                • model.TaskNoteMassAddKeywords()
                • model.TaskNoteMassArchive()
                • model.TaskNoteMassAssign()
                • model.TaskNoteMassComplete()
                • model.TaskNoteMassDelete()
                • model.TaskNoteMassUnarchive()
              • Upload
                • model.UploadExcelFromSqlToDropBox()
                • model.UploadExcelFromSqlToDropBox()
                • model.UploadExcelFromSqlToFtp()
            • Query Functions
              • Attendance
                • Properties
                  • q.LastSunday
                • Functions
                  • q.AttendanceTypeCountDateRange()
                  • q.AttendCountAsOf()
                  • q.AttendMemberTypeCountAsOf()
                  • q.LastWeekAttendance()
                  • q.MeetingCount()
                  • q.MeetingCountDateHours()
                  • q.NumPresent()
                  • q.NumPresentDateRange()
                • Number of Attendances vs Number of People
              • Contributions
                • q.ContributionTotals()
                • q.ContributionCount()
                • q.DateRangeForContributionTotals()
                • Funds Parameter
              • People
                • q.BlueToolbarCount()
                • q.BlueToolbarReport()
                • q.GetWhereClause()
                • q.QueryCount()
                • q.QueryList()
                • q.QueryPeopleIds()
                • q.QuerySql()
                • q.QuerySqlInts()
                • q.QuerySqlInt()
                • q.QuerySqlJsonArray()
                • q.QuerySqlPeopleIds()
                • q.QuerySqlScalar()
                • q.QuerySqlStr()
                • q.QuerySqlTop1()
                • q.SqlNameCountArray()
                • q.StatusCount()
                • q.TagCount()
                • q.TagQueryList()
                • q.TagSqlPeopleIds()
                • q.SqlFirstColumnRowKey()
                • q.SqlNameValues()
                • q.SqlPeopleIdsToQuery()
              • Sort Parameter
            • Other References
              • LookupTable Object
              • Fields on Organization Object
              • Person Object
          • APIs
            • OData API
              • People
              • Contributions
              • Pledges
              • Funds
              • Lookups
              • Organizations
              • Custom
            • GetOneTimeLoginLink and GetOnetimeRegisterLink APIs
              • Prerequisites
              • Usage
              • GetOneTimeLoginLink API
              • GetOneTimeRegisterLink API
            • Push Post API
              • AddContribution()
              • ReverseContribution()
            • http://www.tpsdb.com/Public/BVCMSCheckinAPI.htm
            • Personal Access Tokens
              • Creating a Personal Access Token
              • Deleting/Invalidating a Personal Access Token
              • Impersonating Another User with Personal Access Tokens
            • TouchPoint Authentication in External Applications
              • Validating Users
              • Linking to External Systems
                • Giving Pages
                • Mobile v3.x Banners
                • External Systems
          • Homepage Widgets
            • Management
              • Homepage Widgets
                • Managing Widgets
                • Video: Managing Widgets
                • Video: Changing Widget Colors
              • Multiple Dashboards
                • Editing the Code
                • New Dashboard Code
            • Individual Widgets
              • Attendance Year over Year Widget
                • Video
                • HTML Code
                • SQL Script
                • Python Script
              • Birthdays Widget
                • HTML Code
                • Python Script
              • Church News Widget
                • HTML Code
                • Python Script
              • Contact Trend Widget
                • Video
                • HTML Code
                • SQL Script
                • Python Script
              • Division Comparison Widget
                • Video
                • HTML Code
                • SQL Script
                • Python Script
              • Giving Change Widget
                • Video
                • HTML Code
                • SQL Script
                • Python Script
              • Giving Sources Widget
                • Customizing the Giving Sources Widget
                • Video
                • HTML Code
                • SQL Script
                • Python Script
              • Giving to Budget Comparison Widget
                • Video
                • HTML Code
                • SQL Script
                • Python Script
              • Giving Type Breakdown Widget
                • Video
                • HTML Code
                • SQL Script
                • Python Script
              • Login Metrics Widget
                • HTML Code
                • Python Script
              • My Involvement Widget
                • HTML Code
                • SQL Script
                • Python Script
              • My Searches Widget
                • HTML Code
                • SQL Script
                • Python Script
              • My Tags Widget
                • HTML Code
                • SQL Script
                • Python Script
              • My Tasks Widget
                • HTML Code
                • SQL Script
                • Python Script
              • Quick Links Widget
                • Video
                • HTML Code
              • Recent Attendance Trends Widget
                • HTML Code
                • SQL Script
                • Python Script
              • Recurring Giving Widget
                • Video
                • HTML Code
                • SQL Script
                • Python Script
              • TouchPoint News Widget
                • HTML Code
                • Python Script
              • Vital Stats Widget
                • Video
                • HTML Code
                • Python Script
              • Welcome to TouchPoint Widget
                • HTML Code
        • Custom Recipes
        • Writing Your Own Scripts
  • Ticketing
    • Ticketing
      • Ticketing in TouchPoint
      • Ticketing Setup
        • Setting Up Ticketing
        • Optional Settings
        • Customizations and Reports
      • Ticketing Event Manager
        • Social Distancing Rule Sets
        • Summary
        • For Sale
        • Seat Statuses
        • Assisted Booking
      • Ticket Sales Report
        • Sample Report
      • My Tickets Page
      • My Tickets Customization
        • How to Customize the Ticket
        • Colors:
        • Click on Ticket text
        • General Admission ticket:
      • Ticketing Venues
  • Job Description- Developer
    • Job Brief
      • Responsibilities
      • Requirements
  • Add Members Using a Tag
  • Dymo Printer Settings for Check-In
  • GoDEX Printer Settings for Check-In (DT4, DT4x, DT4xW)
  • Zebra Printer Settings for Check-In (ZD410)
  • RecentInactiveToday.py
  • NewGuestHistory.py
  • RecentInactiveToday.py
  • VitalStats.py
  • FPU Packet Pickup Confirmation
  • FPU Packet Pickup Main Script
  • FPU Packet Pickup Form
  • FPU Packet Pickup Javascript
  • FPU Packet Pickup Process
    • Explanation of code
  • GivingForecastData Python Script
    • Automate this Script
    • Explanation of the Code
  • GivingForecast Html
    • Explanation of the code
  • GivingForecast Python Script
    • Install on the Menu
    • Code Review
  • GivingForecast SQL Script
    • Explanation of the Code
  • Giving Forecast Report
    • Required Files for the Giving Forecast Report
  • GivingForecastData Python Script
  • Giving Forecast HTML
  • GivingForecast Python Script
  • GivingForecast Sql Script
  • Giving Forecast Style HTML
  • GivingHouseholdsData Python Script
    • Automate this Script
    • Explanation of the Code
  • GivingHouseholds Html
    • Explanation of the code
  • GivingHouseholds Python Script
    • Install on the Menu
    • Explanation of the Code
  • GivingHouseholds SQL Script
    • Explanation of the Code
  • Required Files for Giving Households
  • GivingHouseholdsData Python Script
  • GivingHouseholdsHtml Text
  • GivingHouseholds Python Script
  • GivingHouseholds Sql Script
  • GivingTypesData Python Script
    • Automate this Script
    • Explanation of the Code
    • Initialize
    • CreateDateRangeTags
    • NextPriority
    • CreateTag
    • CreateTags
    • Build the Three Columns for the Report
    • Wrapping it All Up
  • GivingTypesData SQL Script
    • Explanation of the Code
  • GivingTypes Html Shell
  • GivingTypes Html Table Template
  • GivingTypes Python Script
    • Explanation of the Code
    • Initialize
    • Utility Functions
    • BuildRow
    • BuildTotalRow
    • BuildTableRows
    • BuildTables
    • Print the report
  • GivingTypesValidate SQL Script
    • Explanation of the code
  • Required Files for Giving Types
  • GivingTypesData Python Script
  • GivingTypes Python Script
  • How to create a SQL Script
    • Updating the Header Names
  • That webinar has not been published yet, give us about a day to get it published
  • Online Registration - Basic Videos
  • First Time Attenders
    • Super Condition to the rescue!
  • First Time Givers
  • A Look Back: TouchPoint Jan-Sept 2015
  • Archived Webinar Recordings
  • Org Filter