Catching Updated Addresses from Online Sales

I recently learned that when an existing patron uses a new address when they purchase tickets online, the address gets added to their record, but is not made the primary address automatically. Does anyone have a workaround or a query idea on how to catch these new addresses? Thanks!

Comments

  • Thanks for this! I will give it a shot.
  • this is epic, thank you…what happened a few times here were members registering for something…but let's say they'd put in their neighbors add for whatever items needed to be the central shipping place…this goofed me up some in that i thought the person had moved…i wish there were an option on all web forms something like…please u/d my mailing address or, check a box as a 2ndary address…anyway, thanks again, i'll be adding this query to my clean up ones…

  • Thank you for sharing! This is very helpful. I have used this to check new email addresses.

  • Thank you so much for this query! I modified it for email addresses and it works perfectly!

Categories