Tables

Your data, with structure.Your work, in every view.

Build structured tables with typed fields, relationships and formulas. Explore the same records in different views, collect input with forms and turn data into useful dashboards.

Tables

A field for every kind of information.

  • Typed fields and validation
  • Grouped filters and sorting
  • CSV and spreadsheet import
Discover the details
Leads — #salesGrid · 16 types
CompanyTextDeal €NumberStageSelectCloseDateWonCheck
Northwind12,400New24 Jul
Acme GmbH12,4kNumbers onlyQualified02 Sep
Globex8,900Won30 Jun
Initech3,150Qualified11 Aug

New column

Pick a type

TextNumberSelectDatePersonRatingFormula
4 records · sorted by Close1 validation error
Product preview · illustrative content

01 / Structure

A field for every kind of information.

Define columns for the data you actually use. Edit records in the grid, open a row for its details and filter with grouped rules.

  • Typed fields and validation
  • Grouped filters and sorting
  • CSV and spreadsheet import
Leads — #salesGrid · 16 types
CompanyTextDeal €NumberStageSelectCloseDateWonCheck
Northwind12,400New24 Jul
Acme GmbH12,4kNumbers onlyQualified02 Sep
Globex8,900Won30 Jun
Initech3,150Qualified11 Aug

New column

Pick a type

TextNumberSelectDatePersonRatingFormula
4 records · sorted by Close1 validation error
Product preview · illustrative content

02 / Relationships

Connect records. Calculate the rest.

Link records across tables and use formulas, lookups and rollups to work with those relationships. Open the schema diagram to understand how the data fits together.

  • Linked records
  • Formulas, lookups and rollups
  • Relationship diagram
Orders — #salesFormula · Lookup · Rollup
OrderTextCustomerLinkQtyNumberTotal €FormulaRegionLookup
SO-1042Acme GmbH124,464.00Berlin
SO-1043Nordwind+13741.60Vienna
SO-1044Acme GmbH82,976.00Berlin
3 recordsΣ 23Σ 8,181.60
Total € — formulaComputed server-side
ROUND(qty * unit_price * 1.2, 2)
IFDATEDIFFCONCATROUND+ more functions
Product preview · illustrative content

03 / Views & automation

The same records. A different perspective.

Use grid, Kanban, calendar, timeline, gallery, chart and other views to match the question. Apply row permissions and connect record changes to Flows.

  • Multiple views of one data source
  • Row-level permissions
  • Record-triggered workflows
Table settings — Projectsmanage_tables
Row permissionsServer-enforced

Who can edit rows

Everyone with edit accessOnly the row's owner

Who can see rows

All channel membersOnly the row's owner
Owner columnOwner — Person
Row triggersFlows
New row createdRun flow: DM the owner
Status → DonePost in #projects
Any row changedEmail the owner
Product preview · illustrative content

Tables

More of what your day needs.

01

Task view starters

Build table views around task data and dashboard metrics.

02

Forms

Collect structured submissions with a configurable form.

03

Update through import

Re-import an export and match existing rows by their IDs.

04

Dashboards

Use chart and metric blocks in connected Studio pages.

A closer look.

Do views duplicate my records?

No. Views present the same underlying records with different layouts, filters and settings.

Can a table work with task data?

Task bindings and view starters connect task data to table views. Available editing depends on the bound fields and your permissions.

Tables

See it with your team in mind.

Let’s walk through the way your team could work in Polybase.