Depending on the task and the data collected, different display types are desirable. SeaTable offers different views for this: 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 save and organise in SeaTable, there are extended views. The gallery view is suitable for image data and the map view for displaying a geographical distribution. 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.
SeaTable has two built-in views for the most common SeaTable use cases.
In Table View, your data is presented and collected in an intuitive table format consisting of rows and columns. The table view is SeaTable's default view. When you open a Base, this 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.
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 have added 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, you can permanently pin it to the view settings via 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 on a calendar. You can display individual dates or periods marked by a start and end date.
Each table entry with a date value is displayed in the calendar. If a table contains several date values, SeaTable selects one of the columns when the calendar view is first called up.
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 can reach by clicking on the settings icon in the top right-hand corner, you can select the relevant date column(s). If you only want to display individual dates on the calendar, select the desired column in the Start date field. If you want to display periods, then in addition to the start date, also select the column with the end date in the field of the same name. You can define the colour of the entries in the calendar using the Color Field selection field. You can choose from the single selection fields available in the table. If you do not make a colour selection, all appointments in the calendar have the same colour.
The timeline view displays periods described by a start and end date or by a start date and duration in a timeline representation. This view is regularly called the 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 pictorial material that can be enlarged and clearly displayed in this way. The name of the entry from the first column and a selection of other values of the table entry are displayed below the pictures.
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.