Skip to main content
Cartegraph Campus

Setup Multi-Column Lookup Example

This feature requires a Cartegraph OMS license.

In this example we are setting up a multi-column lookup for the Signs recordset and editing the Owner library referenced by Signs. The goal is to be able to search on any part of a phrase.

For example, an organization's list of towns in their Owner library all begin with Town of. Using a multi-column list allows you to enter Del or Nor for Town of Delaware or Town of Northridge.

  1. Click Screen Shot 2018-04-12 at 3.27.44 PM.png>Structure Manager.
  2. Create the Owner library.
  3. Add the Nickname field to the Owner library, as a text field without validation.
The Nickname field is the value searched. Based on our example, the Nicknames are Delaware and Northridge. This allows you to enter Del or Nor, match on the nickname, and auto-populate the Owner field with the value in the Owner column.
  1. Click Publish.
  2. When the Publish completes, click Screen Shot 2018-04-12 at 3.27.44 PM.png>Layout Manager.
  3. Select Libraries.
  4. Select Owner.
  5. Select Lookup View.
  6. Select New.
  7. Enter Owner as the View Name and click Save.
  8. Click Screen Shot 2018-04-13 at 2.44.25 PM.png and select the fields you want in the lookup view, Owner and Nickname.
  9. Click Save
  10. Click Role Administration.
  11. Select the roles you want to have access to this multi-column lookup view.
  12. Click Save,
When someone that belongs to the specified role, the Owner multi-column lookup displays.
  • Was this article helpful?