Skip to main content

OrgChart Help Guide

Lookup Example

Audience

Audience: Administrators

Overview

The Lookup formula enables administrators to look up a value in another record (for example, looking up the name of an employee's manager using an employee's record.

In this example, we will create a Lookup formula that will use the PersonID and SupervisorID fields to return a supervisor's name.

Creating a Lookup Formula

  1. Log in to OrgChart.

  2. Click on the Mode Switcher icon in the Top Toolbar, and then select the Setup option. The Setup panel is displayed.

    Setup_ChartSettings_Select.png
  3. Click on the Chart Settings tile, and then select the Fields & Formulas option from the left side menu..

    5_2_1_CS_FieldsandFormulas_Arrow.png
  4. Click on the green f(x) Create button in the top left corner, and then select the Static Formula option. The Formula Editor panel is displayed.

    5_2_2_Fields_and_Formulas__Select_Static_Formula.png
  5. Enter a name (i.e Supervisor Name) in the Formula Name textbox.

  6. Click on the No values. Click here to add." hyperlink, and then select the Lookup option from the dropdown menu.

    LookUpFormula.png
  7. Click on the Lookup Using dropdown, and then select the field (i.e. PersonID) that you would like to use to initiate the lookup process.

  8. Click on the Match Using dropdown menu, and then select the field (i.e. SupervisorID) that you would like to associate with the lookup field.

  9. Click on the Return Using dropdown menu, and then select the field (ie. Name) that you would like to return from a record depending on the matched field.

    LookUp_Config.png
  10. Select Save, and then Refresh . The Supervisor Name field will now return the name of an employee's direct supervisor. This information can be added to the Profile, or included in a Box Style.

    LookUp_Example.png