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. 😉

Google Maps & TntConnect. Wow.

Cannot help but love the integration between TntConnect & Google Maps! So much so, in fact, that for two years I used the Google Maps view as the background for a TNT page I was managing:


Map View button

The Map View displays an integrated Google Chrome browser (which works even if you do not use Chrome on your system). This flexible feature allows you to change display to show five different views, based on the contacts you currently have up in the Contacts View.

Most of these are based on the Current Group of selected contacts. But not all contacts will appear in each option as the display is based on if they fit the display criteria (for example, whether they get your newsletter or not).

  • The currently selected Individual


  • All contacts in the Current Group


  • The Status Dot of all the Current Group


  • The Newsletter preference (if they have one)


  • Any Pictures in the Current Group


In addition to the Map View, TntConnect also has the original Google Maps Button on the Contact View that will locate the selected contact in Google Maps in your internet browser. This can be helpful if you want to map directions to the partner’s house:


The first time you view contacts in the Map View, it will take some time as the map attempts to locate the addresses. Once it finds them, TNT actually stores the GPS coordinates in that contact’s hidden info area, so the next time you look up the map it will be instantaneous. As always, some addresses cannot be found (e.g., P.O. boxes or an otherwise unmappable address), so TNT will simply label them in the map as “Approximate” based on information it can find (such as a city or postal code but not the exact address).

F1 Help on the Map View and Google Maps features.

Be a “Pro” with TntConnect Pro

There are a lot of free software tools where they entice you with the Free or “Basic” version, but make you pay for the “Pro” version–the version that has the ‘really useful’ features.

TntConnect delivers about 99.9% of its features in the free “Basic” version, and delivers the other 0.1% in the free “Pro” version. Can’t beat that price, eh?

What’s the difference? Simply, TntConnect Pro exposes a few features for those who manage multiple designations in one database. Since most users only manage one designation (their own missionary account #), there is no need to have the multi-designation features turned on.

If you manage multiple designations in one TntConnect database, go to Tools | Options and check the box, “Display extended information (TntConnect Pro)”.


When you do this, without restarting you will see designation options/display in 3 key areas.

Gift List


Lookup | By Giving


Notice that Pro also displays the “Motivation Code”. This is used by some organizations who assign codes related to fund appeals.

Tools | Contribution Report


Read more about TntConnect Pro

TntConnect 3.1 Now Available!

I am pleased to announce that the latest version of TntMPD is now available! Here are the main things about this upgrade:

  • TntMPD has a new name: TntConnect.
  • This release offers some huge new features for multi-national users: Multi-currency support… People who receive gifts in multiple currencies/multiple countries can now combine all of their TntMPD databases into one TntConnect database and it will display the gifts for each contact, in the currency they gave in! And because these folks will merge these databases, 3.1 offers multi-language newsletters: You can pick the language for each contact’s newsletter, then produce the newsletter list by language (using the Newsletter Tools button on the button bar).
  • This releases fixes all of the outstanding technical problems with Windows 10, Mac El Capitan, Google Maps & Google Login, etc.
  • You can easily export your current gift download by right-clicking on the list of new gifts before you click the “Sync” button to finish the download (helpful for those who want to see the list or act on it right away). This is before TntConnect runs the Automatic Actions for New Gifts.
  • In the Options you can enlarge TntConnect 125%, 150% or 200% if your monitor has made it too small to work easily
  • There are more than 70 other minor features and fixes.
  • Finally, the “Database Password” has been eliminated. It was problematic for most users, and was a false sense of security… since you can export all TntConnect data unprotected to your hard drive. Protect your computer instead. (And by the way, I strongly encourage you to store your database in Dropbox.)

Here is the official TntConnect 3.1 Upgrade Video

Also, in addition to this new blog, you may want to check out some new training videos on TntConnect. Hosted by a company called SmartStory, you can view a “Tip of the Week” (53 videos), all under 3 minutes long, at www.tinyurl.com/GoTntTips.

You can also view these videos on the free SmartPath App for iPhone and Android. Once you download the app, just enter our SmartCode (GoTntTips) to get right to the videos. (You do not need to sign up or register or subscribe–just go right to the videos.)

Note: This blog is not intended to be a forum, because the user-supported community/forum for TntConnect is very active–you can get answers to all your questions there. This blog is for tips and tricks and best practices to help you make the most of TntConnect.