Depending on the task and the data collected, different display types are desirable. SeaTable offers different views for this purpose: Quantitative data is best edited in the table view and - in aggregated form - evaluated in the statistics view. For the extended data formats that you can store and organize in SeaTable, there are advanced views. For image data, the gallery view is useful, and for displaying a geographical distribution, the map view is useful. In project work, the timeline view and the calendar view prove to be particularly helpful.
In this article you will learn which views are available, how you can use the different views and for which applications they are particularly suitable.
Integrated views #
SeaTable has two built-in views for the most common SeaTable use cases.
In Table View, your data is collected and displayed in an intuitive table format consisting of rows and columns. Table view is SeaTable's default view. When you open a Base, this is what is used.
The table view is essential for manual data entry and for data management in a base: In it, you create and manage the tables of a base and define their data structures. Each table column is assigned a type and the column is moved to the desired position. (For more information on the data formats supported by SeaTable, see the article Column types in this section). You can also export and import individual tables via the table view.
The table view is particularly suitable for displaying text- and number-based data. Using the available view settings such as groupings, sorting and filters, simple evaluations can also be carried out very quickly in the table view.
The table view does not offer any options for complex evaluations and the creation of diagrams. For this, SeaTable offers a second integrated view.
The statistics view as the second integrated view of SeaTable allows more complicated evaluations than is possible in the table view with filters, groupings and sorting. In addition, it offers a variety of graphical display options with a large number of supported chart types.
You can access the statistics view via the icon of the same name in the upper right corner of the table view.
Extensive information about the evaluation options in the statistics view can be found in the article Statistics in this section.
Advanced views #
Plug-ins can be used to add further views to the integrated views. These expand the possible fields of application of SeaTable beyond the purely quantitative analysis of numerical data - use cases that a classic spreadsheet cannot satisfy.
You activate the plugins - for the extended views like all other plugins - via the Plugin Manager, which you open via the plugin icon at the top right of the table view. To add a view plugin, click Add Plugins at the bottom of the Plugin Manager and then select the desired plugin. Once you add it, it will be ready in the Plugin Manager and you can access the advanced view. To do this, simply click on the name of the plugin. If you use a view plugin frequently, then you can permanently pin it to the view settings using the three-dot icon to the right of the plugin name in the Plugin Manager.
Plugins are always activated for the active base only. You must repeat the activation of the plug-ins via the plug-in manager in other bases.
The calendar view plots the values from columns of the type Date onto a calendar. You can display individual dates or time periods marked by a start and end date.
Each table entry with a date value is displayed in the calendar. If a table contains multiple date values, then SeaTable selects one of the columns when the calendar view is first called.
Using the buttons at the top, you can scroll through the calendar and switch between a month and year view. A click on Today in the upper left corner takes you back to the calendar page of today. The current date is clearly highlighted in orange.
Via the settings, which you reach by clicking on the settings icon in the upper right corner, you can select the relevant date column(s). If you want to display only single dates on the calendar, then select the desired column in the Start date field. If you want to display time periods, then in addition to the start date, also select the column with the end date in the field of the same name. The Color Field selection field allows you to define the color of the entries in the calendar. You can choose from the single selection fields available in the table. If you do not make a color selection, all dates in the calendar will have the same color.
The timeline view represents the time periods in a timeline representation by a start and end date, or by a start date and a duration. This view is regularly called Gantt view after its inventor Henry Gantt.
Each table entry with the necessary date values is displayed in the timeline view. The order of the entries in the timeline view depends on the order of the entries in the underlying table view. To change or limit the order of the entries in the timeline view, use the sort and filter function.
Via the settings, which you can reach by clicking on the settings icon in the top right-hand corner, you can select the relevant date columns or the relevant date and duration column. You can define the colour of the entries in the Gantt chart via the Color column selection field. You can choose from the single selection fields available in the table. If you do not make a colour selection, all dates in the display have the same colour.
The map view displays geographical information on a map from Google Maps. Each displayable table entry is marked with a position marker on the map.
The map view can handle GPS coordinates as well as addresses. However, addresses must be unique in order to be displayed.
If you click on a position marker, the further information of the associated table entry is displayed. The map is otherwise operated in the same way as Google Maps: The map section can be enlarged and reduced using the +/- buttons. To move the map section, click on the map, hold down the mouse button and drag it.
Via the settings, which you reach by clicking on the settings icon in the top right-hand corner, you can specify the column in which SeaTable searches for an address. Via the selection field Colour you can define the colour of the position markers. You can choose from the single selection fields available in the table. If you do not select a colour, all position markers on the map have the same colour.
The gallery view displays entries in a grid as maps.
The gallery view is always helpful if your entries contain image material that can be enlarged and clearly displayed in this way. Below the images the name of the entry from the first column is displayed as well as a selection of further values of the table entry.
Via the settings, which you reach by clicking on the settings icon in the top right-hand corner, you can select the column that is used as the map title. You can also select other columns whose information is to be displayed on the maps.