•••
 
Documentation   /   Data Studio   /   Document datasets
 
 

Document datasets

 

A document dataset has one row per document, from the templates you choose.

Adding columns

Click New column, choose what the column shows, and name it. The name becomes the column's key in the live data feed, so use short lowercase names such as counterparty_name or salary.

A column can show:

  • any variable from the templates, such as salary or notice_period
  • a value saved with [[VAR=...,save:true]]
  • a document field, such as:
Field Contains
Document key The document's unique key
Counterparty, address The counterparty's name and address
Signatory name, job title, email Who's signing for the counterparty
Start date, end date The document's dates
Accepted at; accepted by name, title, email, IP When and by whom it was signed or submitted
Locked at, sent at, sent to When it was locked and sent, and to whom
PDF download, PDF upload Links to the PDF
Amended, signed version Whether the wording was amended, and the version signed
Is private Whether the document is private
Folder name The folder it's saved in
Template title The template it was created from

Use Reorder to change the column order.

Filtering, sorting and calculations

  • Filter on any column, using the match types for data feeds. These include date ranges such as last_30 and previous_90.
  • Sort on any column.
  • The live data feed can return a single figure: the max, min, count, sum or avg of a column. See API: Live data feeds.

Example: a contract register

Build a document dataset from your supplier contract templates with the columns document_key, counterparty_name, start_date, end_date and contract_value. Sort it by end_date up to list the soonest renewals first, then show the feed on a dashboard with a table widget. See Dashboards and widgets.