Primary Address - E-Mail 1

[ddeegan]

Hello

I am trying to find out the following....In SQL GMFO ver 5.5, what data changes if I mark an e-mail as a primary address?

Select Details tab | Right click on e-mail address | Select Edit... there is a check box labeled "Primary Address"

Where does this affect? I understand what it does, but how does it actually affect the data? - which field in which table? I looked in Contsupp but didn't see a change if it was checked or not.

Thanks in advance
Dave

 

[RobColborne]

Hi

All email addresses are stored in the Contsupp table with a rectype of 'P' and Contact = 'E-mail Address'

When you mark an email address as primary then the second character of the Zip field in Contsupp gets updated:

‘1’ if primary email address
‘0’ otherwise

Therefore the following SQL query will give you a list of all your emails marked as primary.

select * from contsupp where rectype = 'P' and contact = 'E-mail Address' and zip like '_1%'

Hope this helps

Robert Colborne

http://www.prior-analytics.com

CRM Solutions with GoldMine and HEAT

 

[ddeegan]

Hey Rob, thanks alot. It definately helps. I was going nuts looking for that. Usually Godlmine makes it easier to figure out what they are doing. Except for contsupp, seems like anything goes in there.

Thanks again
Dave