Trying to create a table which contains data from the Task object, Opportunity, Contact and Account. I want to capture the tasks that have been created against the opportunity, but obtain the email addresses that are located on the contact’s object. The contact object is related to the Account object. I have managed to only use the Task object but missing the connection to the Contacts to obtain more data, especially the email addresses.
This diagram illustrates a simple flow of how our data is structured.
Any tips on how I can get the emails from the contact object on my table would be great. I’m also trying to avoid placing the data in a drawer.