System Administrator Scenarios › How to Create a Custom Object › Create Attributes › Create a Single Value Lookup Attribute

Create a Single Value Lookup Attribute

Create a single value lookup attribute to display a drop-down or a browse list from which users can select only one value. For example, the Status attribute on a project that contains the values Approved, Not Approved, and Rejected is a single-value lookup attribute.

A single value lookup attribute can include the following source types:

• Static List. Provides a list of values that do not change (for example, action item status). If you select a static list lookup, you can set up a display mapping to associate a value with a description and a color or icon. These colors or icons can be used in many places throughout the product, such as in stoplight icons, filters, progress bars, Gantt charts, and chart backgrounds.
• Dynamic Query. Provides a list of values that are dynamic based on the NSQL query. For example, a list of active and locked resources.

Follow these steps:

1. Open Administration, and from Studio, click Objects.
2. Click the name of the object.
3. Click Attributes.
4. Click New.
5. Complete the requested information. The following fields require explanation:

   Partition

   Specifies the partition to associate with the attribute.

   Partition Association Mode

   Specifies which partitions can include the attribute, in addition to the selected partition.

   Data Type

   Defines the data type for the field. Select Lookup.

   Lookup

   Specifies the lookup that appears in the field (static list or dynamic query) displaying a list of options that the user can select.

   Default

   Specifies the default value for the attribute.

   Populate Null Values with the Default

   Specifies whether to populate existing objects automatically with the default value.

   Value Required

   Specifies whether a value is required for the attribute.

   Presence Required

   Specifies that the attribute always appears in the Edit Properties view.

6. (Optional) To set up a display mapping for a static lookup, complete the following steps. You cannot set up a display mapping for a dynamic query.
   1. In the Type field, select Color or Icon.
   2. Select the appropriate color or icon.
   3. Enter a brief description of the color or icon representation in the Description field.
   4. Select the lookup value to represent by the color or icon in the Value field.

      You can define a color or icon for up to ten values in addition to an optional Default Bucket for all values that do not have an assigned color or icon.

   Repeat this step to define any other values to color-code or represent by an icon.

7. Save your changes.

Back to Top