This is a new SQL recipe that your Admin can add to your database. The report will run for the current organization and will be for the life of the organization. The total attendance for the month, the number of meetings, and the average attendance will display in columns, sorting with the most recent at the top.
It’s out there, now! Download it from the App Store – TouchPoint Check-In for iPad. We published the Android version a few months ago, and you can find it at Google Play.
This is a completely new check-in app which replaces BVCheckin. It works almost identically to the Android version. The basic differences are just the differences between Android and Apple products.
If you currently use BVCheckin, replace it with this new app. It is named TouchPoint Check-In. And, of course, the Android and Apple apps are totally free!
TouchPoint has tools for making updates to multiple records at one time, using a Tag or a Search Builder results. We continually add new options, so I wanted to mention this in a blog post again.
Only your System Admin can run these batch processes and he must do this with fear and trembling! Maybe that is a bit extreme, but he must use extreme caution as there is no undo button and these batch updates immediately update fields (or perform other actions) on all the records in your Tag or Query.
Example: Updating the Grade field
Now that Promotion has ended for most churches you might be interested in updating Grades.
Remember, for Main Fellowship classes with a Grade on the organization, anyone enrolled in that org will automatically get that Grade put on their people record at the time they are enrolled or promoted. In these cases, you do not need to update the grades.
However, some churches have Main Fellowship classes that span multiple grades, or perhaps you may NOT have entered a Grade on the organizations prior to Promotion. In these cases you could use the batch process to add the Grade after the children have been promoted.
A few newer options for the batch process for Grade are Remove Grade, Custom Grade, Add 1 Grade Level. There are quite a few options for Grade, so you would want to read more about this.
The Grade field is only one of many fields that can be updated. Check out the entire list in the help article. The article also contains explanations for the various Grade options.
These two reports for Admins are very helpful not only to see how many registrations you have for an event (on the Summary) but also to help you troubleshoot when someone has a question about his registration or a problem registering.
The Registration History is a list of every registration whether it was ever completed or not. That page, which is actually a registration search page, has various filtering options as well, which will help you find a specific person’s registration. You can even filter to find only registrations that originated from the TouchPoint mobile app!
Whereas the Registration History is a list of every individual registration, the Registration Summary is just that – a summary of registrations by Description. The Description is actually the name of the organization used for the registration.
This is for Finance and Admin users. It is a new SQL script you can add to your database so that, instead of drilling down to a specific donor to see the details of his giving when troubleshooting, you can see both the list of donors as well as the details of their giving all on one report.
In my blog post earlier this week regarding the batch update for address in TouchPoint, I had forgotten that, for some very good reasons, we have that locked down so only our TouchPoint Support Team can run that process. Oops!
I’m sorry for any confusion that caused. Sometimes, I just don’t know everything I know – if you know what I mean
I have amended that post to indicate that if you want that process run, just send a support request along with the shared Tag or the saved search for which you want it run.
Again, please accept my apologies for the mistake and confusion.
UPDATE: The batch update process is restricted for now. So, when you want that to be run, just send a support request and we will do it for you. Just give us access to your Tag or send us the name of your saved search.
TouchPoint has some great tools to help you keep your database well-oiled and squeaky clean…so to speak. Those I want to mention today related to address verification: the Search Builder Condition “Has Zip +4” and the batch process “Validate Addresses for a Tag/Query“.
By using both of these, you can clean up any addresses that have not been validated for some reason.They might be old records, or they might be brand new records that were added during an online registration. When you add a new record to the database you will validate the address at that time, and the +4 will get added. Also, when you verify new record to remove the Just Added status you should be validating the address. But sometimes that does not always happen. Also, if you have TouchPoint import any records using spreadsheets these records will not be validated.