Copyright (c) 2023, Intercom, Inc. (legal@intercom.io) with Reserved Font Name "Inter".
This Font Software is licensed under the SIL Open Font License, Version 1.1.Copyright (c) 2023, Intercom, Inc. (legal@intercom.io) with Reserved Font Name "Inter".
This Font Software is licensed under the SIL Open Font License, Version 1.1.- Linked Record FieldSolution Owners can Sort and Filter linked records using any field in the linked Table… You can configure your Linked Record field so users can only create new records in the linked table,… No access to the linked table
- Linked records in shared viewsField permissions in the linked table do not hide these values: a Lookup still shows a linked field that… Viewers see linked record titles but cannot open them: clicking a linked record does nothing in the grid… Visibility of Linked Records in Shared Views
- Lookup FieldDisplay a field value from a Linked Record… No Linked Record field. A Lookup needs a Linked Record field in the table first… 1. Add a Linked Record Field
- Sub Items Field (Deprecated)Learn about the migration of Sub-Items to Linked Records… Sub-Items Will Become Linked Records… Why Linked Records Are Recommended Going Forward
- Reference data from other tables in a formulaReach fields in linked records with [Link].[Field] dot notation and reduce lists with SUM, COUNT, MIN, MAX, AVG or SUMIF… A formula can read fields from a linked record with dot notation: [Linked Record Field]… To reference a Linked Record field, use the field name in square brackets:
COUNT([Linked Record Field
- Connect tables within and across solutionsLink tables in the same solution or across solutions with a Linked Record field; SmartSuite mirrors the link in both tables… Connect two tables by adding a Linked Record field to one of them and choosing the other in Select Linked… The Linked Record field: Linked Record Field
- Link records across tables and solutionsLink records between tables, or across solutions, with a Linked Record field, then pull their data through with Lookup fields… Members see linked records only if they have at least Viewer access to the linked table… The Linked Record field: Linked Record Field
- Conditional Counts, Lookups, & RollupsFilter the linked records a Count, Lookup or Rollup field includes with Include Filters and conditions… All three read through a Linked Record field, so the two tables must be linked first, for example Projects… How do I count how many records are linked to this one?
- Dashboards: Data Schema WidgetThe Data Schema widget draws a solution's tables and the Linked Record, Lookup, Rollup, Count and formula relationships between them… Which fields draw a line between tables?… The Data Schema widget draws a map of a solution's tables and the fields that connect them: Linked Record
- Count FieldA Count field shows how many records a Linked Record field connects to, with optional filters, labels and colors… A Count field shows how many records are linked through a Linked Record field in the same table, and… Summarize linked records: counts the records connected through one Linked Record field