Lookup Fields

Modified on Tue, 10 Nov at 4:30 AM

Lookup fields let users select specific users, groups, records from other databases and assets from the Resources module, right inside the record they are working on.

Depending on the type of Lookup field and what is selected, you can use it to trigger alerts, assign permissions, relate items or link databases together. There are four types:

Lookup TypeWhat Users Can Select
Database LookupRecords from another database, linking the two databases together.
User LookupIndividual users on the platform.
Groups LookupWhole groups of users.
Resources LookupAssets from the Resources module.

Database Lookup Fields

Database Lookup fields link databases together in a parent-child relationship, so you can select and view records from another database inside your current one.

  • Lookup Grid (pictured below): automatically lists the records in the other database that have the current record selected.
  • Lookup Select: a dropdown where users choose a specific record.

Lookup Grid showing related tasks on a record

Read the full guide: Database Lookup Fields.

User Lookup Field

User Lookup fields let users pick people from a dropdown on the record. You can limit the list to specific users, to users in certain groups or divisions, or to the groups chosen in a Groups Lookup field. Use them to send alerts, assign permissions, and make sure the right people know about a new task.

User Lookup field on a record

Read the full guide: User Lookup Fields.

Groups Lookup Field

The Groups Lookup field lets users select specific groups on the record. It's useful for assigning a new task to a whole team, or making sure a management group reviews a high-priority risk. Like User Lookup fields, it can auto-assign permissions, including on auto-created folders.

Groups Lookup field on a record

Read the full guide: Groups Lookup Field.

Resources Lookup Field

The Resources Lookup field lets users select assets directly from the Resources module to show in the record. The files keep the same permissions they have in Resources, and always show the latest version.

Resources Lookup field on a record

Read the full guide: Resources Lookup Field.

Note: The terms 'Database', 'Records' and 'Resources' are customisable, so they may appear differently in your platform. See the related terminology.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article