Skip to main content
Version: 0.109.7 - Old UI



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).