Browse documentation
All column types

Advanced column type

Link To Object

A Link To Object column connects a record in one table to records in another. It is the most important column type in Teambridge: workforce data is relational, and links are what make rollups, policies, scoped access, and cross table workflows possible.

Illustrative example

Connect records across tables: the relationship column everything else builds on.

  1. 01

    Table

    Shifts

  2. 02

    Field

    Assignee

  3. 03

    Purpose

    Link to the User working the shift; empty means open.

A suggested way to organize your information. This diagram is not a product screen.

When to use this type

  • 1A Shift linked to its assignee, role, and location.
  • 2A Document linked to its owner.
  • 3A User linked to eligible locations, clients, and restricted DNR sites.

Column ideas for your team

Shifts

Assignee

Link to the User working the shift; empty means open.

Users

DNR sites

Multi select link to restricted Locations.

Good to know

  • 1Use links instead of copying the same value into many places; one source of truth, everywhere it is needed.
  • 2Single select links point to one record; multi select links point to many. Choose deliberately.
  • 3Links power rollups: count or sum values from the linked records.