Advanced column type
Link To Select Column
A Link To Select Column reuses the option list of a select column defined on another table. Instead of maintaining the same list of divisions or categories in five places, define it once and reference it everywhere it is needed.
Illustrative example
Reuse another table's select options so lists stay in sync everywhere.
- 01
Table
Shifts
- 02
Field
Division
- 03
Purpose
Reads the Division options defined on Users.
A suggested way to organize your information. This diagram is not a product screen.
When to use this type
- 1Sharing one Division list across Users, Shifts, and reports.
- 2Keeping category or classification lists consistent between tables.
- 3Centralizing option lists an admin updates in one place.
Column ideas for your team
Shifts
Division
Reads the Division options defined on Users.
Custom
Document type
Reuses the type list from the Documents table.
Good to know
- 1When an option list changes often, one linked source beats hunting down every copy.
- 2If each option needs its own fields or records, promote it to a collection and use Link To Object instead.