We have a profile for registering people. It is set to match on email. If an existing contact fills out the form but say uses their billing email address and not the one set as their primary, it matches fine. Great, but then it overwrites the primary with what they just entered. Now we've lost their "primary" email address and have the same email address listed twice, once as billing and once as home.
Is there some nice easy way around this? I'm I missing something?
I suppose I could create another type and set the profile for that. Would still end up with the same address twice but wouldn't loose the other. Or maybe a db trigger to skip the write to the email table if the email address already exists for that user.
Ah, the tangled web we create when we allow contacts to mess with their data.