OrgChart Now 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 More > Chart Settings, and then select the Fields & Formulas option from the Settings dropdown menu.

    ChartSettings_FieldsandFormulasArrow.png
  3. Click on the + f(x) button to create a new formula.

    NewFormula.png
  4. Enter a name (i.e Supervisor Name) in the Formula Name textbox.

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

    LookUpFormula.png
  6. 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.

  7. 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.

  8. 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
  9. 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