TouchPointScripts

This is a collection of scripts, widgets, and other handy bits for use with TouchPoint Software, the Church Management System we call "MyTenth."

Tools Available Now

• Attendance Redirect - This tool helps get people to the right Registration for Record Family Attendance.

• Assign Shepherd - This tool allows leaders to be assigned as designated "shepherds" for a family.
  This shepherd can then be referenced in Tasks or when Counseling situations arise.

• Children's Involvement Rules - When added to your daily batch, this script will make sure any Children's Involvements have their proper Extra Values applied, such as the MinistrySafe and Background check heart and checkmark icons on volunteer nametags.

• Classroom Redirect - This tool makes it easier for volunteers to access their Classroom Dashboards.

• Cleanup - Some cleanup required a human touch. This script helps you find and fix those records. (This script is likely to be updated and expanded often; check back periodically for improvements.)

• Demographic Analysis - This Blue Toolbar report readily allows you to see the basic breakdown of demographic groups, like age groups and Resident Codes for any situation where you see a Blue Toolbar.

• Email Address Archiving - TouchPoint can only store two email addresses per user. While most people probably only use one or two email addresses at a time, it can be helpful to keep track of all of the email addresses someone uses across time. This script allows many more email addresses to be immutably associated with a person's record, making future data imports significantly less likely to produce duplicates. This script is strongly encouraged for the Mailchimp and ConstantContact integrations.

• Engagement - This blue toolbar report shows you what engagement people may have recently, particularly useful if they're potentially falling through the cracks.

• Engagement Widget - Compare your populations of attenders, members, and givers. See how (or if) they overlap.

• [Family Attendance](Family Attendance) - Generates a relatively simple attendance sheet intended for printing, for families to mark their attendnance together.

• Finance > Budget Summary - List each budgeted fund and where giving stands compared to budget.

• Finance > Budget Summary Chart - Visual representation of the Budget Summary report.

• Finance > Cumulative Giving YoY (SQL) - Compare giving year-over-year as a percentage of budget, week by week.

• Global > Birthdays & Anniversaries - Generate a list of partners who have birthdays or anniversaries coming up, and email it to the appropriate people. We use this to send cards to partners each month.

• Incoming Email - Process emails sent to a particular inbox. This script is called by Power Automate, which does the actual email-handling. We use this to collect Prayer Requests.

• Link Generator - This simple script generates an authenticated link for a given user, which can be very helpful when supporting users. This allows you to help them effectively bypass their login process and get directly to the content they need.

• Mailchimp Sync - Sync Mailchimp subscribers both ways (from Mailchimp to TouchPoint and vice versa), across multiple Mailchimp accounts and with Mailchimp Interests as TouchPoint Subgroups.

• Non-Weekly Meetings - This script, when added to your Morning Batch, automatically creates meetings for non-weekly Involvements based on Extra Values on the Involvement. Once the meetings are created, automatic attendance reminders will be sent.

• [Prayer List](Prayer List) - This simple script shows a list of prayer requests (notes with a specific tag) that have been submitted in the last week. The page automatically reloads every few seconds because we use this for live submissions during a worship service.

• Recent Attendance Trends - This is a minor update from the standard Recent Attendance Trends widget that ships with TouchPoint, which will use a sliding window of 90 days, rather than a date you need to set.

• Recent Communion - Indicate who has attended services where communion has been served.

• Registrations in Progress - Show the most recent 100 registrations that have been started but not completed. Can be very helpful in diagnosing issues users encounter with registrations.

• Role Checker - Automatically update the roles users have as part of the Morning Batch process. While this doesn't remotely handle all the roles, it does handle those that are most important for us and most likely to change.

• Sage Intacct - Create a reconciliation report that readily imports into Sage Intacct, as required by AcctTwo, our accounting firm.

• Scheduler - A few scripts to fill gaps in getting data out of the Volunteer Scheduler.

• Vital Stats Widget With Bars! - Add a subtle bar chart to your Vital Stats widget.

Tools Under Development

• AD Sync - Automatically sync your church directory into your staff's email & contact directory.

• Mapify - Wondering which neighborhoods need a new Small Group? Or where your attendees actually come from? See people from any search (or Involvement or any other scenario with a Blue Toolbar) on a highly-interactive globe of the world.

• PA Background Check Automation - Pennsylvania has weird and specific laws about how background checks are conducted. This tool tracks their progress, their renewals, and (so far as we are able within the law) automates the process for both staff members and volunteers.

• ConstantContact Sync - Sync ConstantContact subscribers both ways (from ConstantContact to TouchPoint and vice versa).

• Tuition Automation - Automatically calculate and bill tuition for ongoing programs (e.g. preschool).

Tools No Longer Necessary

Occasionally, the TouchPoint team redevelops tools we've created in Python as genuine features in the main TouchPoint system. When that happens, our OG tool becomes unnecessary. But, for posterity, here are those tools:

• ChangeLog - This report lists the most recent changes made to a Person or Family. It shows the person making the change, the person to whom the change was made, and the content of the changes.

• Summon Parent - This is a tool intended for children's workers to "summon" parents when needed. We have it linked within the Mobile App, so workers can send a text in just a few taps, without revealing the personal phone number of either the parent or the volunteer. Eventually, we hope to integrate this with our pager system, as well.