Skip to main content
Version: Latest

Lookup

Lookup fields help bring additional field information from related table into the current table. This is useful when you want to display additional information about a record in a table. For example, if you have a table of Orders and a table of Customers, you can use a Lookup field to display the customer's name and address in the Orders table.

note
  • Lookup fields are read-only. You cannot edit the values in a lookup field.
  • Lookup fields are available only for Belongs-to relational links in hosted cloud version. The additional processing complexity for Has-many and Many-to-many relational links outweighs the benefits of having lookup fields for these links. OSS will continue to support lookup fields for all relational links.

Create a Lookup Field​

  1. Click on + icon to the right of Fields header
  2. On the dropdown modal, enter the field name (Optional).
  3. Select the field type as Lookup from the dropdown.
  4. Select the link field from the dropdown. This is the field that links the current table to the related table.
  5. Select the field for display from the dropdown. This is the field that will be displayed in the current table.
  6. Click on Save Field button.

image