# Tables

<p class="callout info">Table pages consist of the filters, table actions, table headers, table rows and pagination.</p>

![image.png](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-07/scaled-1680-/k0pimage.png)


### Table columns

You can customize the way you see a table, by opening the "visible columns" section and selecting or deselecting, which columns should be visible.

<p class="callout info">After changing the visible columns selection, the table needs to be refreshed.</p>

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-07/nmooutput.gif)

Some tables have a lot of columns, so searching was added to allow you to quickly find the column you need.

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-07/JIRoutput.gif)

### Table filters

Most table columns can be used in filters. When you click the **"funnel"** icon next to the column name, a filtering form is added to the filters section.

<p class="callout info">Filters include text filters, dropdowns, Yes/No filters, date filters,...</p>

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-07/fzRoutput.gif)

<p class="callout info">After every change in the filters section, the filters need to be re-applied.</p>

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-07/RWZoutput.gif)

<p class="callout info">When you have applied filters, their count will appear next to the **"gear"** icon.</p>

### Table search

Table search allows for quick and simple searching by word through the entire table.

If you have **applied table filters** and you **use table search,** the search will only find **records** that **match both** filters and search.

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-07/6iGoutput.gif)

<p class="callout info">If a record is not shown in table during search, it has to be saved through the update form again.</p>

### Table actions

<p class="callout info">Every table has **action buttons,** that are used to **add, delete, print, export or import records** in table.</p>

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-07/zDtoutput.gif)

- **Add new**
    - Link to the create form the a new record.

- **Import from Excel/CSV file**
    - Upload a formatted excel or CSV file to import records.

- **Export to Excel**
    - Export table to Excel. This action **uses applied filters and search** during export.
    - If no filters are applied, this action will attempt to export the entire table.

- **Export to ZIP**
    - Export selected records to ZIP. Used to bulk export PDFs.

- **Print selected items**
    - Generate default PDF prints for selected records.

- **Delete selected**
    - Delete selected records from the table.

<p class="callout warning">**Actions,** such as **"Add new"** and **"Delete selected"** are **locked with permissions.**</p>

### Records

<p class="callout info">Table records are the main part of this view, it's where all the data is displayed.</p>

![image.png](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-08/scaled-1680-/Qozimage.png)

The table consists of selected visible table columns. Most tables have an **'Actions'** columns, where users can open and/or delete records.

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-08/YPboutput.gif)

<p class="callout info">Some tables (*eg*. *contacts*) also have **"details rows".** These can be opened by clicking the "**+**" before the checkbox.</p>

### Batch editing

By checking a row, you can select one or more records. You can edit multiple selected rows at once by clicking the "edit" icon next to the column's name.

<p class="callout warning">Batch **editing is not advisable,** as updating multiple records at once could lead to complications.</p>

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-08/zT1output.gif)

<p class="callout info">Each **table can be sorted by** any of its **columns,** but only by a **one** **at** **a** **time**. </p>

To apply sorting, simply click on the column name and the arrow that appears next to it will indicate, if you are sorting in an ascending or a descending order. To switch between these two, just click on the column name again.

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-08/kt2output.gif)

To reset sorting for the current table and reapply default filters, click the **"Reset filters and sort"** button. To reset visible columns of table back to the default configuration, click the **"Reset visible columns"** button.

![image.png](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-08/scaled-1680-/kwtimage.png)


### Table pagination

The table pagination can be edited through the toolbar under the table. You can move by a single page at a time or jump to last/first page.

![output.gif](https://how-to-erp.dewesoft.com/uploads/images/gallery/2025-08/JbAoutput.gif)

<span style="font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Oxygen, Ubuntu, Roboto, Cantarell, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400;">You can set count of records, shown per page (5, 10, 25, 50, 100). A count of all records in the table (*<span data-v-fcc20bbd="">Showing **1 to 10** of 252 entries</span>*) is shown on the left.</span>