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

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s