New SQL Script – Registration Email Different from Personal Record

You don’t have to love SQL or even know what it is to create this script in your database. I’m sure you have noticed in recent blogs posts that we have begun mentioning Python and SQL and how they are used in TouchPoint. That’s because we are discovering more and more uses for these tools and want to share them with you.

The feature today is a script that creates a report of everyone who registered online for any event and used an email address that was different from the email address on their personal record.

Sometimes when registering, people mistype their email address, and when you send emails to the organization, their emails are bounced back as undeliverable. Glancing through this report gives you an opportunity to check those and make any corrections that are necessary.

The report has a link to the person’s record, making it simple go back and forth between the report and individual’s records, making any changes that are needed. The report also displays the name of the registration, so when viewing the person’s record, you can click the Member Dialog for that org and fix or even remove the Register Email.

If this sounds like something you’d like to see in your database, you will want to read the documentation that walks you through creating this script. We even give you the code that your System Admin can copy and paste into your database! How easy is that?

Read more..

PS  For security reasons, we never automatically change a person’s email address based on the Register Email. We do encourage registrants to create an account and keep their personal information up-to-date.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s