Set up the table

The table is the object list as you know it from Excel, but working on the actual records. Use it for a loan list, an insurance list or for checking after an import.

1. Open the view settings (cog on the right of the header) and choose the Text fields. They become the columns. Chosen File fields appear as columns with thumbnails in front.

2. Set the order of the columns by dragging in the view settings.

3. Drag the column width at the right edge of the column header (Change column width). The ✕ in the column header takes a column out (Remove column).

4. Drag the row height at the bottom edge of any row (Change row height). Taller rows show more text per cell.

Sorting

A click on a column header sorts in ascending order, a second click in descending order. You set up sorting on several levels, for example first by lender and within that by inventory number, in the Filter tab under Sorting. See Sort and group .

Edit values from the table

A click on a cell follows the same setting as in the gallery (Click on field (gallery)): by default it opens the object. To edit a single value, set the setting to Edit field or use the pencil button Edit in the cell. A small window opens with the same input as in the object view, with the same colour feedback when saving.

For subfields, such as the place in an address, the input of the field they belong to opens.

Tried and tested combinations

The inventory number as the first column is almost always worth it. It is how you talk to others about a row.

Together with other views

The sidebar and the workspace each show a view of their own:

Further reading

• Table : full reference
• Excel export : when the list leaves the institution