We have a "champion" field in our sf.com account record. That field is a lookup field on the contact record.
I'm trying to have access to the corresponding email address for this contact, to use in a survey program (JO). Either through a power list or query builder (or something else). Since the email of that contact is not in the account record as a field, is there a way to fetch it easily?
Thanks!
Lyne
Solved
Lookup field in sf.com, used as a survey recipient
+1Best answer by dan_ahrens
Hi Lyne,
You'd want to use bionic query and do two fetch tasks:
1) pull in the champion on each account and the contact ID that it looks up to
2) pull in all contacts, their email and their contact ID
Then do a merge, creating a new data set that links the account info with the contact info, using the contact ID field as the merge field.
More info here: https://support.gainsight.com/Journey_Orchestrator_and_Email/Programs/Adding_Participants_to_a_Program#Query_Builder
You'd want to use bionic query and do two fetch tasks:
1) pull in the champion on each account and the contact ID that it looks up to
2) pull in all contacts, their email and their contact ID
Then do a merge, creating a new data set that links the account info with the contact info, using the contact ID field as the merge field.
More info here: https://support.gainsight.com/Journey_Orchestrator_and_Email/Programs/Adding_Participants_to_a_Program#Query_Builder
+4Not sure if this is the best or prescribed method, one way (that I think is easy for this use case) is to put together a
+2Hi Lyne,
You'd want to use bionic query and do two fetch tasks:
1) pull in the champion on each account and the contact ID that it looks up to
2) pull in all contacts, their email and their contact ID
Then do a merge, creating a new data set that links the account info with the contact info, using the contact ID field as the merge field.
More info here: https://support.gainsight.com/Journey_Orchestrator_and_Email/Programs/Adding_Participants_to_a_Program#Query_Builder
You'd want to use bionic query and do two fetch tasks:
1) pull in the champion on each account and the contact ID that it looks up to
2) pull in all contacts, their email and their contact ID
Then do a merge, creating a new data set that links the account info with the contact info, using the contact ID field as the merge field.
More info here: https://support.gainsight.com/Journey_Orchestrator_and_Email/Programs/Adding_Participants_to_a_Program#Query_Builder
+1Thanks Dan. I cannot find a contact ID for that look-up field so I'm waiting on my sf.com admin to help out here. I'm sure there is an ID field. Just need the right permission to see it, no doubt.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.