Skip to main content

Dashboards: Data Schema Widget

The Data Schema widget draws a solution's tables and the Linked Record, Lookup, Rollup, Count and formula relationships between them.

Written by Emma Montgomery

The Data Schema widget draws a map of a solution's tables and the fields that connect them: Linked Record, Lookup, Rollup, Count and formulas that reference other fields. Add it from the Widget Library under Utilities, pick the solution, and drag tables to arrange the diagram.

Plan Availability

All plan types.

Permissions

Administrators and Solution Managers add and configure the widget. Every member who can open the dashboard sees it, limited to the tables they can access.

Platform

Web, Mobile iOS, Mobile Android

Related Reading


What does the widget show?

Any table whose fields hold at least one relationship: a Linked Record, a formula that references another field, a Rollup, a Lookup or a Count. The widget detects these relationships across every solution, table and field you can access and draws them.

A Data Schema widget showing several tables joined by relationship lines.

How do I add the widget?

  1. Create a Dashboard view or open an existing one and set it to Edit.

A new Dashboard view being created.

  1. Click Add Widget in the upper-right corner.

  2. Under Utilities, click Data Schema.

The Widget Library with Data Schema under Utilities.

How do I choose the solution?

By default every solution in the workspace is drawn. In the widget settings, pick one solution in the Solution list to show only its relationships.

The widget settings with the Solution list open.

Which display options are there?

  • Links to other solutions: show or hide tables from other solutions that link into this one, for example a patient's appointment in one solution and the patient's account in another.

  • Fields shown: every field of each table, or only the fields that take part in a relationship.

The option to show links to other solutions.

The display format choice between all fields and related fields only.

A table card listing every field when all fields are shown.

Can I rearrange the diagram?

Yes. Drag solutions and tables to the arrangement you want.

A table being dragged to a new position in the diagram.

Does the widget show in the mobile app?

Yes. The widget is configured on the web and displayed in the iOS and Android apps with the same settings; tap the padlock to pan and zoom, or the expand icon for full screen. Details are in Mobile Dashboards: Data Schema Widget.


Frequently asked questions

The first question came from a conversation this month.

How do I export my schema for an external review?

Open a Data Schema widget for the diagram and export the dashboard as a PDF (Dashboards: Export to PDF). For a listing of each table and its fields with their IDs, open the solution's menu and choose API Documentation.

Which fields draw a line between tables?

Linked Record, Lookup, Rollup and Count fields, and formulas that reference another field. Member and Team fields do not draw lines.

Can I see tables I do not have access to?

No. The diagram includes only the tables you can access; tables you cannot open, and the lines to them, are left out.

Last verified 22 Oct 2026.

Did this answer your question?