# The table editor

> Browse a project's tables and work its data in a grid - columns, row tools, paging and validation.

The **table editor** is where most work in Manage happens. It has two panels: a
**table panel** on the left for choosing what to work on, and the **data grid** on
the right for working it.

## The table panel

Two tabs sit at the top:

- **Tables** - every table in the project, each with a **record count**. Search
  with **Search tables...**, and use the eye toggle to show or hide **empty
  tables** (hidden by default, revealed automatically when you search).
- **Views** - your saved [views](/manage/table-editor/filtering-sorting-views), a
  **Pro** feature.

A **locations filter** above the list narrows the whole editor to specific
locations or a location group. At the foot of the panel, the **validation**
indicator runs your quality checks - see
[Validation](/manage/table-editor/validation).

## The data grid

Select a table and its records load into the grid:

- **Columns** come from the table's fields; **resize** them by dragging a border,
  and **pin** them left or right. A **breadcrumb** shows the parent chain for a
  child table, and the **Layout** dialog lists every column as a reference.
- **Hover** a column header to see its **AGS heading** beside the field's name,
  for example **Geology code GEOL_GEOL**.
- Edit data inline or through the row editor - see
  [Editing records](/manage/table-editor/editing-records).
- The grid loads a page at a time and shows a count like **Showing 1-50 of 240
  rows**; choose a page size (10 to 250; 50 by default) and move through with the
  pager.

## Row and location tools

Alongside the data columns, each row has a few **action columns**:

- **Flags** - flag a record with a note, a priority and a resolved status. Works
  on every table; review flags across the project on the [Flags](/manage/flags)
  screen.
- **Media** - the photo and document indicator. It shows a count; click it to
  preview the attached media and **Upload** more. See [Media](/manage/media).

On the **samples** table you also get:

- **Testing** - a flask icon on any sample that is on a testing schedule or chain of
  custody: **amber** while it is out for testing, **green** once its results are
  back, **grey** when it has not been sent yet, and **red** when it is marked missing
  (unless it is out at a lab on another schedule). A number shows when the sample is
  on more than one schedule. Click it to see each schedule (status, lab, PO, lab
  receipt ref and any receipt issue, tests and file count), its chains of custody,
  and a dated timeline of everything that has happened to the sample. Click a
  schedule reference to open that schedule.
- **Handle with care** - a shield column to flag a sample
  [handle with care](/manage/lab-workflow/testing-schedules#handle-with-care) with a
  note, or clear the flag. It saves straight away.
- A **Disposed** tag on samples that have been
  [disposed of](/manage/lab-workflow/sample-retention).

If you start editing a sample that is out for testing, a one-off warning reminds you
which schedule it is on, because the lab matches its results back using those
values. It does not stop you making the change.

On the **Locations** table you also get:

- **Completion status** - whether each location (hole) is finished.
- **Export preference** - a per-location override of the log and depth used when
  that location is exported. See
  [Export preferences](/manage/table-editor/export-preferences).
- **Sign-off** - where each location is in
  [checking and approving](/manage/logs-and-sheets/checking-and-approving): the
  same coloured dot as on Logs & Sheets with its round (**R1**, **R2**), ringed amber
  when an approved log's data has been edited since. Hover it for the status, the last
  step and whose step is next; click it to open the location on Logs & Sheets, on its
  Sign-off tab. It shows when your company uses sign-off, and **Columns** hides it.
- **Map placement** - toggle a column of the internal coordinates used to place a
  location on the map when survey coordinates are not available.

## Working with selected rows

Tick rows to select them and the toolbar offers **Edit**, **Bulk update**,
**Delete**, **Create location group**, **Open log** (on
[Logs & Sheets](/manage/logs-and-sheets)), and PDF export. With sign-off in use,
**Submit N for checking** sends the selected locations that aren't in yet as one
batch. See
[Editing records](/manage/table-editor/editing-records) and
[Exporting PDF logs](/manage/table-editor/exporting-logs).

## In this section

<Cards>
  <Card title="Editing records" href="/manage/table-editor/editing-records">
    Add, edit and bulk-update records, and the field types you enter.
  </Card>
  <Card title="Filtering, sorting and views" href="/manage/table-editor/filtering-sorting-views">
    Narrow and order the grid, and save views to reuse.
  </Card>
  <Card title="Validation" href="/manage/table-editor/validation">
    Run quality checks across the project and fix the issues.
  </Card>
  <Card title="Exporting PDF logs" href="/manage/table-editor/exporting-logs">
    Export borehole and trial pit logs for selected locations.
  </Card>
  <Card title="Export preferences" href="/manage/table-editor/export-preferences">
    Set which log template and depth scale each location uses.
  </Card>
</Cards>
