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 extended data formats, which you can save and organize in SeaTable, there are extended views. For image data you can use the gallery view and for the representation of a geographical distribution you can use the map view. In project work, the timeline view and the calendar view prove to be particularly helpful.
In this article you will learn what views are available, how to use the different views and for which applications they are particularly suitable.
SeaTable has two built-in views for the most common uses of SeaTable.
Table View displays and captures your data in an intuitive tabular form consisting of rows and columns. Table View is SeaTable's default view. When you open a base, it 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 its data structures. To do this, you assign a type to each table column and move the column to the desired position. (For more information about the data formats supported by SeaTable, see the Column Types article in this section). You can also export and import individual tables using 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, even simple analyses can be carried out very quickly in Table View.
For complex evaluations and the creation of diagrams, the table view offers no options. SeaTable offers a second integrated view for this purpose.
The Statistics view, SeaTable's second integrated view, allows for more complicated analysis than the Table view with filters, groupings and sorting. In addition, it offers a wide range of graphical display options with a variety of supported chart types.
The statistics view can be reached via the icon of the same name in the upper right corner of the table view.
You can find extensive information about the evaluation options in the statistics view in the Statistics article in this section.
Plugins can be used to add further views to the integrated views. These extend SeaTable's capabilities beyond the purely quantitative analysis of numerical data - applications that a traditional spreadsheet cannot satisfy.
You activate the plugins - for the extended views as 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've added it, it's ready to go 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 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 periods marked by a start and end date.
Each table entry with a date value is displayed in the calendar. If a table contains more than one date value, SeaTable selects one of the columns when the calendar view is called for the first time.
The buttons at the top allow you to scroll through the calendar and switch between a month and year view. Clicking Today in the upper left corner will take you back to today's calendar page. The current date is clearly highlighted in orange.
Via the settings, which you can reach by clicking on the settings icon in the upper right corner, you can select the relevant date column(s). If you only want to display individual dates on the calendar, then 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 use the Color Field selection field 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 appointments in the calendar have the same color.
The Timeline view displays periods described by a start and end date or by a start date and duration in a timeline view. 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 upper right corner, you can select the relevant date columns or the relevant date and duration column. Via the selection field Color column you can define the color of the entries in the Gantt chart. You can choose from the single selection fields available in the table. If you do not make a color selection, all dates in the display have the same color.
The map view displays geographical information on a map from Google Maps. Each table entry that can be displayed is marked with a location marker on the map.
The map view handles GPS coordinates as well as addresses. However, addresses must be unique to be displayed.
If you click on a position marker, the further information of the corresponding table entry is displayed. Otherwise the map is 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 can reach by clicking on the settings icon in the upper right corner, you can specify the column in which SeaTable searches for an address. Via the selection field Color you can define the color of the position markers. You can choose from the single selection fields available in the table. If you do not select a color, all position markers on the map will have the same color.
The gallery view displays entries in a grid as cards.
The gallery view is always helpful if your entries contain visual material that can be enlarged and clearly displayed in this way. Below the images, the name of the entry from the first column and a selection of further values of the table entry is displayed.
Via the settings, which you can reach by clicking on the settings icon in the upper right corner, you can select the column that will be used as map title. You can also select other columns whose information is to be displayed on the maps.