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

Create a Parameterized Lookup Attribute

Create a parameterized lookup attribute to allow mapping between NSQL query parameters and the appropriate object attributes. This attribute type restricts the choices for users, which are based on their previous field selections. For example, the user selects California from a list of states. In a later field, the cities from which they can select include only California cities.

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:

   Data Type

   Defines the data type for the field. Select Parameterized Lookup.

   Lookup

   Specifies the lookup that is associated with the NSQL query you want to map.

   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. Save your changes.

   The Lookup Parameter Mappings section displays at the bottom of the page. The parameters listed are from the NSQL code for the lookup that is associated with the new attribute.

7. For each lookup parameter listed, select an object attribute ID.
8. Save your changes.

Back to Top