“Are you all okay?”

Two weeks ago I called a ministry partner in Houston. She’s an elderly woman who lives alone, and her daughter, I know, lives in Chicago. “I’m concerned about you,” I said. “Are you okay?”

She thanked me for calling and assured me she was fine. Her street was a river, but her front steps were dry. She felt very fortunate.

That was two weeks ago. Monday this week I texted my wife and asked her, “Are you all okay?”

I’m a pretty lousy husband. While my family was sleeping in the closet as Hurricane Irma blew over our house, I was on an international trip in Africa. Except for being without power for about 48 hours, and having a lot tree debris to cleanup, they were fine. She told me our neighborhood turned out like an anthill that was just kicked over–people we almost never out of doors emerged to see who lost a tree (or didn’t). Neighbors helping neighbors clean up. Won’t last long, but it’s great to see.

I appreciate that TntConnect helps me reach out to my partners and show compassion during a weather crisis like these–events that often affect a widespread area, and because of that I cannot know how my partners have fared unless I ask them. (Tornadoes, wildfires, earthquakes; sad we need a reason, but showing we care… shows we care.)

The best way to connect, of course, is just to call. Email or text is okay, I suppose. But a real phone call says a lot.

I use TNT to help me do this by using the Lookups to help me identify the contacts I could call. For example, last month I looked up all partners in Texas using Lookup | By State. Sometimes Lookup | By City works if that’s what I need.

One of my partners just moved to Texas a couple of months ago; I wasn’t sure where the town was, so I used the Google Maps button in TNT to discern that they lived outside Dallas, not Houston. But I contacted them anyway because a new address & new home were a good reason to call. And I started the call simply by asking, “Has Hurricane Harvey affected you at all?”


I don’t have ulterior motives with these calls. Every opportunity to reach out to a partner is a good one. Our partners love to hear from us, and most missionaries (like me) use the microphone portion of their smart”phone” far less than we should.

Speaking of that, How are you? If you were in an area impacted by Harvey or Irma–or wildfires in the West–I hope you have seen an outpouring of bonhomie from relatives, friends, neighbors, or even complete strangers.


He giveth and taketh away

One of the most well-known, and truly unique features, of TntConnect is the “universal filter”, the Lookup tool that allows you to add or remove any criteria from any Lookup. Most web-based tools (like shopping sites) allow you to narrow down the list, but very few allow you narrow down and add to, or “reverse” the lookup, or even combine disparate items.

TntConnect 3.2 adds some similar functionality to a little-known feature called Mass Change a Field.

TNT’s ability to change the value of a single field for all selected contacts has always been super-helpful to me. For example, I was adding the Church Name to about 20 contacts one time. I could do that for each contact individually… or I could make the Current Group those 20 contacts, then select Group Actions | Mass Change a Field and do it all at once.

Group Field Change in earlier versions of TNT: Deleted the old field value and replaced it with the new value:


Now in 3.2 the options are expanded:


You can now (still) simply “replace” the old field value with the new one (that is, “Change Field”).

But you can also Add to Comma Separated List, which will take the value you have and place it after a comma in addition to any other items that are in the field. Or, Remove from Comma Separated List, which will delete the chosen value if it exists in that field.

Many people use the User Fields to make TNT unique and personal. For example, if I was in athletic ministry and I renamed User 1 to be “Favourite Sports Team”. Some people may have one team: “Montreal Canadiens”. But others might have two “Montreal Canadiens, Toronto Blue Jays” or more.

The beauty of TntConnect’s amazingly powerful lookups/filters (as mentioned at the top) is that I can do Lookups within a field. Let’s say, for example, that I want to find all contacts for whom “Montreal” is in Favourite Sports Team (whether it is the Canadiens, the Expos, the Alouettes, etc.), I can just do a lookup for that:


To wrap up, the powerful Lookups, the versatile User Fields, and the nifty Mass Change a Field all work together to make managing a lot of information very helpful. Indeed, it is so exciting it is almost like sitting in a hockey arena watching the Stanley Cup. 😉

Don’t send it twice!


** Secret feature alert! **

Faced an interesting dilemma this evening: I needed to print and send our current newsletter. But unlike normal months, there was a group of partners I did NOT want to send the letter to, because I had just sent them a special update just a week ago.

How did I solve this dilemma? By using one of TntConnect’s “secret features”: I looked up my newsletter list, then went to my History and selected the history entry for last week’s special update, then “removed” those people from the list.

Here’s how (screen shots below):

  1. Use the Newsletter Tools Helper to find my newsletter recipients
  2. Go to the History View and right-click on the update recipients
  3. Select “Remove from Current Lookup

The Newsletter Tools Helper filters the 22 paper newsletter recipients:


I then go to the History View and right-click on last week’s special update to 30 people (only some of whom are regular newsletter recipients):


After removing the Special Update recipients, there are 10 people left who still need a newsletter this month: