Share via


Add or edit enterprise custom lookup tables in Project Server

Summary: Use the New Custom Field page in Project Web App settings to specify the options for a custom lookup table.
Applies to: Project Server Subscription Edition, Project Server 2019, Project Server 2016, Project Server 2013

Use the following procedure to create or edit an enterprise custom lookup table.

To create or edit Enterprise Custom Lookup Tables

  1. On the Project Web App home page, on the Settings menu, click Project Web App Settings.

  2. On the Project Web App Server Settings page, click Enterprise Custom fields and Lookup Tables.

  3. In the Lookup Tables for Custom Fields section, click New Lookup Table to create a new lookup table, or click the lookup table that you want to edit.

  4. For a new table, type a name for the lookup table in the Name box.

  5. Fill out the Custom Lookup Table page by specifying the options that you want to use. See the descriptions for each field in the following sections.

  6. Click Save.

Type

For a new lookup table, you must specify a data type for the table. It is not possible to mix field types in a table.

The following table describes the options for data types in a custom lookup table.

Data types for custom lookup tables in Project Web App

Attribute Description
Cost
Each field in the table is a cost value.
Date
Each field in the table is a date value.
Duration
Each value in the table is treated as a duration.
Number
Each value in the table is a number.
Text
Each value in the table is text. Choosing Text also allows a hierarchy of values to be specified if you want.

Code mask

The code mask option only appears when a field type of Text has been selected.

The code mask lets you specify what types of text characters appear in the lookup table, the length of the string, and what characters to use to separate levels in a hierarchy. If you are creating a hierarchical lookup table, you must specify a code mask for each level of the hierarchy.

The following table describes the options available for configuring code masks.

Code mask settings for a custom lookup table in Project Web App

Attribute Description
Code preview
Displays a preview of the code mask for the table.
Sequence
Specify the type of text characters to allow. Choose Numbers, Uppercase characters, Lowercase characters, or Characters.
Length
Specify the maximum length of the string. Choose a number from 1 to 255 or Any.
Separator
Specify from one to three characters to use as a separator between levels of the table hierarchy.

Lookup Table

Use the Lookup Table section of the New Lookup table page to specify the values in the lookup table.

Type each value that you want in the lookup table in the Value column. Create as many rows as needed to accommodate the values that you want to include. Optionally, include a description for the value in the Description column.

The following table describes the options for creating lookup table values.

Lookup table values in Project Web App

Attribute Description
Level
Denotes the level in the hierarchy. This is a read-only field. Select the row and use the Indent and Outdent buttons to change levels.
Value
Specify the value of the field.
Description
Describes what the field represents. (Optional)
Move
Use the Move buttons to change the position of rows in the table. Select a row and then click the Up or Down Move button to move a row.
Display order for lookup table
Specifies how to sort the lookup table. If you select By row number, the table remains sorted as you specify it. If you choose to sort ascending or descending, the table is sorted based on the values in the Value column.

See also

Add or edit enterprise custom fields in Project Server