Boards and tables: one copy of every record, shown the way you work

Search, filter, sort and group any list, add your own fields, and see the same records as a table, a Kanban, a Calendar, a Timeline or a Pivot. Change a record in one view and it changes in all of them.

Talk to SaphionExplore the platform
7 min read

Work usually ends up in several lists. The tasks are in a spreadsheet, the same tasks are on a wall board, and the dates are copied into a calendar by hand. Each copy drifts from the others, so nobody is sure which one is right.

In Saphion the records are the work, and a Board is how you look at them. An Action, a Project, a Contact or a Company is a record, kept once. A Board shows a set of records, and a view chooses how they are drawn: which records, in what order, grouped how and with which columns. Showing a record in two views does not copy it. Change it in one view and it is changed in every other.

Find the records you need

Every Board has the same tools along the top, so once you know one you know them all. Search finds records by their name and other text. Filter narrows them by any field. Sort orders the rows by one column, then by others to break ties. Group puts rows under headings with a count and a total. Columns chooses what shows, and Colour colours records by a field on views that can show colour.

The filters you choose stay in view as chips, such as Priority is High. Select a chip to change it, or its cross to remove it. For a field with a set list of values, such as Status or Assignee, you tick the values, and each one shows how many records hold it. The foot of the pop-up says how many records match, such as “8 actions match”.

My actions is a table. Its filters are chips, and the rows are grouped under headings with their counts.

Some pages are made of a filter. My actions is Actions where Assignee is me, and a Project’s Actions tab is Actions where Project is that Project. These sit at the top of the Filter pop-up with a lock, so you can see what the page fixes. A view may also open with defaults such as Status is not Completed. They show as rows inside Filter, so a record that is missing from a view can always be brought back from there.

What you change is yours. Your filters, sort, grouping and hidden columns are personal to you until the view itself is changed by someone who may. Another person who opens the same view still sees it as it was saved, and Reset to default hands the view back as it was.

One set of records, many views

Views are the tabs along the top of a Board. Choose + at the end of the row and Add view offers the layouts that the Board’s records can draw.

The views a Board can offer
ViewWhat it shows
TableRows and columns. Every Board has one, and it cannot be taken off.
KanbanCards in lanes, grouped by a status field. Drag a card to change its status, where you may.
CalendarRecords placed on a date field, as a Month, a Week or a Day.
TimelineRecords as bars from a start to a finish, by weeks or months.
WorkloadEach person’s capacity against the effort of the work due, on Boards whose records have a person and a date.
DashboardA saved Dashboard over the Board’s records.
FormA Form that takes records in, on Boards whose job is taking records in.
PivotCounts of records across a row field and a column field.

A view the records cannot draw yet stays in the menu, greyed, and says why. Some views ask you to choose a field first, such as the date a Calendar uses.

The same Actions as a Kanban, in lanes by status.

Drag a tab to reorder the views, or press Alt with an arrow key. A view can be Only me or shared with the Board’s own audience, and sharing a view never grants access to its records. Deleting a view removes only how the records were shown. The records stay.

Fields that fit the work

A field is one fact a record holds: a status, a date, a person, a cost. Each field is a column on a Board and a row in the record panel. Managers of a Board add the fields it needs. Choose + after the last column for the common types, or More fields to open the Field centre, which lists every type and previews it as it will look on the Board.

The types cover the usual facts: text, numbers, money, percentages, ratings and durations; a Status with a colour for each choice, Tags, a Person and a Date; checkboxes, links, emails, phone numbers, files and addresses. A Link to record connects a record to one on another Board. A Mirror shows a field from that record, a Rollup counts or totals the records that point here, and a Formula is worked out from the record’s other fields. Created, Updated and an Auto-ID, a stable reference with a prefix you choose, are Saphion’s own.

Every field is changed the same way in a table cell, in the record panel and in the create form. A value Saphion cannot read stays in its box with the reason beside it, and nothing is saved. A field can be required, and you can restrict who may see it or edit it. Delete a field and it moves to the Bin with its values, with Undo offered at once.

Work in the table

Select a cell to change its value. A value you may not change says why when you select it. Right-click a row for Open, Edit, Copy link, Duplicate, Archive and Delete record. Delete moves the record to the Bin and offers Undo. Tick several rows and act on them together from the bar that appears. A column’s Summary adds a total, count or other figure for each group or for the whole Board.

An editable table such as Actions or a Board’s table is now one stop for the Tab key. Tab into it once, then move between cells with the arrow keys, go to the start or end of a row with Home and End, to the first or last row with Ctrl+Home and Ctrl+End, and by a screen with Page Up and Page Down. A screen reader says which row and column you are in.

Long lists stay quick. A long table is as tall as its whole list from the start, so the scroll bar is right at once and rows do not jump. When a long table cannot read some of its rows, it says why where they should be, with Try again.

Make a Board of your own

Choose Creations, then New, then Board. Give it a name, choose its item type (a new blank Board, or a kind of record your Organisation already has) and its home. A Board made in your own Creations is private until you share it. A Board made in a Project or a Workspace is filed there, where that place’s people can open it.

A blank Board starts with a Name field. The dialog offers Status, Owner and Due date, and you tick the ones you want. From then on you add fields from any column’s menu and records with New. The Board’s More actions menu opens its Automations, and imports and exports Excel and CSV.

Setting a Board up can be undone. Renaming a Board, adding a field, changing a view or publishing a Form each show Undo, so a wrong turn costs one click.

Ask Beacon

You can do any of this in words. Ask Beacon, for example: “Add a Status field to the Site visits Board and group it by status.” “Show me the records on this Board with no owner.” “Add a section called Snagging to the Site visits Board.” Beacon works through the same Board you do, so a field it adds is a field you can see and change.

Who can do what

A Viewer reads. An Editor works in the records, renames the Board and changes its shared views. A Manager changes how the Board is built, including its fields, and archives or deletes it. On a Project’s Boards that access comes from the Project’s people. A view changes presentation, never access: you only see records you can open.

Some Boards, such as the first view of Actions, are Saphion’s own and cannot be changed for everyone. Save a personal view, or an additional shared one, instead.

A record is missing from my view. Has it been deleted?
No. Check you are on the view you expect, clear the search box and look at your filter chips, then open Filter and check the view’s default rows, such as State is not Archived. You also only see records you can open.
Where did my column go?
It is probably hidden. Open Columns and turn it back on. A column you hide is hidden only in your view of it.
Why can I not add a field or a shared view?
Changing how a Board is built needs Manager access to it. Ask someone who manages the Board, or make a personal view instead.

Availability

Boards and tables have been in Saphion since the first beta. The keyboard table, Undo for Board set-up and the fast long lists came with v0.11.3 and v0.11.4. Read the Boards, tables and views guide in the docs, or the Fields guide.

View all