Catching Updated Addresses from Online Sales

Jennifer ParksStrack

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!

Margaret Matteson

I tried this out for size. You would have to run it once a month. Now, a lot of what was happening is that Altru was creating a new address but the address hadn't actually changed.

Jennifer ParksStrack

Thanks for this! I will give it a shot.

Regina Holten

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…

Cara Perez

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

Christina DelGaizo

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