New Data Change Log

It’s official! TntConnect 3.2 is now available for download. Whether you have already downloaded the Beta version or not, go to the Downloads page and download the most current release. Over the coming days I will be sharing about lots of new features.


TntConnect 3.2 now makes a History log entry every time any change is made to any contact field.

For example, one of my partners just moved to a new home down the same street:

First, the automatic entry.

2017-02-28-datachangeaddress1

I can hover over the little notepad to see the change.

2017-02-28-datachangeaddress3

… or double-click on the line to open it.

2017-02-28-datachangeaddress2

Note that the log does not display the entire address that was changed. This move was in the same city, so only the street address and postal code were changed. The TNT data change log only displays the exact fields that changed.

Just like all of the data changes in TntConnect 3.2, this one can be undone by right-clicking on the entry and selecting Revert Data Changes (shown in above image).

You can also Hide the data changes in your history log:

2017-02-28-datachangehide

Advertisements

When did YOU get here?

It’s official! TntConnect 3.2 is now available for download. Whether you have already downloaded the Beta version or not, go to the Downloads page and download the most current release. Over the coming days I will be sharing about lots of new features.


And now, to whet your appetite, today’s blog post:

Another of the new data changes that TntConnect 3.2 logs is when a contact was added to your database.

2017-02-27-datachange-newcontact

TNT has always stored the “Created Date” for a partner, as found on the History Details on the History tab.

For the above new contact:

2017-02-27-datachange-createddate2

For a previous contact in my database, with other history details:

2017-02-27-datachange-createddate

This new automatic entry in the History log is a nice addition, even if it is only for my own curiosity. But again, thinking bigger picture, if I loaded an entire set of new contacts, either from a single referrer or perhaps an event of some kind, it could be nice to see that when reviewing the History for a lot of contacts.

New Pledge Change log

New: TntConnect 3.2 makes a Data Change note every time you make a change to a partner’s pledge:

2017-02-24-pledgechangelog

The icon indicates whether the change was up (+) or down (-). I always used to do this manually, and even explained how and why in the “Tracking Pledge Changes Using Log History” video.

Having pledge changes logged in history is super-helpful, especially because in the History View you can view all of the pledge changes for all contacts, or even for a selected contact.

This is particularly helpful in a multi-user environment (such as a local team) where several people are interacting with the database. Without this feature, there is no way to know when a commitment was changed, or who did it.

Bonus: If you made this change by mistake, you can simply “Undo” (or, technically, “Revert”) this change by right-clicking on it in the History log.

2017-02-24-pledgechangerevert

This is just one of the many new data change features in TntConnect 3.2.

New Fields in TNT 3.2

Over the next several weeks I will be introducing to you all of the 24 staggering new features of TntConnect 3.2.

I say staggering, and I really mean it. (My wife accuses me of exaggeration and hyperbole, but I have repeatedly assured her that I never exaggerate. I always tell the exact truth… as I see it.)

Some of the features are simple and subtle, like this one I am starting with.

Introducing: 7 new fields:

  • 4 additional “User” fields
  • 2 fund development fields
  • 1 “Next Ask Amount” field

User Tab in TntConnect 3.1:

2017-02-22-userfields31

Same User Tab, with field names/tab name changed (tip: double-click on the “User 1” to change the name, or go to Tools | Options | User Tab)

New in 3.2 (four additional fields–for whatever you want):

2017-02-22-contact_usertabblank32

And on the TNT Tab, three new fields:

Next Ask Amount. This is a free-form field, not used in any analytics, but just a place for you to use as needed.

2017-02-22-nextask

Fund Rep (or, Fund Representative), and Estimated Capacity. These fund-development fields are only visible when TntConnect Pro is turned on, and is a part of the many new local fund development features I’ll be highlighting in upcoming days.

2017-02-22-newfdfields

Je me souviens … “I Remember”

montrealBoth of my parents were raised in Montreal, Quebec, or, more accurately, Montréal, Québec, though my parents are not French.

quebecvanityplates

The motto of Quebec is “Je me souviens”, which means, “I remember”. While French speakers make up 80% of Quebec’s population, they are only 20% of Canada’s total population. As a result of this unique “majority here but minority overall”, it is extremely important to Québécois (French-speaking Quebeckers) to remember their unique French heritage—and the contribution it brings to Canada.

Although work brought my parents to the U.S. between children, I am the only one of my U.S.-born siblings who is also a Canadian citizen. As a family, we always spent a week every year in Montreal, and it is like a second home to me (even though I too do not speak French… yet).

For some reason, the motto of Quebec has always stuck with me. “I remember”. When I think about my walk with God—and how He worked in my life in countless ways, “I remember.” God repeatedly instructed the people of Israel to remember what He had done for them. Whenever I wrestle with support raising, I only have to look at TNT to be astounded at what God has done (I celebrated 25 years in the mission field this week). I remember.

Now you’re probably wondering what this has to do with today’s blog post. Absolutely nothing. I just wanted to share that story.

Well, almost nothing.

TntConnect is about to have a major new release, TntConnect 3.2. I have been testing the Beta versions for about 6 weeks, and while I will tell you a lot more about it in future blog posts, let me say this: This version contains some things I have been dreaming of for years. And one of them is about “remembering”.

I repeatedly write about how great it is that TntConnect is data intensive. And the ability to export data quickly and easily and work with it in Excel makes TNT stand out from other support raising tools.

I constantly use the Group Actions | Export Current Group feature. I just did it yesterday to analyze the giving last year for all of my partners. But when I did that, I realized I forgot to select the right fields to export. So I ran the Export Current Group again.

And it remembered.

In the past, Export Current Group would display the default fields. I would change the fields to what I wanted, but not press Save Default Fields because I figured I would not need that exact export again. But I usually did… because I had the wrong group, the wrong fields, etc.

Now, TNT just remembers what I did last time.

2017-02-06-exportcurrentgroup

It’s a simple tweak, but I am thrilled beyond belief. Over the course of thousands of exports, this little tweak will add up to a big time-saver for me.

Speaking of remembering, will you remember to pray for Troy Wolbrink as he finishes up the development of TntConnect 3.2? This version has significant new features for local team fund development, but which will also be very much appreciated by those who rely heavily on TNT to help them run strategies of any kind.

 

That *IS* helpful! (To an accountant…)

givingbymonth
December is our top month–almost double any other month. But it can fluctuate as much as 50% up and down in any given year. I praise the Lord that our other 11 months are fairly consistent.

Maybe it’s just me… I am an accountant after all. But I have to think that we all have things that “strike our fancy” but are almost irrelevant to anyone else. And maybe this is one of those. It is in the file of, “One more reason why I love TntConnect.

For me, one of the benefits of using a data-rich tool like TntConnect is that it allows me to do analysis ‘my way’, and sometimes reveal something interesting.

For example, around 1997 or 1998 I had “abandoned” a state where I had previously raised support. I found it difficult and expensive to go there, and I thought the results simply did not warrant the effort. It seemed like my energy should be invested in other, “more productive” states. Several years later, in 2002, I started using TNT, and just for fun I clicked on the Analysis View, where the default chart is “Average Monthly Gifts by State”. I was surprised to see my ‘abandoned state’ a close second to what I already knew was the #1 state. But I had expected #1 to be around double this #2, not “just higher“.

An even greater surprise came when I clicked through some more of the charts… partners by state, newsletter recipients by state, etc. In several of these, this abandoned state was actually #1!

Everything in me said it could not be true. But I studied it and chewed on it. I finally decided that maybe God was leading me to reinvest time and effort in State X. Good decision: Today, that state is by far our #1 state, generates 30% of our overall support, and is a whopping 2.5 times the #2 state.

A state I had abandoned. And God used TNT to change my mind.

Today’s revelation is a not so profound, but still helpful.

I just exported the Contribution Report to Excel to look at giving by month. I know (it is common knowledge) that December is the biggest giving month per year for both ministries and missionaries. But I was asking: “What is December for us?”

With some simply Excel-wizardry, I came up with this helpful statistic: Over the last 10 years, the lowest December was 44% higher than the average month (January to November) of that year. The highest December was 160% higher (that is 2.6 times the average). Overall, over the past 10 years, December is 92% higher than January through November.

Practically speaking, this reminds me of the important of giving our partners an opportunity to give a special gift in December, because many of them want to do so. And it also helps me plan out our year. I never want to “rely” on December (actually, I want to rely on God only!). But the extra gifts in December often have a way of helping us through leaner months (for us: April, July, September, and November).