Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

Lists & data tables: how it works

Almost every list in the admin (invoices, customers, products, orders, expenses and so on) is the same kind of table. Once you know its toolbar you can search, filter, sort, choose columns and save your favorite views on any of them.

Lesson 4 of 15 · How it works

  • about 3 min
  • Sales → Invoices

How it works

  1. Type in «Search» above the list to find rows. Many lists also have «From date» and «To date» boxes and ready-made filter chips you switch on with one click.

  2. «Filters» opens «Advanced filters». Add conditions on any field of the list; all conditions must match. Active filters show as chips and «Clear filters» removes them.

  3. The «Columns & display» button lets you tick the columns to show, move them up or down, choose «Comfortable» or «Compact» rows and «Wrap long text». «Reset to default» undoes it.

  4. Some lists can be shown as a list or as a grid of cards with the «List view» and «Grid view» buttons.

  5. «Saved views A saved view remembers the search, filters, sorting and columns of a list under a name, so you get the same list back with one click. More words in the glossary» keeps the search, filters and sorting you have set under a name. Type the name in «Name this view…», press «Save», and pick it later from the same menu.

  6. Tick rows to select them. A bar appears with the actions that list allows for several rows at once, and with «Export Export downloads a list as a file: CSV or XLSX for Excel, or JSON for other software. Import loads records from a file into a list. More words in the glossary selected».

  7. Each row has an «Actions» menu for what you can do with that record. At the bottom you move between pages and choose how many rows a page shows.

Where to find it

Checklist

Before you move on, check that you can:

  • Open Sales → Invoices
  • Type in Search above the list to find rows.
  • Filters opens Advanced filters.
  • The Columns & display button lets you tick the columns to show, move them up or down, choose Comfortable or…
  • Some lists can be shown as a list or as a grid of cards with the List view and Grid view buttons.

Tips and common mistakes

  • The list looks empty? A filter or a saved view may still be active. Press «Clear filters», or «Clear search and filters» in the empty list.
  • Saved views belong to your login and follow you to any device. Column choices and row density are remembered in the browser, so set them again on another computer.
  • A view saves filters, search and sorting, not the ticked rows.