Build a Table

Engini’s tables serve as the central repository for consolidating all pertinent information and facilitating essential work processes. While the table structure is adaptable to accommodate the specific requirements of each team or organization, it consists of fundamental components, which will be elaborated upon in the documentation.

Create your table #

You can add one or more tables to the same workbook by clicking on ‘+’ and changing the name of the table from ‘New Table1’. 

• Tip: give the table a significant name.

Create Columns #

1. To add Column, simply click on the + sign in the far right of the table’s column section.
2. Choose the column type you want from the dropdown menu.
   You will be able to view various types of columns later in the guide.
3. Name the column.
4. Fill the rows with current data.
5. In order to do actions in a specific column, open an existing column menu in the right side of the column by clicking on the three dots:
   
   1. Duplicate
      You can add the same column directly to the right side. Click on ‘Duplicate’.
   2. Delete
      You can delete a column while clicking on ‘Delete’.
   3. Filter/Sort
      You can Filter / Sort the column. You will be able to learn how to sort and filter later in the guide.
   4. You can expand the column by clicking on the right side. The width of the column will be up to 1000px.
   5. Change the location of the column- change it location by dragging the column to its new location.

Sort & Filter #

Take your table customization up a notch with a filter. This feature lets you show off specific info in your table, tailored to your display needs.

1. Click on ‘Filter/Sort’.
2. Choose your filter criteria, in the example choose one of the names.
3. Apply your choice.
4. You can clear the filter.

• You can sort a field in a table by selecting the field and choosing whether the order will be descending or ascending. 

1. First, click on ‘Filter/Sort,’ then choose your sort criteria and finally, click ‘Apply’.
2. Choose your sort criteria (Descending / Ascending).
3. Apply your choice.
4. You can clear the sort.

To create a quick filter, click on the “Filter” icon on the top left side of the table:

1. Click on “Add new filter”
   
2. Choose the field from the drop down.
3. Choose the condition from the drop down.
4. Enter the value to compare it to. 
5. Click on the “save to view” button on the right side of the popup.

To create a quick sorting, click on the “Sort” icon on the top left side of the table:

1. Click on “Add new sort ”
2. Select the field you want to sort from the drop down.
3. Choose the sorting.
4. Click on the “save to view” button on the right side of the popup.

Views & Hide #

Enhance your data presentation by altering the view of the original table or creating an additional view. We let you filter various column types, like status, labels, text, people, numbers, and more. This approach gives you a new outlook on your data, leading to improved data readability and a better understanding of the most important info you need right now.

1. If you choose to filter one or more columns within the original table:
   • Click on ‘Hide’ on the top of the table.
     
   • Choose the columns you want to filter by removing the selected option in the check box.
   • Click on ‘Save to view’.
     
2. If you choose to filter one or more columns within a new view of table:
   • Click on Views on the top of the table.
   • Click on ‘Add new view’.
     
   • Name the new view.
   • Repeat the steps from Stage 1.
     Note: Ensure you’re in the correct view by clicking ‘Views’ to access all your views.

Types of Columns #

Status #

The status column is a key factor in planning, organizing and tracking all of your team’s work. The status allows you to easily see the status of the tasks.

You can edit the status labels according to your workflow. To do this:

1. Click on one of the Status columns cells.
2. Click the Edit Labels button at the bottom to modify the labels.
   1. Alter the displayed text to your preference.
   2. You can add more labels:
      • Write a new status in ‘New Label’
      • Click on ‘+’
      • To select a color, click on the desired option.
   3. Click on ‘New Label’.
   4. Click on ‘Apply’.

Note: The gray label is the default label that appears when an item is created. We recommend leaving the gray status label blank because setting a status to the gray label can cause confusion for users.

Tip: Use automation to streamline your workflow! You can effortlessly set up automations to update your team when a status changes, for example. You can learn more in this guide.

Labels #

serve to categorize and organize items. 

Text #

This column allows you to add any type of text such as names, short comments, phone number, address and more.

Date #

The date column allows you to set dates for your tasks, such as dates the items were created or due dates. You can choose to display the date with or without the time.

People #

The People column allows you to assign tasks to one or more users. This column type provides a visual representation of who is responsible for which tasks and gives ownership of tasks to your team.

Number #

You can use this column for anything related to a number: counter, budget, quantity of item, number of hours you spent on a task and more.

Checkbox #

Represents a binary choice according to conditions and settings. It can be checked or unchecked (empty). 

Connect Table #

The Connect tables Column allows you to easily link one or more tables to the current one that you are on. Furthermore, this column works along with the Mirror Column to help reflect data from a different table to the current one that you are on.

Mirror #

The Mirror Column collaborates with the Connect Tables Column to enable you to mirror columns from one board onto another. This functionality streamlines the process of implementing changes on one board, with these changes seamlessly reflected in both boards.

Created Log #

Adds the creator of the record and the date and time it was created. 

Updated Log #

Here, you can see who updated the record and the date and time it was updated. 

Link #

The Link Column allows you to add an hyperlink to any website. You have the flexibility to customize each item with a particular web address and the corresponding text to be displayed.