Skip to content

Help Center · Everyday use

How to use Data Tables

A Data Table is your own spreadsheet-style list of cases: you choose the columns (any client, case, court date, appointment, custom or intake field) and which cases appear. Then you can search it, sort it, group it into separate tables (for example one per attorney), edit cells right in the table and download it as a CSV or PDF.

Time needed: about 6 minutes.

Before you start: anyone can make a personal table. Firm Wide tables are seen by everyone at your firm; their columns and saved views can be changed by the person who made them, the firm’s owner and administrators, and staff with permission to edit firm-wide data tables.

Step 1

Create a table

Click Data Tables in the left menu. The page lists your tables, with who sees each one; search them, or click Firm-wide or Only me to narrow the list. Click Open to open a table, or ⋯ to rename it or change who sees it, Duplicate it or Delete it.

To make a new one, click + Create New View. Give the table a name and choose Personal View (only you see it) or Firm Wide View (everyone at your firm sees it). Click Create View.

The Data Tables page: search views, All, Firm-wide and Only me, each table with who sees it, Open, and the more menu with Rename or change who sees it, Duplicate and Delete
Create New View: a name for the table and who sees it (Personal or Firm Wide), then Create View

Step 2

Choose the columns

Click + Columns. Open a section (Personal Information, Case Type, Case Information, Status, Court Date, Appointments, Deadlines, Tasks, and your custom and intake fields) and tick the fields you want as columns. The number next to a section shows how many you’ve ticked. Click Save Columns & Filters.

Each matter gets its own row, so a client with two matters (for example a bankruptcy and a personal injury case) appears twice.

Configure Columns & Filters: Personal Information, Case Type, Case Information, Status, Court Date, Appointments, Deadlines and Tasks, then your custom and intake fields

Step 3

Narrow down which cases appear

Under the fields of a section you’ll find its filters: for example only Bankruptcy cases, only some statuses, or only the cases of one attorney or case analyst. Leave them all unticked to see every case.

Filters under each section: for example only some case analysts or attorneys

Step 4

Keep an eye on deadlines and tasks

Under Deadlines, tick columns such as Next Deadline, What’s Due, Days Left, Deadline Status, and the number of Open Deadlines and Late Deadlines. Under Show only matters, choose for example With an open deadline, With a late deadline or Deadline in the next 7 days (or late).

Under Tasks, tick Next Task Due, Next Task, Task Assigned To, Open Tasks or Overdue Tasks.

In the table, click View next to the number of open deadlines to see them, with their tasks and linked documents.

Tip: to add or change deadlines, see Case deadlines.

The Deadlines section: Next Deadline, What's Due, Days Left, Deadline Status, Open Deadlines and Late Deadlines, and Show only matters With an open deadline
A table filtered to matters with an open deadline: the next deadline, what's due, days left, its status, and the number of open and late deadlines with a View button
Open deadlines for Sofia Ramirez: the date, what's due, who added it, its task and linked documents, with the Deadlines page and Open the client's deadlines

Step 5

Search the table

Type in Search this table to show only the rows that contain it, in any column. The count on the right shows how many rows match, for example 3 of 9 rows. Click the × to clear it.

Search this table: typing bankruptcy shows 3 of 9 rows

Step 6

Sort it

Choose a column in Sort by and the direction, and a second column in then by for rows that tie: for example by court date, then by client name. You can also click a column heading (click again to reverse). Dates sort by date and amounts by value, and empty cells always go last.

Sort by Event Date, then by Client Name; the sorted column is darker with an arrow

Step 7

Group it into separate tables

Choose a column in Group by, for example Attorney Assigned, Case Type or Client Status. Each value gets its own table with a gap between them, and the rows without one come last (for example No attorney assigned). Next to it, choose the order of the groups: A–Z, Z–A or Biggest groups first. Click Hide on a group to fold it away.

Grouped by Attorney Assigned: a separate table for each attorney, and No attorney assigned last

Step 8

Read the colours

  • Case type and status show as coloured pills, the same colour in every table: for example Bankruptcy purple, Immigration green; Filed and Discharged green, Dismissed red.
  • Attorneys and case analysts have a circle with their initials.
  • Court dates, appointments and Schedules Due by carry a small tag: red when it’s today or within 7 days (in 3 days), amber within 30 days, grey for past events (107 days ago), and red overdue for a schedules due date that has passed.
Grouped by case type: coloured group headings, case type pills, initials and a days-ago tag on a past court date

Step 9

Save it as a view

When the sort or grouping on screen isn’t one of the table’s saved views, Save View appears at the top right. Click it, type a name (for example By case type) and click Save. Saving with the name of a view that already exists updates that view.

The view appears as a pill in the Views row above the table. Click a pill to switch the table to it, or Standard for the table as listed and not grouped. The pill you’re looking at is filled in.

  • The ★ marks the view the table opens in, for everyone. On the view you’re looking at, click ☆ to make the table open in it.
  • To remove the view you’re looking at, click its ×, then Remove?.

Everyone who can see the table can use its views; saving and removing them is for those who can change the table.

Save View: name the view, then Save
The Views row: Standard, By attorney (the star: the table opens in it) and the new By case type view

Step 10

Change a value right in the table

Click a cell to change it, for example a status, case analyst or date. Choose or type the new value and it saves straight away, just as if you’d changed it on the client’s page. Press Esc to cancel. Client names and court dates are changed on the client’s page: click the arrow at the end of a row to open it.

Click a cell to change it right in the table: here a client status

Step 11

Download it

Click CSV (for Excel or Google Sheets) or PDF. The download has the table’s rows sorted and grouped as you see them on screen.

CSV and PDF download buttons

What’s next

Keep going

To change a table’s name or who sees it, click Edit Info; to change its columns or filters, click + Columns. For firm-wide numbers and charts, see Reports. All guides are in the Help Center.