• Danielle Rosen
  • 0 Points
  • Member since 2017

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 0

I have a field called 'Main Contact,' which is a lookup relationship on my Account object. I am trying to query the Main Contact's email, full name, and phone number, from a button on the Contract object, (custom Conga object.) I've come at this a bunch of different ways, but can't seem to get the data to pull. Here's what I have at the moment: SELECT Main_Contact__r.Email, Main_Contact__r.Name, Main_Contact__r.Phone FROM Account WHERE Id = '{pv0}' Any guidance would be much appreciated! Thank you!