Reference specific field of a record

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
  • (Edited)

Setup

Table 1 is an organization table.  The two primary fields in the table is the employee name and employee email address.  The table is related to itself so that employees report to employees who report to employees. 

Table 2 is a project management table.  The organization table is linked to the project management table whereby the application owner uses the organization table employee name field as a drop down field. 

When the table user selects an application owner (employee name) it will display the name of the manager and the name of the manager's manager.  Keeping in mind that every employee record has an email, what I'm trying to do is identify the email address associated with the name in the manager's manager field.  I can then use a ToUser formula to get the user value associated with the email address.  So, how do I write a formula to get the email address of the user in the manager's manager field?

Photo of Michael Sargent

Michael Sargent

  • 150 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
I think you might approach this through first creating the appropriate lookup fields through your relationships to get the manager's manager's email address field available in the target employee's record, and then you won't need any formulas other than the final ToUser.