Skip to content
undb Docs

Lookup Fields

Lookup

Using a lookup field

Lookup fields are read-only fields. When creating a lookup field you can choose a ‘Link to table’ field in the same table and a field in the related table.

lookup-field

Start by creating a link to table field before using a lookup field.

To create a lookup field

  1. Click the plus sign + to the right of your existing fields or insert a new field next to an existing field.
  2. Select the lookup field type and input the name of the field.
  3. Select a link row field and a field to lookup.
  4. Click Create.

create-lookup

Count

The Count field is used to count the number of matching entries in the referenced table for the unique key (foreign key) referenced by the current row. It helps users to understand the usage of this unique key in the referenced table, and make correct data decisions accordingly.

count-field

Start by creating a link to table field before using a count field.

To create a count field

  1. Click the plus sign + to the right of your existing fields or insert a new field next to an existing field.
  2. Select the Count field type and input the name of the field.
  3. Select a link row field and a field to count.
  4. Click Create.

create-count-field