Ability to copy address to alternate before changing a constituent's address

When changing a constituent's address, best practice is to copy the previous address to an alternate before applying the change.  This preserves the old address information. The current NXT process simply over-writes the current address.  Would like the process to mimic the database view approach.

  • Guest
  • Dec 8 2017
  • Reviewed: Voting Open
  • Attach files
  • Jennifer Gallo commented
    25 Nov 13:36

    This is necessary to keep our students connected with their parents. Please ensure this is included ASAP!

    With the USPS taking so long to return incorrect addresses, I use the previous address on the record to ensure that I am not updating to another incorrect address.

  • Lori Kroening commented
    19 Nov 23:50

    This efficient and essential process is a key element in maintaining accurate address data in database view. Sometimes records with similar names get "tangled," or inaccurate information is entered, and address histories help sort out where errors were made. Other users have provided numerous excellent reasons why this functionality should not be sacrificed. Maintaining address histories is critical; doing so with a minimum of manual data entry (and opportunities for error) is vital.

  • Tatyana Leifman commented
    19 Nov 17:58

    This is an imperative feature that helps maintain a clean database. It is a simple feature that encourages those who update records to use it and, thus, retain old address history. Any other workaround invites errors, typos, omissions, and missing steps. All of which will result in a "dirty" database.

    Having a history of addresses has helped me

    1. to identify duplicates,

    2. match spouses,

    3. link children,

    4. identify when an address provided for a donor by a layperson (or looked up online) is an old address and so shouldn't override the address on the record,

    5. confirm a deceased donor: an updated address may be one of a child or executor in a different state from the one where the donor resided. I may have a John Smith with an address in Nebraska but the obituary I find for John Smith says he resided in Illinois. Without an address history, I won't know that my John Smith previously resided in Illinois and that his change in address coincides with the date of death mentioned in the obit.

    Before my time at my organization, old addresses were not retained and bad addresses were simply erased, even when an updated address was not available. This has resulted in an unknown number of duplicate donors and donors who may be deceased but are not so marked. And without significant effort and time (and who has that?) this situation cannot be remedied.

    Please move the feature to WV.


  • JoAnn Strommen commented
    19 Sep 20:42

    We use this feature for all address updates. Great history when tracking alumni and matching in data appends.

    Needed feature. The sales pitch along has been that web view will have all the function of db view. Still hoping.

  • Danielle Keeney commented
    07 Aug 17:48

    In db view, the copy to alternate quickly allows us to maintain good data while archiving historical addresses (which can be very critical when trying to determine if you have a match to an existing record).

    In db, copy preferred address to alternate creates a new address record on the constituent to archive it. It removed the preferred address indicator, unchecks send mail to this address, adds a Date To address of today, and has an indicator of Alternate. For us, it also marks the Address Type as Previous Address.

    It also then keeps the original address for the constituent there for you to change. And the important part of that is that that original address is shared with the spouse.

    Using the Copy to Alternate in conjunction with changing the original and choosing to update all records that share the address is a quick and effective way to archive and keep data current.


    In web view, if you modify the existing address to previous and then add a new address, the spouse address is still shared to the now old address that you just made previous.

    To replicate the actions of db view, you would need to add a new address to the constituent record and manually enter the address which is now old with the previous address indicators and such. Then go and modify the existing address to the new address so that the shared with spouse address is now updated correctly.

  • Steven Lopresti commented
    25 Mar 13:55

    I'm perplexed that the status of this idea is "Need Further Info". Please don't reinvent the wheel. This should work the same way as the "Copy preferred address to alternate" functionality in database view. What it does:

    1. Makes an copy of the preferred address (primary address in RE NXT), including date from, source info, seasonal dates, etc.

    2. Changes the address type of the copy to the one set in our Business Rules for copying preferred addresses to alternate (for us, it's "Previous address").

    3. Deactivates the copy by unmarking the Send mail to this address checkbox (or marking the Do not mail box in RE NXT).

    4. Enters today's date in the Valid date to field.

    This allows us to then overwrite the preferred address with new address information, confident that the old one has been backed up as an alternate address.

  • Sandra Ross commented
    January 01, 2022 21:45

    Agree, this is much needed along with the important data management fields of Date From, Date To, Region Code and Source.

  • Karen Diener commented
    July 14, 2020 12:57

    To NOT roll this out in webview is short-sighted. It is absolutely best practice to preserve address history and I have relied on it many, many times to merge duplicate records, prevent old addresses from resurfacing, and clarify other mailing list concerns.

    Because this is tagged as "Reviewed: need further info", I'm curious to know what further info is desired? If there are specific questions that need answers, I'm sure the community would be happy to provide!

  • Gwen Williams commented
    April 28, 2020 13:27

    I agree, that we need to be able to do this in NXT. If this is added, we do need to be able to restrict access so everyone does not have the ability to update address information in NXT like what we can do in database view now. At our organization, there are only a few of us that can update address/contact information.

  • Drew Matthews commented
    August 27, 2019 15:49

    Ron, The request is for a function in NXT that is similar to the the function in the database view for Copy Preferred Address to Alternate. I use this function when we have a new address. I doubt many users use this function just to make a simple edit or correction to an address.

  • Teddi Taylor commented
    August 26, 2019 15:32

    I have a report built on the Date to and the Address type of the former address, which is automatically populated from the "Copy preferred address to alternate". When there are multiple steps in NXT to do the same thing, there is more room for human error. 

  • Guest commented
    August 26, 2019 00:34

    Yes, you can manually achieve the same as 'copy address to alt', but as Drew mentioned, this falls down for shared addresses.  Response from my customer success manager about it, indicating better workflow coming:

    It’s the same sort of process, but without the one click option to copy to alternate (yet 😊)

     

    You would need to:

    1. Copy (manually) the old address and add it as a “new” address (with the type of “former”, or similar), then
    2. Overwrite the original address record, at which point RE NXT will ask you if you want to change it for all records who share that address.
  • Becky Jones commented
    August 25, 2019 17:37

    I guess I don't understand why you need further information. 

    If someone goes into an address and updates it in NXT, the previous address is lost....which is why we make all address changed in database side of RE, to keep history.  We keep the history of addresses because we frequently are told a person's address and in looking in the history of addresses, the address we've just been given is really an old address.  As we are going through this process now with reconciling addresses in Core with RE.  Our Core addresses in some cases, had not been updated in several years, while the RE address has been kept up.  If we didn't save address history in RE database version, we'd keep entering the same incorrect information by putting in the old address, because we could not see the history of addresses.  Why the is the history automatically kept in Core profile changes but not in RE.  Or is there a way to see address change history of address changes made in NXT that I have missed?  Thank you.

  • Ron Fontenot commented
    August 25, 2019 17:14

    Becky - I am trying to understand the scenario. I think this is for "I found out Robert Hernandez has moved and has a new preferred address", not a simple edit. I think this is just an ask for some replacement of the "Copy Preferred Address to Alternate".

    In RE7 that copy feature lets you take "Address Record X" and create a copy of it "Address Record X(1)" (essentially, kept for history), then you edit "Address Record X" to make it "Address Record Y" and preferred. In web view, you can simply add Address Record Y, mark it as preferred, and you've achieved the same end. So, I am guessing there is some more subtle nuance to this request.

  • Becky Jones commented
    August 25, 2019 16:45

    If I am reading the suggestion, it says that RE NXT over-writes the current address, therefore there would be no 'old' address to put an end date on.

    To the Admin,  are you saying NXT automatically copies the preferred address to alternate without manually doing it? 

  • Ron Fontenot commented
    August 25, 2019 15:57

    If by "change" you mean the constituent has moved and we need a new address: If this is the case, the expectation would be to just add the new address, mark it primary, then go to the old address and put a valid end date on it. This preserves the address history.

    If by "change" you mean there is a typo on the address and we need to fix it: Is this just an ask for audit trail info to know who last edited an address?

    Please clarify. Thanks!

  • Drew Matthews commented
    December 28, 2017 16:45

    Additionally - need the function (like in database view) to make the change on all shared addresses. This is important when updating the primary address for an organization and the business address for all of the contacts (that share the org primary) needs to change as well. 

  • +54