FATHOM

A deep-dive into all things ORCA.
From core concepts to advanced settings.

Records

Working with Records

A record is an individual entry inside a custom section. If a section is a spreadsheet, a record is a row. If a section is a contacts list, a record is a person. Records hold whatever data your template defines : text, dates, numbers, files, picklist values, and more.

Every custom section has its own records. Records in one section are independent of records in another, though they can be linked or converted between sections if your admin has configured that.


Creating a Record

Open any custom section and click the + New button in the top right. This opens a form built from the section's template. Fill in the fields and save : the record appears in the section index immediately.

You can also create a record by converting or cloning an existing record from another section.


The Record Show Page

Click any record in the list to open its show page. This is where everything about the record lives: its template fields, any linked contacts or companies, notes, to-dos, files, communications, and activity history.

Tabs or select list

Depending on how your ORCA instance is configured, the different sections of a record's show page are either displayed as tabs along the top or as a dropdown select list. This is a Super Admin setting and applies account-wide : if you'd like it changed, speak to your ORCA administrator.

Schedule event

Next to Edit, a button schedules a calendar event against the record. Until there is one it reads Schedule event. Once saved, the button shows the event's day and time instead (for example Fri 30 Oct · 09:00-12:00), greys when it's in the past, and opens the event to change. If the record has no event of its own but one on the calendar is linked to it, the button shows that event. When more than one is linked, it picks the next one coming up, or the latest if they've all passed. The edit form starts with the event's current title, start, end, type, assignees and notes filled in, in your account's time zone.

Linked records

A field that links to a record in another section shows that record's name as a link. On a timesheet, for example, the Job field opens the job. Follow the links to move between related records without going back through the lists. (In the list view the whole row opens the record, so linked names there are plain text.)

Lines

If a section's records have child records that belong to them, such as a job's estimate lines or supplier invoices, they show as an editable grid under the record's fields: click a cell to change it, Add a line, Add several, remove a line, with totals underneath. Lines can lock at certain stages, or when the record is frozen. This is a per-account module, so ask the ORCA team if you want it. See Line Items and Roll-ups.

Overview

The Overview button opens the record on one card: its stage, the fields that say what it is, its money (a margin worked out by a formula shows green, or red below zero), the first note, and a short list of each kind of record that links to it. On a job that might be its estimate lines with their total, its variations marked approved or rejected, its snags with who has them and when they're due, and the time booked to it. On a mandate it shows each counterparty list (buyers, lenders, investors) with how many are at each status, then the most recent with their status and date. Open to-dos follow, soonest first with overdue ones marked, then the latest messages filed on the record. Each list shows its first eight, then how many more. A list with a status board doesn't add up, because a rejected variation shouldn't count.

Everything on it is the record as it stands, worked out when you open it. You only see lists you're allowed to open, and so does anyone you send it to.

  • Download PDF saves it as an A4 PDF, for a client, a meeting or the file.
  • Email it to sends it to you or anyone on your account, with a note if you like. A reply goes to you. It can't be sent to anyone outside the account from ORCA: download the PDF and send that yourself.

In the demo accounts the PDF works but emailing is off.

Roll-up values

A field with a small Σ beside its value is a roll-up: a figure worked out from the record's lines (a total, count, lowest or highest). You can't type into it. It's added up again whenever a line changes. See Line Items and Roll-ups.

Ticklists

A Ticklist field shows its items with a tick box each. Tick one on the record page and it saves straight away, with who ticked it and when shown beneath. You need permission to edit the record to tick. A frozen record can't be ticked. Engineers see the same list as a job's scope on their Today card. See Creating Templates.

Files

Files on a record are private. Each thumbnail and file name links through ORCA, which checks that you're signed in and can see the record, then opens the file. Images, PDFs and video open in the browser. Word, Excel, CAD (DWG, DXF), zip, CSV and iPhone HEIC files download instead, and show as a file icon with the name. A link copied out of the page is no use to anyone for long, because the final address ORCA sends you to expires after ten minutes. Send people the record, not the file link.


Editing a Record

From the show page, click Edit to open the record in edit mode. You can update any of the template fields and save.


Field History

Every record has a History panel on its show page, below the to-dos and notes. Open it to see every field value that was set, changed or cleared, newest first, with who did it: a person, an API key (by its name), or ORCA itself when an automation or scheduled job made the change. Several changes one person makes in the same minute show as one entry.

History keeps the value as it read at the time, so an old entry still makes sense after a picklist option or company is renamed. Formula and AI summary fields aren't tracked, since ORCA works those out rather than anyone setting them. Values brought in by an import don't appear in the history; changes made after the import do.

ORCA AI can read the most recent changes too, so you can ask it what changed on a record.


Deleting a Record

From the edit screen, a Delete option appears at the bottom of the page. Deleting a record removes it permanently : there's no recycle bin, so check with the team before deleting anything shared.


By default, records in a section are displayed as a list. Depending on how the section has been set up, two additional views may be available: kanban board and gallery. The view switcher appears in the top right of the section index when one or more alternative views are enabled.

ORCA remembers which view you last used per section, so you only need to switch once.

List view

The default. Records appear as rows with columns defined by the template. Not every field needs to appear in the list : each field has a Show in List View toggle in the template settings, so admins can keep the list focused on the columns that matter most for scanning. See Creating Templates for details.

The list view also has a small toolbar of controls above the table:

  • Freeze - pins the first column (the record title) to the left edge so it stays visible as you scroll horizontally through a wide table. The button turns indigo when active. Click again to unfreeze.
  • Columns - opens a dropdown listing every visible field. Untick any column to hide it from the list; tick it again to bring it back. The button shows how many columns are currently hidden. The title column cannot be hidden.
  • Search - a search box in the section header filters the visible records. It matches against everything in the table (titles, picklist values, assigned user names, file names), and it also checks each record's linked contacts, so searching a name, email address, or postcode finds the record even when that detail isn't shown as a column. This is a quick local filter, separate from Global Search.

Both Freeze and Columns preferences are saved per section, so they persist across page loads without needing to be reset each visit. On smaller screens, Freeze and Columns collapse into a single ⚙ icon that opens a combined settings panel.

Filtering by status and assignee

Two more filters sit above the table:

  • Status - tick as many statuses as you want rather than picking one at a time. A pipeline with nine open stages can now answer "show me everything still live" in one go. Clear the selection to see everything again.
  • Assigned to - narrows the list to one person. It matches across every person field on the section, not just one, so filtering to yourself brings back anything with your name on it whether you're the owner, the surveyor, or the person who took the call.

The two stack, and both stack with the Hot List chips if your account has those configured.

Sorting

Click a column header to sort by it. Records with nothing in that column sort to the bottom in both directions, so sorting a half-filled score field ascending gives you the lowest scores rather than a screenful of blanks. An empty value is treated as absent, not as zero.

Kanban board

Records appear as cards arranged in columns, one column per picklist option. You can drag cards between columns to update a record's status without opening it. The board is useful for pipelines, project tracking, and anything where status is the primary thing you're managing at a glance.

Kanban has to be enabled per section in Settings, and relies on the section having a Group Records picklist configured. See Creating Sections for the setup steps, and Kanban Board for how to use it day to day.

Gallery view

Records appear as image cards using the first image from a file-type field. Useful for talent rosters, product catalogues, site photos, or anything where scanning visually is more practical than reading a table.

Gallery also has to be enabled per section in Settings, and requires the section's template to include at least one file field. See Creating Sections for the setup steps.


Finding the Records That Need Working

On a pipeline section, list view can also show the Hot List: filter chips and columns flagging what is overdue, what has gone quiet, and what has nothing booked against it at all. It's worked out live from date fields you already hold, and it only appears once someone has pointed it at those fields in Settings.

Previous
Sign-offs