Skip to main content

Linked Record Field

Link records across tables: display formats, the linked table, options, filters, defaults and using links in views and formulas.

Written by Emma Montgomery

Feature Overview Videos

A Linked Record field connects a record to records in another table. Think of a vendor's page with its contracts listed on it, each one a live link to the contract itself.

Here is the test: does this record need to point at something that has its own record? If yes, you want a Linked Record field.

Example: a Vendors table in a vendor risk program, with a field called Contracts. Each vendor links to its contracts in the Contracts table. Open the vendor and every contract is one click away.

The Contracts field in a vendor record, showing two linked contracts as Compact cards with their titles.

The Contracts field in a vendor record, showing two linked contracts as Compact cards with their titles.

Plan Availability

All plan types. Linked Record fields per table: 30 on Team, 50 on Professional, 100 on Enterprise and Signature.

Permissions

Administrators and Solution Managers can create, modify and manage Linked Record fields. Solution Creators can do so only in solutions they manage.

Platform

Web

Related Reading


Adding a Linked Record Field Type

  1. In Grid View, select the + at the right end of the column headers. From an open record, select + Add new field to this Table at the bottom instead.

  2. Select Linked Record. You can type to search the list of field types.

  3. Name the field. In this article it is Contracts. A field name can hold up to 50 characters, and there is no restriction on the characters it can contain.

Tip: Name the field for what the linked records are to this table, such as Contracts, not for the table it points at. People read the name in the record, where the table is already clear.

The field settings panel opens. It has three tabs: Settings, Defaults and Help Text. The rest of this article takes them in that order. Save at any point with Add Field (or Update Field on a field that already exists) and come back to the other tabs later.

The field settings panel, Settings tab, with Display Format, Linked Table, Options and the Advanced Settings button.

The field settings panel, Settings tab, with Display Format, Linked Table, Options and the Advanced Settings button.


Settings

The Settings tab holds the table you link to and the rules around the link. Top to bottom: Display Format, Linked Table, Options and Advanced Settings.

Display Format

How the linked records look in a record and in views. Open the preview box to see a sample of each.

  • Compact Display (the default): a small card with the record's title.

  • Simplified Display: a card with the fields you choose.

  • Standard Display: a plain pill with the title.

  • Expanded Display: a card with the fields you choose, each with its field name beside the value.

  • Table Display: the linked records as rows in a grid, with the fields you choose as columns.

Use Standard Display when a vendor has many contracts and you only need their names. Use Table Display when people compare contracts side by side, such as their values and end dates. Which fields the cards and the grid show is set under Advanced Settings, below.

Table Display adds two switches: Allow editing records inline and Allow creating new records inline. They let a Solution Manager decide whether people can change linked records, or add new ones, from the grid in the record.

Linked Table

The table the field links to. The dropdown starts on the current table. Open it and the tables of the current solution are listed first, then the tables of your other solutions under their solution names. Only solutions you have access to are listed. Type in the search box to find one. For Contracts, pick the Contracts table.

Note: Once records are linked, the linked table cannot be changed. To link somewhere else, add a new field.

Options

Three switches, and a fourth that appears only while the linked table is the same table. Each one is a rule for the people who fill in records.

Allow linking to multiple records. On by default. A vendor can link to any number of contracts. Turn it off when each record may link to one record only, such as a contract that belongs to one vendor.

Require an entry in this field. Off by default. On, a record cannot be saved until at least one record is linked. Turn it on when a blank means something is missing.

Enable the Sub-items mode. Off by default. On, people can only create new records in the linked table from this field; they cannot pick existing ones. Use it for records that belong to this record alone, such as the findings raised in one audit. Leave it off for Contracts, where a contract exists before it is linked.

Note: With Enable the Sub-items mode on, unlinking a record deletes it from the linked table. It is not a way to tidy a list of existing records.

Create a backlink. Shows only when the linked table is the same table as the field's own, so it is not in the picture above. On by default; it adds a matching field so the link shows from both sides. A link to another table, such as Contracts, always creates the matching field in that table. The matching field can be deleted afterward, and the link then shows from one side only.

Advanced Settings

The Advanced Settings button opens a modal. The left side shows a live preview of the linked table's records with your settings applied. The right side has two tabs, General and Filters. Save with Save Changes.

The Advanced Settings modal, General tab, with the preview on the left and Fields to Display open on the right.

The Advanced Settings modal, General tab, with the preview on the left and Fields to Display open on the right.

General. The same Display Format as the main panel, then View Configuration with three controls.

  • Fields to Display: which fields of the linked table appear on the cards or in the grid. The Primary Field is selected to start. Pick from Available Fields and select Done. For Contracts, add End Date and Annual Value. When the linked table has a Files and Images field, a COVER option appears here, so each card can show a picture.

  • Sort: the order of the linked records. Add a row, pick a field and choose A → Z or Z → A. Sort Contracts by End Date so the next renewal is first.

  • Group By: group the linked records by a field, with Collapse ALL to start the groups closed. Group Contracts by Status to separate active from expired.

Tip: Keep Fields to Display to the two or three fields people compare, and sort by the one they look at first. The preview on the left of the modal shows the result before you save.

Filters. Preset filters narrow which records the selector offers.

  • None (the default): every record in the linked table can be picked.

  • Static: fixed filters you build in advance, shown as tabs in the selector. People pick one tab at a time. An All tab appears as soon as static filters are on, so every linked record stays reachable even when a filter tab shows none.

  • Dynamic: dropdowns built from fields of the linked table, so people filter on the spot. Only supported field types are offered, such as Status, Single Select and Assigned To. The person building the field picks which fields become dropdowns, and each person's choice changes only what they see, not what others see.

Both kinds change what the selector shows, not what is linked. A static filter "Status is Active" keeps expired contracts out of the picker without touching existing links.


Defaults

Default Value picks the record every new record starts linked to. Open the dropdown, search, check one record (or several when multiple links are allowed) and select Done.

The list shows record titles and loads more as you scroll. Once there are more than five records, a search box appears, and it searches every record in the linked table, not only the titles already loaded.

Note: Defaults apply to new records only. Records that already exist do not change when you set or change a default. If a record used as the default is later deleted, the field goes back to no default value.

Use it where most new records link to the same thing, such as a standard master agreement. Contracts has no default, because each vendor's contracts differ.

A button's Create a Record action and a form can each set their own default for the field. Both also offer Originating Record, below.

Originating Record (buttons and forms)

Originating Record links a new record back to the record it was started from. It is set on a button or a form, not on this tab.

Example: a vendor record has a button whose Create a Record action adds a contract. In the action's default values, the contract's Vendor field is set to Originating Record. Select the button on a vendor and the new contract opens already linked to that vendor.

Where to set it:

  • Button, Create a Record action: in the action's default values, add the Linked Record field and choose Originating Record.

  • Form: in the form, open the Linked Record field, go to its default values and choose Originating Record.

Originating Record is first in the default value list, above a divider. It is not offered in the Linked Record field's own Defaults tab.

Note: On a form, Originating Record works only on an internal form that a button on a record opens. An info icon next to the option says so. A form cannot tell in advance how it will be opened, so the option is always offered; when there is no originating record, it has no effect.


Help Text

A note for the person filling in the record, up to 800 characters. Help Text Appearance shows it As A Tooltip (the default, behind an info icon next to the field name) or Below The Field Name (always visible).

Write it for someone who has never seen the field. For Contracts: "Link every signed contract with this vendor. Create the contract record first if it is not in the list."


Permissions

Three things decide who can work with a Linked Record field.

Field Permissions. Every field can carry its own permissions, which control who can see the field and who can edit it. Open the column menu and select Edit Field Permissions. Use it when the link itself is sensitive, such as a Contracts field that Procurement edits and everyone else only reads. See Field Permissions.

Access to the linked table. A member needs at least Viewer access to the linked table to open a linked record. Without it, the vendor's contracts show as titles that cannot be opened. Members with Assignee+ permission in the linked table can create records from the selector and see the records assigned to them. A link does not bypass security. Solution, table, field and record permissions in the linked table apply to every link, so a member who cannot edit a record in its own table cannot edit it through this field either.

Dynamic Record Permissions. A Linked Record field can also drive record-level rules: who can see or edit a record based on the value it holds. Every field type except Button can drive a rule. See Dynamic Record Permissions.


Using the field in views and records

Once vendors are linked to their contracts, the link works in both tables.

In a record. Each linked contract shows as a card; select its title to open the contract. With Table Display, edit a linked contract's fields in the grid itself: select a cell, change it and press Enter. See Link records across tables and solutions for the full picture, from the selector to cross-solution links.

Filtering

Filter by the records the field holds, by text in their titles, or by is empty and is not empty. "Contracts is empty" lists every vendor with no contract on file.

Grouping

Group a view by the field and a record appears under every linked record it holds. Group a Contracts view by Vendor and each vendor becomes a group with its contracts under it.

Sorting

Sort A → Z or Z → A from the column menu. Records order by the titles of their linked records.

Counting and rolling up

A Count field on Vendors counts the linked contracts. A Rollup field adds up or summarizes a field in the linked records, such as the total value of a vendor's contracts. A Lookup field shows a field from the linked record, such as each contract's end date, on the vendor. See Count Field, Rollup Field and Lookup Field.

To find the vendors with at least one qualifying contract, give the Count field Include Filters, such as Status is Active. Then filter Vendors on that count greater than 0. Each vendor shows once, however many of its contracts match. See Conditional Counts, Lookups, & Rollups.

Formulas

A formula reaches through the link with a dot. [Contracts].[Annual Value] is the Annual Value of every linked contract. Because a vendor can hold several contracts, the result is a list, so wrap it in a function that handles a list:

SUM([Contracts].[Annual Value])

COUNT([Contracts]) gives the number of linked contracts. See Reference data from other tables in a formula.

Automations

An automation can write into the field. To link several records at once, separate them with a semicolon. An automation can also start from a change in the field, such as a new contract linked to a vendor. See Automation Actions explained.

Forms

Add the field to a form and the person filling it in picks a record from the linked table. A default set on the form overrides the field's own default inside that form. A form opened from a button can also use the Originating Record default, set out under Defaults above. See Form View.


Editing a Linked Record field

Link a record. In a record, select + Add Link to under the field; the button names the linked table, such as + Add Link to Contracts. In Grid View, select the cell and press Enter. The record selector opens with a search box, + Add New Record and a gear for the selector's own fields, sort, filters and groups. Check the records and select Link Records.

The record selector open from a Grid View cell, with the search box, Add New Record, the gear and two contracts checked.

The record selector open from a Grid View cell, with the search box, Add New Record, the gear and two contracts checked.

Unlink a record. Hover over the linked record and select the x. With Enable the Sub-items mode on, the icon is a trash can and the record is deleted, not only unlinked.

Change the display format. Open Modify Field Settings, pick another format, then Update Field. The links do not change, only how they look.

Change the fields shown. Open Advanced Settings, General, and change Fields to Display. Switching display formats can reset which fields are visible, so check them after a switch.

Delete the field. Open the column menu and select Delete Field. Deleted fields stay in the Recycle Bin for 14 days on a trial, 30 days on Team, 45 days on Professional, and 60 days on Enterprise and Signature.

Note: Deleting a Linked Record field breaks every link it held. The linked table keeps the values as text, not as links.

Watch: Linked Records: Dynamic Default Values (2 min) sets Originating Record on a form and on a button's Create a Record action, using a policy exception request opened from a policy.


Frequently asked questions

How many records can one cell link to?

There is no limit on the number of linked records in one cell. The per-table limit is on the number of Linked Record fields, by plan.

Why does the linked record show but not open?

The member does not have Viewer access to the linked table. Ask the solution's manager to grant it.

How do I prefill a Linked Record field on a form a button opens?

In the form, set the field's default value to Originating Record. When a button on a record opens the form, the field arrives linked to that record. Opened any other way, the option has no effect.

Can I link to a table in another solution?

Yes. The Linked Table dropdown lists your other solutions under their names. Solution permissions apply across the link.

What is the difference between Enable the Sub-items mode and a normal link?

A normal link picks existing records or creates new ones. Sub-items mode only creates new ones, and unlinking a record deletes it. Use it when every linked record belongs to this record alone.

Why can I not see Add New Record in the selector?

Creating records from the selector needs Assignee+ permission in the linked table.

Should I use a Linked Record field or a Sub Items field?

Use a Linked Record field. Sub Items is deprecated, and a linked table works in reporting, automations and other fields.

Need more help? Ask the SmartSuite Community, where builders, administrators and the SmartSuite team answer questions about building on SmartSuite. For your account, billing or data, select the chat button in the lower-right corner of SmartSuite to reach support.

Last verified 10 Nov 2026.

Did this answer your question?