Leaving Airtable? Bring your bases to Artavolo, checked record by record. See how

Use the Grid view

Updated

The Grid view shows one record per row and one field per column, like a spreadsheet. It is where most tables start, and the fastest place to type in a lot of data.

A Tasks table in the Grid view with Status, Priority, Owner, Due, Estimate, Progress, Tags and Campaign fields

Edit cells

  • Click a cell and type, or press Enter to edit what is there. Escape drops the change.
  • Copy and paste whole blocks of cells, to and from Excel or Google Sheets.
  • Ctrl+Z undoes the last change; the arrows at the end of the tab bar undo and redo too.

Open a record

Press Space on a cell, or the expand icon beside the row number, to open the record. You see every field, including the ones this view hides, and the record's Activity: its changes and comments. Type @ in a comment to mention someone; they get a notification. The arrows at the bottom move to the previous and next record.

An open record, Design hero banner, with its fields on the left and the Activity panel with a comment box on the right

Use the record menu

Right-click a row for its menu: expand, comment, select, insert a record above or below, duplicate, copy, paste and delete.

The menu of a record: Expand record, Comment, Select record, Insert record above, Insert record below, Duplicate record, Copy, Paste and Delete record

Add and remove

  • Add row under the last record adds one. Inside a group, the + in the group's header adds a record that already belongs to it.
  • The + after the last field adds a field.
  • A deleted record goes to the trash for 30 days.

Read the summaries

The row under the last record summarises each field. Click it to choose: sum, average, median, minimum, maximum or range for numbers, and empty, filled, unique, percent empty or percent filled for any field.

The summary menu under the Estimate field: None, Sum, Average, Median, Min, Max, Range, Empty, Filled, Unique, Percent empty and Percent filled

Shape the view

The bar above the grid holds Hide fields, Filter, Group and Sort, Color (colour rows by a single select field or by conditions) and Row height (Short, Medium, Tall or Extra tall). The magnifier finds text in the view. Drag a header's edge to resize a field, drag the header to move it, and use Pin to left in its menu to keep it in place while you scroll.

On a phone

  • A grid view stays a grid: scroll both ways, with the first field pinned at the left.
  • Tap a cell to select it and tap again to edit it. Single select, user and date fields open a picker from the bottom of the screen, without the keyboard.
  • Tap a row's number to open the record, and swipe left or right in it to go to the next or previous record. A long press on the number opens the row's menu.
  • The round + in the corner adds a record. Menus and panels open as sheets from the bottom.

Good to know

  • What you may edit follows your role and the base's permissions. Only owners add, change or delete fields.
  • Widths, field order and pinned fields are saved with the view when an owner changes them.
  • While you work in a row, it stays where it is even if a sort or filter would move it; it takes its place when you move to another row.

Related