In a record, a link column shows the rows of another table. Choose the view it uses and its display mode.
Contents
1. Why choose a view on a link column? 2. How do you select the view of a link column? 3. Which display mode should you choose? 4. Example: an annual review between employee and manager 5. What should you do in a mirror workspace? 6. Go further
1. Why choose a view on a link column?
The selected view decides which rows and columns of the linked table show in the record. It also applies its restrictions: read-only or invisible columns.
Each person sees and edits only what concerns them, based on their role.
2. How do you select the view of a link column?
You select it from the record, on the link column.
1
Set up the views of the linked table
3
Open a record
4
Select the configured view
5
Choose the display mode
For more comfortable entry: expand the record to full screen.
3. Which display mode should you choose?
The display mode sets how much information shows for each link.
Mode
What it shows
Best when
Label
Only the link title. This is the most concise display.
Many links, no detail
Tile
The title, the first column of the link and the three following columns.
A few links and few fields
Table
The linked table itself. This is the most complete display.
Many links and many fields
4. Example: an annual review between employee and manager
A review is filled in by two people. One view per role protects each person's part.
Employee view
The Manager column is read-only. Information the employee does not need is invisible.
Manager view
The employee's evaluation column is read-only. The manager completes their part.
Result
Each person fills in their part of the record without being able to change the other's.
5. What should you do in a mirror workspace?
In a mirror workspace, a link column with no selected view shows no data.
6. Go further
Go further
Restrict access to a column by view
Set each column to Read / Write, Read-only or Invisible.
Read more →
Go further
Link to another table
Create the link column between two tables.
Read more →
Go further
Create and use a mirror view
Share a prepared view in another workspace.
Read more →