Skip to main content
Version: 0.109.7 - Old UI

Lookup

Lookup​

Example organization structure​

Consider an organization with

  • 5 departments (company departments), each department has a team name & associated team code. Each Team has many Employees - relationship has been defined using LinkToAnotherRecord or Linkscolumn

  • 5 employees working at different departments

Screenshot 2022-09-09 at 12 57 32 PM

Now, let's explore procedure to retrieve team-code information in Employee table using LOOKUP columns

Configuring a lookup column​

1. Add new column : Click on '+' icon to the left of column headers in Employee table​

2. Feed column name​

3. Select column type as 'Lookup'​

4. Choose child table​

5. Select child column​

6. Click on 'Save'​

Screenshot 2022-09-09 at 12 21 13 PM

Required information is now populated in the newly created column

Screenshot 2022-09-09 at 12 26 06 PM

Additional notes​

  • Nested 'Lookup' supported: a Lookup field can have its child column datatype as Lookup (or Rollup).