Using Table View

Avatar
Alica Kačengová

It’s very likely that you will be frequently using table view, as it is a default one to display your data. Learn how to make use of all of its capabilities.

Creating a New Table

To create a new table, click on Create new table button. Name your table and select icon and color for better visual orientation.

creating a table

Columns and Rows

After you enter the table view, you will see an empty table. It contains only two placeholders – one for entering new column names and one for entering your data (records).

basic table view with an empty table

If you type into the table header placeholder and press Enter, a new column will be created and the placeholder will move to the right.

using table view

You can resize and move the columns as you wish.

using table view - reordering columns

To add a row to the table, simply start typing into the row placeholder. After you press Enter, a new row will be created and the placeholder will move down.

adding data using table view

When entering values, you can get a small dropdown box showing you the existing records with similar content as you are entering. This is useful for example when creating a record for a new client, account, issue etc. to avoid duplications.

If you click on the little icon at the end of a column header (or right-click on the column header), you will see a context menu:

  • Displayed attribute is the main attribute which describes the record (row). E.g. for Tasks, it’s task name, for Employees, it’s employee’s name.
  • Changing attribute types and setting up functions are complex topics and are described in separate articles. 
  • Hiding/unhiding of columns is shown in the next animation.
setting attribute type

After you hide a column, three vertical dots are displayed instead of it, so that you can always easily unhide the column.

temporarily hide a column

If you right-click on a row, you will see another context menu. 

data cell context menu

Indent/outdent are useful for creating a hierarchy.

using hierarchies

Records (rows) from two tables can be linked together using the table view. The link between tables can have various meanings – that’s why it has a name. There can even be multiple links (or link types) between two tables, each with a different meaning. 

For example, tasks can be linked to the employees who are going to work on them, or they can be linked to the employees who are going to review them.

In this case, we only create a link between tables Tasks and Employees where the employee is an assignee of the task.

Click on the plus icon, select Create new link and give it a name.

creating a new link

When you start typing into the second table, you will get suggestions with the records that already exist in the second table.

adding linked records

We have removed the Assignee column from the Tasks table as the linked employee is an assignee. 

You can even link multiple employees to a single task by clicking on Add row above/below.

linking multiple rows

And you can also link the same employee to multiple tasks. The great advantage of this that you are not creating duplicate data – although one employee is displayed multiple times, it is still the same record. If you update that record in one place, it will get updated everywhere.

changing linked data

If you need to link an employee which is not in the Employees table yet, you can create a new record in the same screen.

using table view to link data

The newly added record will of course appear in the Employees table, too.

using table view

To remove the link between two rows, select Unlink row from the context menu.

unlinking data row

Next time you open the table and also want to display the linked table, you will find it after clicking on the plus button – Use existing link.

using an existing link

Settings

At any moment, if you want to change the configuration of your table, click the gear icon to get into table settings.

table settings