SeaTable
  • Functions
  • Templates
  • Solutions
    • Marketing - – The next marketing campaign is bound to come. Nothing is easier than that.
    • Project management - – Plan, track and manage team projects from start to finish.
    • Human Resources - – Structure HR processes for new hires and onboarding.
    • Distribution - Manage your entire sales pipeline and customer relationships in one place.
    • Software development - Increase the quality and speed of your development team with SeaTable.
  • Support
    • Quick guide - – Everything you need to know to get SeaTable up and running in minutes.
    • Help area - – Find answers to your questions and get tips on how to get the most out of SeaTable.
    • Integrations - – Connect SeaTable with tools like Zapier, Integromat or n8n. Or use SeaTable's API.
    • SeaTable Blog - – Here you will find product information, news and many examples of how you can use SeaTable optimally.
  • Home Blog
  • Industries
    • Marketing
    • Project management
  • Topics
    • No Code / Low Code
    • Product Updates
    • Success stories
    • News
    • Productivity
  • Prices
  • Login
  • login
  • Registration
  • Menu Menu

Changelog

  • Version 3.4
  • Version 3.3
  • Version 3.2
  • Version 3.1
  • Version 3.0
  • Version 2.8
  • Version 2.7
  • Version 2.6
  • Version 2.5
  • Version 2.4
  • Version 2.3
  • Version 2.2
  • Version 2.1
  • Version 2.0
  • Version 1.9
  • Version 1.8
  • Version 1.7
  • Version 1.6
  • Version 1.5
  • Version 1.4
  • Version 1.3
  • Version 1.2
  • Version 1.1
  • Version 1.0

First steps

  • Get help Copy
  • What is SeaTable?
  • Create SeaTable account
  • First steps with SeaTable
  • Glossary of terms used by SeaTable
  • Get help

Quick guides

  • The home page of SeaTable
  • The first base
  • Templates
  • The elements of SeaTable at a glance

Personal settings

  • Personal settings
  • Change own password
  • Customizing the interface language
  • Customize avatar image
  • Unsubscribe from SeaTable notification emails
  • Enable 2-factor authentication

Use SeaTable

  • Use SeaTable
  • Introduction to working with bases and tables
  • Data acquisition
  • Cooperation
  • Views and plugins
  • Statistics and data analysis

Working with groups

  • Introduction to working with groups
  • Create a new group
  • Groups for collaboration
  • Add a team member to a group
  • Assign permissions in a group
  • Group members and their permissions
  • Rename a group
  • Change the order of the groups
  • Delete a group
  • Get workspace ID of a group
  • Transfer a group to another user

Working with bases

  • Bases
  • Create a new base
  • Creating a Base Using a Template
  • Duplicate an existing base
  • Delete a Base
  • Create a folder
  • Move a Base to a Folder
  • Copy a Base to a Group
  • Add a Base to Favorites
  • How to add a description to a base
  • Customize the appearance of a base (icon and color)

Working in tables

  • Add a table in a base
  • Move a table
  • Link tables with each other
  • table permissions set
  • Delete a table from a base
  • Restore a deleted table
  • Use of emojis in table name
  • Adding data via copy-and-paste
  • Search and replace values
  • Find a cell or value in a table
  • Keyboard shortcuts and key combinations

Data import

  • Data import and export
  • What import formats does SeaTable support?
  • Import Excel files into SeaTable
  • Data import using CSV in SeaTable
  • Data import from Microsoft Access into SeaTable
  • Data import from Google Sheets into SeaTable
  • Limitations of CSV/Excel import
  • Tips and tricks when importing CSV or XLSX files
  • Import CSV records into an existing base
  • Creating a base from a DTABLE file
  • Saving a base as a DTABLE file
  • DTABLE file format

History and versions

  • History and logs
  • Data recovery options with SeaTable
  • Restore a deleted Base
  • Retrieve tables, rows and columns from the recycle bin
  • Undo actions
  • Undo changes via the logs
  • Saving the current Base as a Snapshot
  • Restoring a snapshot

Working with columns

  • Overview of all column types
  • Adding a column
  • How to customize the column type
  • Customize the first column
  • The specifics of the first column
  • Adjust the number of fixed columns
  • Duplicate a column
  • Adding a column description
  • column permissions specify
  • Lock table header
  • Hide column arrows
  • Double the height of the table header

Text and numbers

  • The Text and Formatted Text columns
  • The numbers column
  • The Automatic Number column type
  • The email column
  • The URL column

Files and images

  • The file column
  • Differences between image and file column
  • The preview of image files
  • Delete images and files from a row
  • How to remove attachments permanently
  • Access to deleted attachments

Selection columns

  • Create a single selection column
  • Adding options to a single-selection column
  • Changing the order of single-selection options
  • Cascading a single selection
  • Export and import options in single or multiple selection columns
  • The checkbox column
  • The rating column

Links

  • How to link tables together in SeaTable
  • The Lookup Formula
  • The rollup formula
  • The Findmin formula
  • The Findmax formula
  • The Countlinks Formula

Formulas

  • Basics of SeaTable formulas
  • Formula example: Simple multiplication with a formula
  • Formula example: Merging text columns with the help of a formula
  • Formula example: Logical if operators for comparing values
  • Formula example: Search for a word in a text
  • Formula example: Calculate the duration of a vacation
  • Formula example: Calculate days to an event
  • Differences between formulas in Excel and SeaTable

Work with rows

  • Adding a row
  • Duplicate a row
  • Locking a row
  • Change the order of rows
  • Select multiple rows
  • Delete a row
  • Display of changes on a row
  • Copy the rows URL
  • rows comment
  • Print row details
  • The comment function in SeaTable

Date, duration and people

  • The date column
  • The duration column
  • The columns Creator and Created
  • The employee column
  • The "Last edited" and "Last edited" columns

Other columns

  • The geoposition column
  • The button
  • Send an e-mail via button
  • Save a PDF document by button in a column

Working with views

  • What is a view?
  • Grouping, sorting and filtering
  • Differences between private and normal views
  • Create a new view
  • Rename a view
  • Delete a view
  • Duplicating views
  • Printing a view
  • Change the order of views
  • Group views in folders
  • Pin views

View options

  • Filtering entries in a view
  • Link filter rules with AND and OR
  • Sorting entries in a view
  • Grouping entries in a view
  • The status-row and its functions
  • Adjust row height
  • Hide and move columns
  • Cell coloring
  • Color marking of rows
  • Lock views

Plugins

  • What is a plugin?
  • Activate a plugin in a Base
  • Calendar plugin guide
  • Create new calendar entries in the calendar plugin
  • Create multiple calendars for one Base
  • Gallery plugin guide
  • Add a new row via the gallery plugin
  • Timeline plugin guide
  • Kanban plugin guide
  • Statistics plugin guide
  • Map plugin guide

Page design plugin

  • Page design plugin tutorial
  • Static image
  • Static text
  • Dynamic elements
  • Table fields
  • Entries and pages
  • Header and footer

Web forms

  • Web forms
  • Creating a web form
  • Configuration options of a web form
  • Conditional display of individual form fields
  • Prefill form fields via URL

Releases

  • Base and view shares at a glance
  • Share a Base with a User
  • Release a Base to a Group
  • Create invitation link
  • Create external link for a base
  • Differences between invitation links and external links
  • Delete external links and invitation links
  • Release individual tables of a base
  • Create custom share
  • Sharing a view with a team member
  • Sharing a view with a group
  • Create external link for a view

Automations

  • Automation overview
  • Functionality of automations
  • Create an automation
  • Manage and edit automations
  • Show execution log of an automation
  • Stop automations
  • Delete automations
  • Automation Trigger
  • Automation actions
  • Why can't I find the automations in my base?

Automation examples

  • rows Add via automation
  • Add entries to other tables via automation
  • rows Lock by automation
  • Linking entries via automation
  • Email dispatch via automation

Notifications

  • Sense and purpose of notifications in SeaTable
  • Create notification rule
  • Edit and remove notification rules
  • Send notifications via automation
  • Delete all notifications or mark as read

Common data sets

  • Functionality of shared data sets
  • Create a common data set
  • Synchronization of a common data set
  • Create a new table with a common record
  • Add columns to a table created with a common data set
  • Sharing a common record with another group
  • Deleting a common record
  • Why do shared records only work in groups?

Data processing

  • Data processing operations in SeaTable
  • Create data processing operations
  • Perform data processing operations
  • Edit data processing operations
  • Delete data processing operations
  • Data processing: Calculate cumulative values
  • Data processing: Calculate changes
  • Data processing: Calculate ranking
  • Data processing: Calculate percentage
  • Data processing: compare and copy
  • Data processing: Transfer user name
  • Data processing: compare and link

Big Data

  • rows Move to the Big Data backend
  • To create a Big Data view
  • Enabling the Big Data backend in a Base

Team management and subscription

  • The functions of the team management in the overview
  • What subscription packages are available?

Team management

  • Add a new team member
  • Lock or delete a team member
  • Unlock a team member
  • Make a team member an administrator
  • Changing the team name
  • Groups and their members in the team management
  • Bases in the team management
  • View all access permissions of a Base
  • Empty the recycle bin in team management
  • Delete the complete team
  • Create a new group
  • base sharing Allow via invitation link
  • Force two-factor authentication for the entire team
  • Enable two-factor authentication for a team member
  • View the terms of use or privacy policy
  • Request an AV contract
  • Open a support ticket

Managing your subscription

  • Where can I find my invoices?
  • Plus or Enterprise subscription booking
  • Change current subscription: Customize package, duration and team size
  • Cancel the subscription
  • Customize billing address
  • Deposit of the tax ID
  • Change credit card
  • Payment by invoice
  • Discounts for public, non-profit or educational institutions
  • Is SeaTable free of charge? Can I try the Plus or Enterprise subscription?

Frequently asked questions

  • I have forgotten my password. Can I reset it?
  • The confirmation email does not arrive. What now?
  • Is it possible to merge two SeaTable accounts?
  • Can I use SeaTable offline?
  • What are the technical requirements of SeaTable Cloud?
  • Does SeaTable also have a dark theme (dark mode)?
  • How to subscribe or unsubscribe from the SeaTable newsletter?
  • What to do if you have exceeded the limits?
  • Why are there two release options in one Base?
  • How to export the base structure (e.g. for a forum entry)?
  • How do I find missing data in a Base?
  • How long are the different elements stored in SeaTable?
  • What is the difference between individual shares and shared records?
  • How to find out who added a row ?
  • What is the rows-ID?

Known problems

  • Blank page at page design plugin

Scripts, API and integrations

  • Overview of all integrations in and with SeaTable
  • What are webhooks and what do you use them for?

JavaScript & Python

  • Differences between JavaScript and Python scripts in SeaTable
  • Creating and deleting a script
  • Import and export of a script
  • Run script manually, by button or by automation
  • The execution log of scripts
  • Python example: Create a few random entries
  • Python example: Reading the metastructure of a base

Integrations within SeaTable

  • Set up Gmail to send emails via SMTP
  • Set up GMX or Web.de to send e-mails via SMTP

SeaTable API

  • Typical errors in dealing with the SeaTable API
  • Edit and delete an existing API token
  • Creating an API token
  • Introduction to the use of the SeaTable API
  • API tokens

Webhooks

  • Creating and deleting a webhook
  • Structure of the webhook data
  • Processing a webhook with the help of PHP
  • The secret key of a webhook
  • Deactivation of a webhook in case of errors

Automation platforms

  • Zapier Integration
  • Extensions
  • Home
  • Help
  • Use SeaTable
  • Views and plugins

Views and plugins

Contents
  • Table view
  • Advanced views
    • Statistics plugin
    • Other selected plugins
    • Calendar view
    • Timeline view
    • Map view
    • Gallery view

Depending on the task and the collected data, different display modes are useful to facilitate your work in SeaTable. SeaTable offers you views for this purpose on the one hand: Quantitative data is best captured in the table view, structured with filters, sorting and grouping, and analyzed with the help of statistics.

For the advanced types of data that you can store and organize in SeaTable, there are advanced views in the form of plugins. For example, for scheduling, the Timeline and Calendar prove to be particularly helpful. For images, the gallery is useful, and for geographic data, the map. A Kanban board makes sense especially for groupings of single selections.

In this post, learn which views and plugins are available, how you can use them, and for which use cases they are particularly suitable.

Table view #

SeaTable has a table view for the most common use cases. Here your data is recorded in a table consisting of rows and columns. The Table View is SeaTable's default view: when you open a Base, you first see your data in table form.

The Table View is essential for manually entering, editing and managing data in a Base: In it, you create the tables and define the column structure. Each column is assigned a type that captures specific data.

The table view is particularly suitable for displaying text- and number-based data. Using the available view settings such as grouping, sorting and filters, you can also perform simple evaluations very quickly.

In the status viewrow you can always see the number of rows and the column values. However, the table view does not offer any options for complex evaluations and the creation of diagrams.

Advanced views #

With the help of plugins, the table view can be supplemented with additional display options. These extend SeaTable's possible fields of application beyond the purely quantitative analysis of numerical data - enabling SeaTable to be used for use cases that a classic spreadsheet cannot cover.

Plugins allow you to view your data from different angles. In doing so, the data set always remains exactly the same, only the representation changes.

You activate the plugins via the Plugin Manager, which you open via the Plugins button in the top right corner of the Base header. You can learn how to add plugins to your Base here. Plugins are always activated only for the opened Base. You may have to repeat the activation of plugins in other Bases.

All SeaTable plugins (as of 08/08/2022)

Statistics plugin #

For advanced statistics, use the SeaTable plugin of the same name. It allows more complicated evaluations than are possible in the table view. In addition, it offers a wide range of graphical display options with a variety of supported chart types.

Extensive information about the statistical evaluation options can be found in the instructions for the statistics plugin.

More selected plugins #

With the calendar plug in and the timeline plugin you can keep track of your appointments and deadlines and organize projects successfully. With the Gallery plug in you manage images quickly and easily in your Base.

Display addresses and position data on a map using the Map plugin and visualize your tasks and project phases with the Kanban plugin. The Page Design plugin helps you quickly turn your records into laid out documents.

How helpful was this article?
Updated on 14 March 2023
CooperationStatistics and data analysis
Contents
  • Table view
  • Advanced views
    • Statistics plugin
    • Other selected plugins
    • Calendar view
    • Timeline view
    • Map view
    • Gallery view
SeaTable Logo

Do it like thousands of other people who use SeaTable to develop powerful processes, bring order to their data, and complete their tasks more efficiently.

SeaTable on Linkedin SeaTable on Medium.com SeaTable on Instagram SeaTable on Twitter SeaTable on Github SeaTable on YouTube SeaTable at Docker Hub

Products

  • SeaTable Cloud
  • SeaTable Dedicated
  • SeaTable Server
  • Support

Support

  • Quick guide
  • Help area
  • Templates
  • Integrations
  • Forum
  • Developer API
  • Status

Company

  • About us
  • We hire
  • Press
  • Contact
  • Blog
  • Imprint
  • Security
  • Data protection
  • Terms of use
  • EULA
Scroll up
  • Deutsch
  • Français
  • Español
  • Português
  • Русский