Linking Page Widgets#
One big reason for placing more than one widget on a page is that widgets can be linked. When linked, selecting a record in one widget will cause another widget to update and show only the data related to the selected record.
For example, let’s say you have a table of
Departments in a company, and a table of
Employees, with each employee tied to some department. You can have one Table widget listing
departments and serving as a selector for a second Table widget listing employees:
To create this, first create a page with a Table widget for
Departments data, as described in
Page widgets. Then in the “Add New” menu, select the “Add Widget to
Page” option to add another Table widget for
Employees data. In the widget picker, use the “Select
By” dropdown and choose the “DEPARTMENTS” widget added in the first step.
That’s all it takes: now selecting a department in the first table will cause the second table to
show only the employees in that department. Note that this relies on the
Emploeees table having a
column of type
Reference with the target table of
Departments. See Reference
Types of linking#
Linking widgets only works when there is some relationships between records in the underlying data. There are several kinds of relationships supported.
Most directly you can link two widgets which show data from the same underlying table, usually linking a Table to a Card. This allows you to select a record in the Table widget and see more details of that record in the linked Card widget.
For example, you can add a Card of
Employees data and link it to an existing Table widget
When you select a record in the table, the new “EMPLOYEES Card” widget shows a card for the selected record.
For another example of such linking, see the “Lightweight CRM” document in “Examples & Templates” and the Customizing Layout section in the associated tutorial.
As in the Employee-Department example, when one table has a reference to another (i.e. a column of type “Reference”), the second table can serve as a selector for the first. Essentially, selecting a record can automatically filter another widget to show only those records that refer to the selected record.
In the example shown earlier, the
Employees table has a “Reference” column pointing to the
Departments table, so a list of departments can serve as a selector for employees. When a
department is selected, only the employees in that department will be shown.
The “Lightweight CRM” document in “Examples & Templates” provides another example, where selecting a contact shows only the conversations with that contact. It’s also described in the tutorial.
When the target of linking is a Chart widget, you get dynamic charts that reflect data associated with the selected record. For example, you could link a pie chart to a department to show the sum of salaries for each job position in the selected department.
Whenever a table
A has a reference to
A can be used in place of
B as the source of
linking. Instead of considering the currently selected record in
A, linking will consider the
referenced record in
B as the selection.
For instance, a Table widget showing
Employees can serve as a selector for a Card widget showing
Departments, using the fact that an employee record contains a “Department” reference.
In the widget picker, if you select data from
Departments, you’ll see a “Select By” option
“EMPLOYEES • Department”:
When you select an employee, you’ll see the details of that employee’s department.
Multiple reference columns#
When a table that’s the target of linking has multiple reference columns, you may need to choose which one to use for linking.
For instance, a
Flight record might have fields ‘DepartureAirport’ and ‘ArrivalAirport’, each of
which is a Reference to the table
Airports. When you select an airport in a table, you can have
a choice whether to show all flights departing from this airport or all flights arriving to it.
The “Select By” widget will show both options to choose from:
Linking summary tables#
When widgets display summarized data, as described in Summary tables, they can also be linked to the underlying data, data that references the underlying data, and to other summary tables.
For example, you can summarize the table
Employees by job position, and include the count of
employees for each position, the average salary, or other summary data. You can also link the
Employees table to it, so that selecting a position shows all employees in that position.
Furthermore, you can link another summary table. For instance, you can summarize employees by position and gender, and link that to the summary by position. When selecting a job position, you can then see a summary by gender for that position. This is also convenient with charts.
In this example, you see a pie chart with the average salary for men vs women for the selected job position. As you click different positions, the pie chart updates to reflect the selected one.
More examples of such linking can be found in the Analyze and visualize tutorial.
Lastly, tables that reference a summary table’s underlying data may now be linked to the summary table itself. In the image below, the Champion Dog’s table has a reference column to the Breeder table. The Breeder table is being summarized in the top right widget by the “Country” column. Because Champion Dog references Breeder, you may add a widget of Champion Dogs that selects by a summary table of Breeder data.
Changing link settings#
After a widget is added, you can view and change its link settings from the right panel. One way to get to it is to click on the three-dots icon on the top right of the widget, and click on the “Data selection” menu option:
This opens the side panel, which shows what data is shown, and which widget, if any, serves as its selector.
You can change the “Select By” setting here, or click the green “Edit Data Selection” button, and change it in the widget picker dialog.