Lookup Tables

Use the Lookup Tables panel to add, modify, or remove lookup table definitions.  Lookup tables make writing expressions easier. Expressions that use a lookup table are shorter, as data entered in lookup tables is used in the LOOKUP expression. The LOOKUP expression is found in the Internal Functions category of any option that uses an expression builder interface. Lookup tables can be used to populate values in activity types, attributes or the summary report.


Instructions

On the Setup tab, in the Settings group, click Lookup Tables to display the Lookup Tables interface.

General Workflow

  1. Click the green + button in the upper left corner of the panel to add a new lookup table, or click a lookup table name to edit an existing lookup table.
  2. Click the green + button at the bottom left corner of the Lookup Tables panel to add new Value columns to the Details grid.
  3. Complete the grid with Key names and appropriate values.

Lookup Tables

Adding and Defining a New Lookup Table Definition

Click Add to add a new entry, or press the INSERT key on your keyboard.

Modifying a Lookup Table

Select an entry and modify the displayed information as needed.

Copying a Lookup Table

Select an entry and click Copy to create a copy of the selected entry or press Ctrl+ C.

Removing a Lookup Table

Select an entry and click Remove to remove the selected entry or press Delete. The entry can only be removed if it is not being used in the project.

Moving a Lookup Table

Select an entry and click Up or Down to move the entry up or down in the list, or press Ctrl + Up arrow or Ctrl + Down arrow.

General

Name

Enter a name for the lookup table definition.

Description

Enter a brief description of the lookup table definition.

Details

Key

Enter text that will serve as the key for that entry in the lookup table definition.

Value 1, Value 2, Value 3...

Enter a value in each column.

Add

Click the Add icon below the table to add a new value column to the table.

Remove

Click the Remove icon below the table to remove the last value column from the table.

Tip
  • Column names in the Details grid are set. Associate column names with the values they contain in the Description field for the table.

  • To create a new row in the Details grid, complete the Key column and the Value 1 column, then press [Enter].

  • Click the green + button at the bottom of the Lookup Tables panel to add new Value columns to the Details grid.

  • Click the red - button at the bottom of the Lookup Tables panel to delete the last value column in the Details grid.

  • To remove an unwanted row in the Details grid, select the row and press [Delete].

  • When the lookup expression asks for the value column, the Value 1 column in the lookup table = 1 and the Value 2 column in the lookup table = 2. The Key column in the lookup table does not have an associated value number.