No one could write fiction like this

Gander, Newfoundland | September 11, 2001

1160-GanderNL
Gander, Newfoundland airport | Population: 10,000

 

One of the most dramatic stories to come out of the incidents surrounding September 11th was related to the need to land hundreds of planes as quickly as possible–but not in the United States. This is not an easy task, given how many planes are flying around the world at any given moment. In the picture below from this morning, notice all the westbound planes, but specifically the heavier line going diagonally along the U.S. east coast:

 

 

1160-Flights

When the incidents began to unfold that memorable morning, one of the very first actions—and I have no idea how they did this—was to ground all air traffic in the United States. For planes approaching North America, this meant landing at airports in Canada, including the first one, Gander, Newfoundland.

In the early days of trans-Atlantic air travel, all planes stopped here to refuel. But since the jet age it is used primarily for military staging. And unlike other Canadian cities that took in planes (Halifax, Toronto, Montréal, Calgary, etc.), Gander is remote (more than 200 miles away from the nearest city) and small place: only 10,000 people. The next day it was 17,000 people. The story is one of legend as this town absorbed these people for four days–people whose luggage was stuck on the planes for security reasons.

Besides the actual events of that day, what we saw globally was a major change in how we do air travel. It took months for air travel—and the travel industry in general—to recover.

What we are seeing today is unprecedented in the history of the world: The entire world shutting down to stop a potentially deadly virus from spreading out of control. Wow! No fiction author has ever attempted a story like this—who would believe it?!

I teach a World History class to my son’s 10th grade homeschool group, and when we were discussing the bubonic plague in the 15th century a few months ago, I walked them through a discussion about how we were one virus away from a global crisis. “Imagine,” I asked them, “what would happen to our economy if 25-50% of people could no longer work? How would all of our key industries keep running?”

I have three thoughts related to the unfolding and uncertain situation we’re in:

  1. God is still in charge. The bubonic plague and the coronavirus did not happen without His knowledge. And our personal peace and hope should never be on the world or governments around us. Psalm 94:19 says, “When the cares of my heart are many, your consolations cheer my soul.”
  2. As missionaries, I think our top priority is to care for our partners. My wife just celebrated her 30th anniversary with our ministry, and amazingly, our very first partner recently gave their 30th annual gift. During these uncertain times, many of our partners have their own uncertainties and issues… and for many of them, they could be far more serious than ours (more on that below).
  3. I am honestly a bit concerned about the financial state of many of our missionaries’ funding. Giving to missionaries tends to hold up far better than other giving in past times of financial turmoil, but even so, if many of our staff saw a sudden 10-20-50% drop in monthly support, that could put them in a challenging financial position.

Point #2 is most related to the core of this blog. I write about TntConnect first and foremost because I love my partners. TntConnect helps me connect with my partners on a regular basis.

  • Last week when our organization began cancelling all travel, cancelling events, and closing offices, I sent out a quick email to all of our partners to let them know I was praying for them and asking for prayer requests. I got responses from some people who have never responded to an email before. A couple in particular were very concerned about their financial situation because they were already experiencing an immediate financial impact.
  • This week I sent out a paper newsletter to our regular newsletter list with similarly worded content.
  • Next week I am planning to devote some focused time to calling my partners–something I have not done in a while. I have some extra time on my hands because I’m not commuting and all of my son’s sports activities have been cancelled. 🙂

I received an email this week from one of our European partnership development leaders:

[Our] staff generally like to be busy in their assigned ministries. Now that many of those ministries are seriously disrupted it will be good to take more time feeding back into the lives of our supporters. They are living surrounded by fear and we have the opportunity to speak faith into their lives. And to have the focus on us serving them rather than have them serving us. They can become a primary ministry for us for a while.

God bless.

Flexing the Contribution Report

A few moments ago a good friend wrote to ask for advice on the Contribution Report(That links to the 2017 post about this report.)

“We wanted to see last year’s totals, but when we run the report, it shows us February 2018 through February 2019. We then changed the report to go back one more month, but it still shows us two months this year. How can we see only 2018?”

She added that they tried to look at the twelve month total (export) for each partner but that also spanned the year-end.

1158-DefaultView

I offered her one answer and a few workarounds:

Answer: “You are right. You can go back X number of months, but what you cannot do is enter a date range to display months from X to Y.” The report was never designed to do this, which is about its only limitation.


Instead, I offered four options to potentially get the info they sought:

  1. Normally I just send the history of months to Excel the do my calculations and summary in Excel.
  2. If all she wanted was a total for all of last year (or X years in the past) change the report to years and press Update. Then she will get the total per year for each partner.
    1158-PickYears
  3. Export the current group (Group Actions > Export Current Group), but instead of picking “Twelve Month Total”, select “Prev Year Total” to export the stored value for 2018 for each contact.
  4. Use the awesome “Gift Query” which will return all gifts for the selected time frame. Copy and paste the Query text below into File > Utilities > Run Query, and then change the dates to what you want.
select OrgGiftCode, GiftDate, Amount, OrgPaymentMethod, FileAs, MailingAddressBlock, UserName as FundRep FROM (GiftView INNER JOIN Contact on GiftView.ContactID = Contact.ContactID) LEFT JOIN [User] on Contact.FundRepID = [User].UserID
where giftdate between #01/01/2018# and #12/31/2018#

Mass Add/Remove from WITHIN a field

The Mass Change a Field feature historically was a “find and replace” only. For all selected contacts, whatever was in the field was replaced by what you were now adding. That is, you had to replace the entire contents.

TntConnect 3.2 added an enhancement to that feature whereby you can add or remove values in a list. This works for any field with list items, such as the User fields.

So let’s say that I work in an athletic ministry and I track the favourite teams of my partners because I like to reference those teams in my conversation. Here are my partners and their favourite teams:

  • Huck Finn: Canucks
  • George Jetson: Canadiens
  • Fred Flintstone: Maple Leafs, Blue Jays
  • Elmer Fudd: Blue Jays

In this list, “Blue Jays” creates a problem because…

…for Elmer Fudd it is the entire field contents

1154_MassChange1

but for Fred Flintstone it is only part of the field:

1154_MassChange2

The comma between Maple Leafs & Blue Jays is important! The Mass Change can only work if commas separate the entries.


Add a comma-separated value

It’s an Olympic year and my partners are all excited about our team, so let’s say I want to Add “Canadian Olympic Team” to all four of the above contacts:

  1. Group Actions | Mass Change a Field
  2. Select the field to be updated (this is my User 1, renamed to “Favourite Team”)
  3. Select the action I want to take: Add to Comma Separated List
  4. Enter the value I want to add (“Canadian Olympic Team”)
  5. Press OK

1154_MassChange3

This will add (1) a comma and (2) the new text. So the new field values will look like this:

  • Huck Finn: Canucks, Canadian Olympic Team
  • George Jetson: Canadiens, Canadian Olympic Team
  • Fred Flintstone: Maple Leafs, Blue Jays, Canadian Olympic Team
  • Elmer Fudd: Blue Jays, Canadian Olympic Team

Remove comma separated value

Similarly, I can remove items from a list. Let’s say the Blue Jays moved to Toledo so I want to remove that from everyone.

  1. Group Actions | Mass Change a Field
  2. Select the field to be updated (“Favourite Team”)
  3. Select the action I want to take: Remove From Comma Separated List
  4. Enter the value I want to remove (“Blue Jays”)
  5. Press OK

The new field values will look like this:

  • Huck Finn: Canucks, Canadian Olympic Team
  • George Jetson: Canadiens, Canadian Olympic Team
  • Fred Flintstone: Maple Leafs, Canadian Olympic Team
  • Elmer Fudd: Canadian Olympic Team

Finally, remember the easy way to lookup a value inside a field is to use the “contains” option:

1154_MassChange4