I'm trying to figure out a way to map the multiple Goldmine Email addresses using Starfish.
Goldmine allows virtually unlimited emails because it saves them under a table called CONTSUPP WHERE RECTYPE='P' and CONTACT='E-MAIL ADDRESS'
In SalesLogix to accommodate up to 5 of these email addresses into the fields called EMAIL , SECONDARYEMAIL, EMAIL3, EMAIL4 and EMAIL5.
So I would like the logic to be, if in the destination record, if CONTACT.EMAIL has data, then it should check CONTACT.SECONDARYEMAIL. If it is blank, it should write the email address to this field.
If CONTACT.SECONDARYEMAIL has data then it should check CONTACT.EMAIL3….and if blank, write the email to the EMAIL3 field….etc etc….up to EMAIL5.
If EMAIL5 is blank we can't save any more emails and in which case we would skip the origin record.
Any suggestions on how to achieve this with Starfish?
Login or sign up for our forums to connect to the user community.