Edit the CRM table like a spreadsheet
Type straight into any cell, tick a contact's types, move with the arrow keys, choose and size the columns, add a sum under one, read and add notes, change many rows at once and open a contact beside the table.
Every table in the CRM works like a spreadsheet: All and each type. You change a value right where it is, without opening the contact.
Change a value
- Click a cell. An orange outline shows it is picked.
- Start typing, or press Enter. Text, numbers, amounts, emails, links and phone numbers are typed right in the cell. Amounts take 250k, 1.5M or 2,500,000.
- Press Enter to save and go down a row, or Tab to save and go right. Esc leaves the cell as it was.
A stage, a choice, a date, a team member or a linked record opens a short list under the cell: pick the new value. A checkbox flips with Enter or a click. Backspace clears a cell.
Use the arrow keys to move from cell to cell.
On All, the Type cell shows the types a contact is in. Press Enter on it to tick a type, which adds them at its first stage, or untick one, which asks first. Next step and Due show the contact's soonest next step across their types. Press Enter on either to change it in the type it comes from; when the contact is in several types and has no next step yet, pick the type first. A contact in no type has no next step: add them to a type first. Change the stage and amount on that type or on the contact's page.
Some cells can't be typed into. Selected, they show a grey outline instead of an orange one, and pressing Enter tells you why. Updated, Created, Kind and Last contacted are filled in for you, so their headers show a lock. A field that only means something for one kind, like Job title for people or Domain for organizations, is empty and read only on the other kind's rows. On Notes, Enter opens the contact's notes.
Choose the columns
- Click a column's name for Sort ascending, Sort descending, Filter on this field, Move left, Move right and Hide column. Workspace admins also get Rename field, which changes the field's name everywhere and keeps its values; built-in fields like LinkedIn can be renamed too. The dialog shows the field's API name: see Rename a field.
- Choose + at the end of the column names, or Columns in the bar: both open the same panel. Type in Search fields to find one. The columns in the table come first: drag them, or use the arrows, to change their order. The other fields follow under their group. The switch on each field shows or hides it. Reset to default shows every field again. Workspace admins also get New field at the foot, which asks who the field Shows for: Everyone or one type. See Add types, fields and stages.
- Every table has a Created column: on All the day the contact was created, on a type the day the contact joined it. On All, columns like Kind, Last contacted and Created can be switched on too. A text or link field for Everyone can be Each value only once: no two contacts then share its value, which suits a profile link or an id from another tool.
- Drag the right edge of a column name to make it wider or narrower. Double click the edge to put it back.
The columns you show, their order, their width and the calculations under them are saved with the view straight away, for everyone who uses it. On a view shared with the team, only workspace admins change them; for anyone else the change lasts until they leave the page. See Filter, sort and save a view.
The last row: count and calculations
The last row stays at the bottom of the table. Under Name it says how many rows the view and your search match, all of them, not only the rows on the screen. Under any other column, choose Add calculation for a Sum, an Average, the Earliest or Latest date, how many are Filled or Empty, and more; None takes it away. See Filter, sort and save a view.
There is no Load more: the next rows load by themselves as you scroll down.
Read and add notes from the table
The Notes column shows how many notes each contact has and the newest one. Each type shows it at the end; on All, switch it on in Columns.
- Click a row's notes. Its notes open on the right, newest first.
- Type in the note box and press Enter. The note is dated today and the column shows it straight away.
- The link at the foot opens the contact's full page. Esc closes the notes.
A row with no notes yet shows Add a note.
Change many rows at once
Tick the box at the start of each row, or the box above them all to tick every row. A bar at the bottom offers Change stage (on a type), Remove from that type, and Delete. Removing and deleting ask first.
Open a record beside the table
Click a name to open the contact on the right, with their Type pills and stages, every field, the note box and their history. The table stays where it was. Use the arrows at the top, or the up and down keys, to go to the row above or below, and Esc to close it. Open page opens the contact's full page; so does Open, next to each name.
On the phone app
The phone shows each type as rows grouped by stage, each with its newest note under it. Long press a row to change its stage, its amount or its next step without opening it. To choose which fields show under each name, tap the menu at the top right and pick Fields under each row: the first two switched on show, and the web's table shows the same fields.
